war-ceb - Quarry

SQL

select en.page_title, enpr.pp_value
from enwiki_p.page en
	LEFT JOIN enwiki_p.langlinks enl
    	ON enl.ll_from = en.page_id
left JOIN (SELECT * FROM enwiki_p.page_props cbpp WHERE cbpp.pp_propname = 'wikibase_item') AS enpr
		ON enpr.pp_page = en.page_id
join cebwiki_p.page cp on cp.page_title=en.page_title 
and cp.page_is_redirect = 0 AND cp.page_namespace = 0 and en.page_is_redirect = 0 AND en.page_namespace = 0/*
left JOIN (SELECT * FROM svwiki_p.page_props svpp WHERE svpp.pp_propname = 'wikibase_item') AS svpr
		ON svpr.pp_page = sp.page_id*/
where enl.ll_title IS NULL
#and pp_value is not NULL AND 
#and ll_from not in (select m.ll_from from langlinks m where m.ll_lang="uk")
group by ll_from
SQL

Checking query status...
