Giftbot_found_tagesschau

SQL

use dewiki_p;
SELECT distinct filter_url, 0 as ns, anr_page_id, lemma, 'tagesschau' as dom
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./http://www.tagesschau.de/%" and pf.page_namespace=1) as diskfilter
INNER JOIN 
        (SELECT lnel.el_to as anr_url, lnp.page_title as lemma, lnp.page_id as anr_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.anr_url and diskfilter.filter_title= leftside.lemma)

LIMIT 10000;
SQL

Checking query status...
