Untitled query #7718

SQL

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

Checking query status...
