CEES MMXVI noobs since October MMXVI

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

SELECT author_id, COUNT(*) FROM azwiki_p.revision WHERE rev_user = 109369 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 109369 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bawiki_p.revision WHERE rev_user = 14090 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 14090 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bawiki_p.revision WHERE rev_user = 14326 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 14326 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bawiki_p.revision WHERE rev_user = 14049 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 14049 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bawiki_p.revision WHERE rev_user = 14599 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 14599 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bawiki_p.revision WHERE rev_user = 14946 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 14946 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bewiki_p.revision WHERE rev_user = 52007 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 52007 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bgwiki_p.revision WHERE rev_user = 191498 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 191498 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bgwiki_p.revision WHERE rev_user = 190576 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 190576 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM bgwiki_p.revision WHERE rev_user = 192758 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 192758 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM cswiki_p.revision WHERE rev_user = 335412 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 335412 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM elwiki_p.revision WHERE rev_user = 197879 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 197879 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM elwiki_p.revision WHERE rev_user = 194006 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 194006 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM elwiki_p.revision WHERE rev_user = 195603 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 195603 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM eowiki_p.revision WHERE rev_user = 116925 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 116925 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM kawiki_p.revision WHERE rev_user = 78137 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 78137 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM kawiki_p.revision WHERE rev_user = 76335 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 76335 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM lvwiki_p.revision WHERE rev_user = 53921 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 53921 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM rowiki_p.revision WHERE rev_user = 134408 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 134408 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM rowiki_p.revision WHERE rev_user = 370987 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 370987 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ruwiki_p.revision WHERE rev_user = 1883707 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 1883707 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ruwiki_p.revision WHERE rev_user = 1916055 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 1916055 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sahwiki_p.revision WHERE rev_user = 11484 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 11484 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sahwiki_p.revision WHERE rev_user = 11319 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 11319 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sahwiki_p.revision WHERE rev_user = 11349 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 11349 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sahwiki_p.revision WHERE rev_user = 11490 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 11490 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sqwiki_p.revision WHERE rev_user = 83868 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 83868 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sqwiki_p.revision WHERE rev_user = 82732 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 82732 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sqwiki_p.revision WHERE rev_user = 82722 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 82722 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM sqwiki_p.revision WHERE rev_user = 82202 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 82202 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM srwiki_p.revision WHERE rev_user = 164190 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 164190 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 312968 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 312968 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 309070 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 309070 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 306522 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 306522 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 315393 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 315393 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 317274 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 317274 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 319899 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 319899 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 243826 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 243826 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 311068 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 311068 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 313613 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 313613 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 320211 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 320211 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 316962 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 316962 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 312042 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 312042 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 304833 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 304833 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM ukwiki_p.revision WHERE rev_user = 252523 AND rev_timestamp > 20161001000000;
SELECT author_id, COUNT(*) FROM commonswiki_p.revision WHERE rev_user = 252523 AND rev_timestamp > 20161001000000;
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...
