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