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 AND 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

    INNER 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 NOT wsr.ips_item_id = wru.ips_item_id)

    JOIN (SELECT * FROM pagelinks WHERE pl_title = "Q4167410" AND pl_from_namespace = 0) AS pldis

        ON wsr.ips_item_id = pldis.pl_from and wru.ips_item_id = pldis.pl_from

#   JOIN ..... to work on tomorrow

/*WHERE ....

*/

/*

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

*/