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 plensr

        ON wsr.ips_item_id = plensr.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 plenru

        on wru.ips_item_id = plenru.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

*/