use arwiki_p;

SELECT p1.page_title, il_to

FROM page p1

JOIN imagelinks

ON p1.page_id = il_from

inner join page p2

                on p2.page_title = il_to

                WHERE (NOT EXISTS(

                SELECT 1

                FROM image

                WHERE img_name = il_to))

                AND (NOT EXISTS(

                SELECT

                1

                FROM commonswiki_p.page

                WHERE p2.page_title = il_to

                AND p1.page_namespace = 6))

                AND p1.page_namespace = 0

                and p2.page_namespace = 6

                and p2.page_is_redirect = 0

                limit 10;