war-ceb - Quarry

SQL

select cp.page_title, cp.pp_value, sv.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
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 page_is_redirect = 0 AND page_namespace = 0 
#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...
