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
Cenarium
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT CONCAT("[[Special:Contributions/",user_name,"|",user_name,"]]") AS User, user_editcount AS Edit_Count FROM user WHERE user_id IN ( 1, 70, 79, 182, 188, 206, 300, 325, 372, 540, 578, 637, 1176, 1228, 1398, 2496, 3071, 3371, 3631, 3870, 4081, 4135, 4259, 4375, 4492, 4709, 4998, 5116, 5166, 5314, 5681, 5705, 5717, 5862, 6019, 6269, 6379, 6458, 6549, 6627, 6707, 6716, 6815, 6921, 6995, 7095, 7509, 7723, 7862, 8072, 8405, 8858, 8926, 9177, 9384, 9565, 9673, 9864, 9897, 9932, 10016, 10051, 10106, 10225, 10481, 10795, 10857, 10876, 10903, 11096, 11404, 11639, 12176, 12316, 12965, 13662, 13976, 14086, 14276, 14544, 14772, 15138, 15348, 15370, 15590, 16075, 16276, 16710, 16824, 16974, 17092, 17145, 18123, 18242, 18500, 18620, 19217, 19235, 19619, 19940, 20134, 20659, 20726, 21047, 21150, 21397, 21492, 21563, 22540, 23204, 23736, 24183, 24198, 24204, 25013, 25298, 25568, 26068, 26248, 26670, ) AND (SELECT rev_timestamp from revision_userindex where rev_user = user_id AND rev_timestamp > DATE_ADD(NOW(), INTERVAL -360 DAY) ORDER BY rev_timestamp IS NULL, rev_timestamp DESC LIMIT 1) IS NULL ORDER BY user_editcount;
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...