Untitled query #16327

SQL

use plwiki_p;
SELECT p.page_title, enel.el_to, pp.pp_value
FROM page as p
JOIN externallinks as enel on enel.el_from = p.page_id
#join templatelinks tl on tl.tl_from=p.page_id and tl.tl_title="90minut.pl" and tl.tl_namespace=10 and tl.tl_from_namespace=0
JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P3605'
			AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0 AND wdpl.pl_from IS NULL
		and enel.el_to like "http://www.90minut.pl/kariera.php?id=%"
SQL

Checking query status...
