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
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT ct_id, ctd_name, rev_id, page_namespace, page_title, comment_text, rev_timestamp, actor_name FROM change_tag JOIN change_tag_def ON ctd_id = ct_tag_id JOIN revision ON rev_id = ct_rev_id JOIN page ON page_id = rev_page JOIN actor_revision ON actor_id = rev_actor JOIN comment_revision ON comment_id = rev_comment_id WHERE ( ctd_name = 'WE-Framework gadget' AND NOT comment_text LIKE '%WE-Framework gadget%' ) OR ( ctd_name = 'InfoboxExport gadget' AND ( rev_timestamp < 20170113141149 OR page_namespace <> 0 ) ) OR ( ctd_name = 'wikimedia-commons-app' AND ( rev_timestamp < 20180603055933 OR page_namespace <> 0 ) ) OR ( ctd_name = 'dataDrainer' AND ( rev_timestamp < 20190829142138 OR page_namespace NOT IN (0, 120) ) ) OR ( ctd_name = 'distributed-game' AND page_namespace NOT IN (0, 146) ) OR ( ctd_name = 'svwiki-DescriptionGadget' AND (page_namespace <> 0 OR comment_text NOT LIKE '%wbsetdescription-%sv%') ) OR ( ctd_name IN ('WikibaseJS-cli', 'WikibaseJS-edit') AND page_namespace NOT IN (0, 120, 146) ) ORDER BY ct_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...