Talk:MySQL queries

Jump to navigation Jump to search
Wikimedia Community Logo-Toolserver.svg

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

Is it possibile to list pages without any image through SQL?--Nickanc 20:53, 23 July 2012 (UTC)

SELECT page_title
FROM page
LEFT JOIN imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND il_from IS NULL
But this also excludes pages incidentally using images from a template like {{Bio-stub}} (blacklisting is a possibility). Dispenser 02:54, 30 July 2012 (UTC)