WD: cats to be merged

SQL

USE wikidatawiki_p;
SELECT CONCAT('*\\',ws.ips_site_page,' \\ [[Q',ws.ips_item_id,']]'), 
CONCAT('\\',wc.ips_site_page,' \\ [[Q',wc.ips_item_id,']]')
#count(wsr.ips_site_page)
FROM (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE ips_site_id = "warwiki" 
     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 = "warwiki")) AS ws
     ON #ws.ips_site_page = wc.ips_site_page
ws.ips_site_page = REPLACE(wc.ips_site_page, 'Kaarangay', 'Kategori')
where ws.ips_site_page like ('Kategori%')
/*
JOIN (SELECT * FROM pagelinks JOIN wb_entity_per_page ON epp_page_id = pl_from
		WHERE pl_namespace = 0 and pl_title = "Q4167836") as pls
		ON ws.ips_item_id = pls.epp_entity_id
JOIN (SELECT * FROM pagelinks JOIN wb_entity_per_page ON epp_page_id = pl_from
		WHERE pl_namespace = 0 and pl_title = "Q4167836") as plc
		on wc.ips_item_id = plc.epp_entity_id*/
SQL

Checking query status...
