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
Cryptic
.
https://en.wikipedia.org/w/index.php?title=Wikipedia:Request_a_query&diff=768148748&oldid=767162645
Toggle Highlighting
SQL
SELECT rev_user, DATE_FORMAT(MAX(rev_timestamp), '%Y-%m-%d') AS 'last edit' FROM revision_userindex WHERE rev_user IN ( -- raw data from queries #8689 and #9134, part 1/10 79, 4295, 5094, 5705, 7872, 12176, 15143, 26248, 31530, 35752, 38427, 53396, 54890, 59944, 69412, 70142, 82697, 84612, 86163, 90397, 90814, 120801, 135518, 136926, 150564, 153741, 154991, 158840, 161735, 167187, 169932, 191017, 202394, 218166, 221304, 242472, 244713, 246230, 254396, 262675, 270405, 278097, 282582, 288189, 299408, 302457, 306659, 318807, 323105, 334887, 342294, 342538, 346308, ) GROUP BY rev_user;
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...