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
.
This is a testing alternative for https://quarry.wmflabs.org/query/1298
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT page1.page_id, CONCAT("Q",epp1.epp_entity_id), revision1.rev_id, c.rev_timestamp, revision1.rev_user_text #, ips_site_id #, COUNT(links1.pl_from) FROM (SELECT * FROM wb_entity_per_page WHERE epp_redirect_target IS NULL) AS epp1 JOIN (SELECT page_id, page_title FROM page) AS page1 ON page1.page_id = epp_page_id JOIN (SELECT rev_page, rev_id, rev_timestamp FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS revision1 ON revision1.rev_page = page1.page_id # LEFT JOIN wb_items_per_site # ON ips_item_id = epp_entity_id # LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0) AS links1 # ON links1.pl_title = page1.page_title WHERE # ips_site_id IS NULL # AND rev_user <> 587697 # AND links1.pl_from IS NULL # AND NOT EXISTS ( SELECT * FROM revision AS revision2 WHERE revision2.rev_page = revision1.rev_page AND revision2.rev_comment LIKE '%sitelink-remove:%' AND revision2.rev_id > revision1.rev_id) /* AND NOT EXISTS ( SELECT * FROM pagelinks WHERE pl_title = page1.page_title AND pl_from_namespace = 0) */ GROUP BY page1.page_title ORDER BY revision1.rev_id LIMIT 500;
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...