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
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 ('termbox', 'wikidata-ui', 'WikibaseJS-cli', 'WikibaseJS-edit') AND page_namespace NOT IN (0, 120, 146) ) OR ( ctd_name IN ('client-automatic-update', 'client-linkitem-change') AND page_namespace <> 0 );
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...