use dewiki_p;

SELECT filter_url, filter_title, filter_page_id

​

        (SELECT substring(el_to,28) as filter_url, page_title as filter_title, page_id as filter_page_id

        FROM externallinks as euf INNER JOIN page as pf on euf.el_from=pf.page_id

        WHERE el_index LIKE "http://invalid.dwl.giftbot./%" and pf.page_namespace=1) as diskfilter

LEFT JOIN 

        (SELECT eu_to, page_title, page_id 

         FROM externallinks as lnel INNER JOIN page as lnp on lnel.el_from=lnp.page_id and lnp.page_namespace=0) as leftside

ON (diskfilter.filter_url= leftside.eu_to and diskfilter.filter_title= leftside.page_title)

WHERE leftside.page_id is null

LIMIT 10