https://bugzilla.wikimedia.org/show_bug.cgi?id=61881
Bug ID: 61881 Summary: Possible wikidata merges Product: Tool Labs tools Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: Unprioritized Component: tsreports Assignee: valhall...@arctus.nl Reporter: valhall...@arctus.nl CC: maar...@mdammers.nl Web browser: --- Mobile Platform: --- https://tools.wmflabs.org/multichill/queries/wikidata/possible_merge.txt /* Make a list of items that might be mergable. Still have to filter out items that already have a link to the language */ connect wikidatawiki_p wikidatawiki.labsdb; SELECT CONCAT('* ', wbA.ips_site_page, ' - [[Q', wbA.ips_item_id, ']] & [[Q', wbC.ips_item_id, ']]') FROM wb_items_per_site AS wbA LEFT JOIN wb_items_per_site AS wbB ON (wbA.ips_item_id=wbB.ips_item_id AND NOT wbA.ips_site_id=wbB.ips_site_id) JOIN wb_items_per_site AS wbC ON (wbA.ips_site_page=wbC.ips_site_page AND NOT wbA.ips_site_id=wbC.ips_site_id) WHERE wbA.ips_site_id='nlwiki' AND wbB.ips_site_id IS NULL AND NOT EXISTS( SELECT * FROM wb_items_per_site AS wbD WHERE wbC.ips_item_id=wbD.ips_item_id AND wbD.ips_site_id='nlwiki'); -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l