war-ceb - Quarry

SQL

select cp.page_title, cbpr.pp_value, svpr.pp_value
from cebwiki_p.page cp
	LEFT JOIN cebwiki_p.langlinks cbl
    	ON cbl.ll_from = cp.page_id
left JOIN (SELECT * FROM cebwiki_p.page_props cbpp WHERE cbpp.pp_propname = 'wikibase_item') AS cbpr
		ON cbpr.pp_page = cp.page_id
join svwiki_p.page sp on cp.page_title=sp.page_title 
and cp.page_is_redirect = 0 AND cp.page_namespace = 0 and sp.page_is_redirect = 0 AND sp.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 
#and pp_value is not NULL AND 
cbl.ll_title IS NULL
#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...
