Untitled query #7718

SQL

use dewiki_p;
SELECT filter_url, filter_title, filter_page_id
FROM 
       (SELECT substring(el_to,28) as filter_url, page_title as filter_title, page_id as filter_page_id
       FROM externallinks euf
        JOIN page pf on euf.el_from=pf.page_id
       WHERE el_index LIKE "http://invalid.dwl.giftbot./%" and pf.page_namespace=1) as talkfilter  -- about 528 000
WHERE not exists (SELECT *
        FROM externallinks lnel
                  JOIN page lnp on lnel.el_from=lnp.page_id and lnp.page_namespace=0
                 where talkfilter.filter_title=lnp.page_title
                 and talkfilter.filter_url=lnel.eu_to)
                 
LIMIT 10
SQL

Checking query status...
