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
