Low resolution images in vital articles

SQL

SELECT img_name AS Image, Pa.page_title AS Article, CASE WHEN lt_id THEN 1 ELSE 0 AS "NonFree"
FROM page Pv
JOIN pagelinks ON pl_from = Pv.page_id AND pl_namespace=0
JOIN page Pa ON Pa.page_namespace=0 AND Pa.page_title=pl_title
JOIN imagelinks ON il_from = Pa.page_id
JOIN image ON img_name = il_to AND img_width < 400 AND img_height < 300 AND img_name NOT REGEXP "\.(svg|ogg|mid)$" AND img_name != "Blank.png"
JOIN page Pi ON Pi.page_namespace=6 AND Pi.page_title=img_name
WHERE Pv.page_namespace=4 AND Pv.page_title="Vital_articles"
LEFT JOIN templatelinks ON tl_from=Pi.page_id AND tl_target_id= (SELECT lt_id FROM linktarget WHERE lt_namespace=10 AND lt_title="Non-free_media")
ORDER BY Image, Article
SQL

Checking query status...
