use dewiki_p;

SELECT filter_url, filter_title

FROM 

        (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

INNER JOIN (SELECT substring(euf.el_to,29+15) as found_url, pf.page_title  as found_title

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

        WHERE el_index LIKE "https://org.archive.web./web/______________/%" 

        and pf.page_namespace=0

        UNION

        SELECT substring(euf.el_to,20+15) as found_url, pf.page_title  as found_title

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

        WHERE el_index LIKE "https://is.archive./______________/%" 

        and pf.page_namespace=0    

           ) as found 

ON ((diskfilter.filter_url = found.found_url) and    (diskfilter.filter_title =found.found_title))     

LEFT JOIN 

        (SELECT lnel.el_to, lnp.page_title, lnp.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.el_to and diskfilter.filter_title= leftside.page_title)

WHERE leftside.page_id is null

LIMIT 26000;