Talk:MySQL queries

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)

Start a discussion about MySQL queries

Talk pages are where people discuss how to make content on MediaWiki the best that it can be. You can use this page to start a discussion with others about how to improve MySQL queries.

Start a discussion

Add topic