WD merge: disambigs

SQL

USE wikidatawiki_p;
SELECT CONCAT('*',wsr.ips_site_page,' - [[Q',wsr.ips_item_id,']]')/*, 
CONCAT(wru.ips_site_page,' - [[Q',wru.ips_item_id,']]')*/
FROM (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE ips_site_id = "srwiki" 
          and ips_item_id not in (select ips_item_id from wb_items_per_site where ips_site_id = "ruwiki")) AS wsr
JOIN (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE ips_site_id = "ruwiki" 
          and ips_item_id not in (select ips_item_id from wb_items_per_site where ips_site_id = "srwiki")) AS wru 
          ON wsr.ips_site_page = wru.ips_site_page /*AND wsr.ips_item_id != wru.ips_item_id*/
#JOIN wb_entity_per_page ON wsr.ips_item_id = 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 = "Q4167410") as plen
		ON wsr.ips_item_id = plen.epp_entity_id
		and wru.ips_item_id = plen.epp_entity_id
        
#JOIN (SELECT * FROM pagelinks WHERE pl_title = "Q4167410" AND pl_from_namespace = 0) AS pldis
#		ON epp_page_id = pldis.pl_from /*and wru.ips_item_id = pldis.pl_from*/
        limit 200
/*
SELECT a.ips_item_id, b.ips_item_id, a.ips_site_page, b.ips_site_page 
FROM (SELECT ips_item_id, ips_site_page FROM wb_items_per_site WHERE not ips_item_id = ruwiki
AND ips_site_id = "'srwiki") a 
INNER JOIN (SELECT ips_item_id, ips_site_page FROM wb_items_per_site 
WHERE not ips_item_id = "srwiki" AND ips_site_id = "ruwiki") b ON a.ips_site_page = b.ips_site_page
*/
SQL

Checking query status...
