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
RichardMar
.
Toggle Highlighting
SQL
USE dewiki_p; select user_name, datediff(now(), rev_timestamp) from user join revision_userindex on rev_id = (SELECT rev_id FROM revision_userindex WHERE user_id = rev_user ORDER BY rev_timestamp DESC LIMIT 1) where user_name in ('Unfinishedchaos','Chrkl','RosarioVanTulpe','SpesBona','Lichtkind','Sippel2707','-jkb-','Carbenium','Nordmensch','Matt1971','Fantasy','Fire','Nol Aders','SteffenB','Stw','Tim Pritlove','Rdb','Carbenium','Wotan','Laurascudder','Florian Prischl','Chrkl','blane','Darev','Dodo von den Bergen','Leithian','Toblu','Katarighe','Ein Pädagoge','TheTokl','Victor Schmidt','Unukorno','Jorges','Barbarossa','Gangleri','Ziko','Tlustulimu','ThomasPusch','Zeno Gantner','Wotan','Emu','Hoch auf einem Baum','Emes','Darev','CroMagnon','SCPS','Arne List','Nol Aders','Rdb','Darev','Dodo von den Bergen','Toblu','Ein Pädagoge','Eloquenzministerium','Grand-Duc','Lupino','Rogi.Official','Drbreznjev','Fire','Fantasy','Nol Aders','Rdb','Chrkl','Emes','Ein Pädagoge','TheTokl','Dan Pelleg','Deu','Bangin','Chrkl','Toblu',' Karlis','Jcornelius','ThomasPusch','Vogone','Binningench1','Sankalpdravid','CdaMVvWgS','Nol Aders','Rdb','Ziko','Knorck','Timk70','Aphaia','TAXman','Pikku','Fire','Jorges','AN','J.Dygas','Herr Klugbeisser','Sei Shonagon','Vlado','Gangleri','Ceroi','Obersachse','Tlustulimu','J budissin','Albinfo','Ein Pädagoge','ArtanGruda','Hipi Zhdripi~dewiki','Chirlu','ClaesWallin','LZ6387','Wing','HardDisk','Dodo von den Bergen','Elya');
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...