Untitled query #20131

SQL

SELECT CONCAT('',svwiki_p.page.page_title,'') AS cebwiki,
	CONCAT ('Scebwiki'), 
		CONCAT('',cebwiki_p.page.page_title,'') AS cebwiki
FROM svwiki_p.page
JOIN cebwiki_p.page
ON svwiki_p.page.page_title = cebwiki_p.page.page_title
LEFT JOIN cebwiki_p.langlinks
ON ll_from = cebwiki_p.page.page_id
LEFT JOIN (SELECT * FROM cebwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = cebwiki_p.page.page_id
#LEFT JOIN cebwiki_p.templatelinks
#ON tl_from = cebwiki_p.page.page_id
WHERE (cebwiki_p.page.page_namespace = 0)
AND cebwiki_p.page.page_is_redirect = 0
AND svwiki_p.page.page_namespace = 0
AND svwiki_p.page.page_is_redirect = 0
AND ll_title IS NULL
AND pp_value IS NULL

GROUP BY svwiki_p.page.page_title, cebwiki_p.page.page_title;
SQL

Checking query status...
