T272900 - Quarry

This query is marked as a draft This query has been published by Matma Rex.
SQL

use enwiki_p;

select _cur_tag_order, _new_tag_order, rev_id as _example_rev_id, count(rev_id) as _number_of_occurrences
from (
	select
		rev_id,
		group_concat( cast(ctd_name as char) order by ct_tag_id) as _cur_tag_order,
		group_concat( cast(ctd_name as char) order by field(ctd_name,
			'huggle','ProveIt edit','WPCleaner','STiki','AWB','bot trial','Image up for deletion on Commons','WikiLoop Battlefield','discretionary','self-published source','self-published-blog','RedWarn','twinkle','Manual revert','editProtectedHelper','large non-free file','possible birth or death date change','mw-contentmodelchange','mw-new-redirect','mw-removed-redirect','mw-changed-redirect-target','mw-blank','mw-replace','mw-rollback','mw-undo','mw-manual-revert','mw-reverted','centralnotice','centralnotice translation','massmessage-delivery','visualeditor','visualeditor-wikitext','visualeditor-needcheck','visualeditor-switched','wikilove','mobile edit','mobile app edit','android app edit','ios app edit','mobile web edit','advanced mobile edit','pagetriage','discussiontools','discussiontools-reply','discussiontools-edit','discussiontools-newtopic','discussiontools-source','discussiontools-visual','fileimporter-remote','contenttranslation','contenttranslation-v2','campaign-external-machine-translation','OAuth CID: 99','OAuth CID: 678','OAuth CID: 542','OAuth CID: 593','OAuth CID: 1024','OAuth CID: 1003','OAuth CID: 1013','OAuth CID: 1015','OAuth CID: 115','OAuth CID: 142','OAuth CID: 144','OAuth CID: 150','OAuth CID: 151','OAuth CID: 154','OAuth CID: 159','OAuth CID: 194','OAuth CID: 206','OAuth CID: 21','OAuth CID: 211','OAuth CID: 212','OAuth CID: 218','OAuth CID: 236','OAuth CID: 239','OAuth CID: 251','OAuth CID: 252','OAuth CID: 259','OAuth CID: 261','OAuth CID: 263','OAuth CID: 274','OAuth CID: 278','OAuth CID: 285','OAuth CID: 297','OAuth CID: 306','OAuth CID: 314','OAuth CID: 320','OAuth CID: 376','OAuth CID: 410','OAuth CID: 429','OAuth CID: 473','OAuth CID: 540','OAuth CID: 543','OAuth CID: 563','OAuth CID: 60','OAuth CID: 612','OAuth CID: 628','OAuth CID: 64','OAuth CID: 651','OAuth CID: 67','OAuth CID: 670','OAuth CID: 679','OAuth CID: 76','OAuth CID: 817','OAuth CID: 85','OAuth CID: 860','OAuth CID: 861','OAuth CID: 874','OAuth CID: 951','OAuth CID: 1188','OAuth CID: 1224','OAuth CID: 1232','OAuth CID: 1261','OAuth CID: 1277','OAuth CID: 1352','OAuth CID: 1359','OAuth CID: 1365','OAuth CID: 1389','OAuth CID: 1413','OAuth CID: 1452','OAuth CID: 1503','OAuth CID: 1436','OAuth CID: 1566','OAuth CID: 1745','OAuth CID: 1779','OAuth CID: 1804','OAuth CID: 1805','OAuth CID: 1784','OAuth CID: 1703','OAuth CID: 1887','OAuth CID: 1809','OAuth CID: 1841','OAuth CID: 1904','OAuth CID: 2008','Possible vandalism','posted screed','Page creator removing CSD tag','deprecated source','possible vandalism','WikiLeaks','new user modifying archives','missing file added','unsourced AFC submission','congressedits','Citing predatory open access journal','removal of COI template','removal of copyvio templates','Possible disruption','disambiguation template removed','contenttranslation-needcheck','possible link spam','wikilinks removed','possible unreferenced addition to BLP','External Link added to disambiguation page','large plot addition','canned edit summary','extraneous markup','de-userfying','Possible self promotion in user or draftspace','discretionary sanctions alert','nowiki added','userspace spam','changing height or weight','possible libel or vandalism','Possible self promotion in userspace','End of page text','non-English content','Extraneous formatting','reverting anti-vandal bot','Rapid reverts','adding email address','bad external','large unwikified new article','removal of articles for deletion template','Section blanking','possible cut and paste move','coi-spam','autobiography','categories removed','removal of Category:Living People','unusual redirect','very short new article','reference list removal','references removed','image template removal','shouting','talk page blanking','blanking','removal of speedy deletion templates','self-renaming and bad user talk moves','abusefilter-condition-limit')
		) as _new_tag_order
	from revision
	join change_tag on rev_id=ct_rev_id
	left join change_tag_def on ct_tag_id=ctd_id
	where rev_timestamp between '20210111' and '20210124'
	and rev_deleted=0
	group by rev_id
	having _cur_tag_order != _new_tag_order
) a
group by _cur_tag_order
order by _number_of_occurrences desc
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.
SQL

Checking query status...
