Untitled query #19303

SQL

SELECT DISTINCT lvwiki_p.imagelinks.il_to
        FROM lvwiki_p.imagelinks, commonswiki_p.image, commonswiki_p.categorylinks, commonswiki_p.page
        WHERE lvwiki_p.imagelinks.il_to = commonswiki_p.image.img_name
        AND commonswiki_p.image.img_name = commonswiki_p.page.page_title
        AND commonswiki_p.categorylinks.cl_from = commonswiki_p.page.page_id
        AND commonswiki_p.categorylinks.cl_to in  ( 'Other_speedy_deletions','Copyright_violations','Items_with_disputed_copyright_information','Pending_fair_use_deletes','Possibly_out_of_scope')
        AND NOT EXISTS(
            SELECT  1
            FROM lvwiki_p.image
            WHERE lvwiki_p.image.img_name = lvwiki_p.imagelinks.il_to
        )
        ORDER BY lvwiki_p.imagelinks.il_to
SQL

Checking query status...
