Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Matěj Suchánek
.
https://phabricator.wikimedia.org/T63881
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT CONCAT('* ', wbA.ips_site_page, ' - [[Q', wbA.ips_item_id, ']] & ', GROUP_CONCAT(CONCAT('[[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 (CONCAT("Autor:",wbA.ips_site_page) = wbC.ips_site_page AND NOT wbA.ips_site_id = wbC.ips_site_id) WHERE wbA.ips_site_id = 'cswiki' AND wbC.ips_site_id = 'cswikisource' 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 = 'cswiki' ) GROUP BY wbA.ips_item_id
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...