lonely sv in WD = ceb

SQL

USE wikidatawiki_p;
SELECT CONCAT('*\\',ws.ips_site_page,' \\ [[Q',ws.ips_item_id,']]'), count(ws.ips_site_page),
CONCAT('\\',wc.ips_site_page,' \\ [[Q',wc.ips_item_id,']]'), count(wc.ips_site_page)
FROM (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE ips_site_id = "cebwiki" 
     and ips_item_id not in (select ips_item_id from wb_items_per_site where ips_site_id = "svwiki")) AS wc
JOIN (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE ips_site_id = "svwiki" 
     and ips_item_id not in (select ips_item_id from wb_items_per_site where ips_site_id = "cebwiki")) AS ws
     ON ws.ips_site_page = wc.ips_site_page
having count(ws.ips_site_id)<2
SQL

Checking query status...
