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
Martin Urbanec
.
Toggle Highlighting
SQL
use cswiki_p; select count(*), rev_user_text, left(rev_timestamp, 6) from revision where rev_user!=0 and rev_user not in (332111,330953,283014,289842,293681,273861,330851,336005,270660,282257,300722,283817,317467,282258,348371,330966,331446,270020,324145,336112,334945,269300,317500,335887,335902,284984,283935,330967,330846,273855,332385,289013,297090,330968,349219,348398,324232,300715,283032,282877,348716,348372,347748,124626,324148,334943,331441,325790,335841,273854,330844,273853,335692,281884,335796,331450,326291,274681,282626,282255,331439,284797,348401,222926,282256,270663,290678,314096,295186,326997,274680,289012,281887,296976,344090,293549,314315,168874,293917,348238,293916,293510,286580,281885,348717,269301,285820,282254,292697,274057,300716,331442,335907,161915,317501,238009,335804,317499,327987,316254,282878,300717,296058,283970,331962,270668,300724,330963,314110,340176,331447,332169,330969,274058,334944,348377,300718,289010,321898,275473,273857,282876,332881,326287,270661,348695,270383,273852,335990,283236,327990,281995,324248,281993,281886,292694,270667,335801,325792,269299,281998,289973,331121,330962,325789,334947,300725,324177,289843,289848,324146,282875,284781,335955,270757,284780,287443,331451,270658,269296,324477,283025,327996,273148,146865,331436,282885,330726,274682,32153,324143,300723,331440,274678,335805,290715,289844,314135,269297,273860,348399,277996,330849,300719,326999,327003,276259,282920,270970,314293,327993,347668,327988,332089,327985,347285,292695,331443,331445,314143,331449,250193,331438,270662,283036,296980,329525,296981,272895,297089,283012,292696,330961,283818,273851,281999,327994,336101,85654,270664,336008,335906,324144,331444,331435,324185,324244,290669,283936,276463,283011,330843,348710,273720,348373,289011) group by left(rev_timestamp, 6), rev_user having count(*)>=100;
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...