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
Edgars2007
.
2016-04-28T00:22:39: Edgars2007 - 8187; Feens - 7772 415 2016-04-30T10:56:01: Edgars2007 - 8202; Feens - 7793 2016-05-10T11:24:47: Edgars2007 - 8246; Feens - 7896 2016-05-10T13:26:31: Edgars2007 - 8341; Feens - 7896 2016-05-10T16:39:09: Edgars2007 - 8563; Feens - 7896 667 2016-05-14T08:34:02: Edgars2007 - 8566; Feens - 7937 2016-05-19T11:17:02: Edgars2007 - 8570; Feens - 8005 2016-06-02T06:38:55: Edgars2007 - 8575; Feens - 8177 2016-06-22T13:42:10: Edgars2007 - 8589; Feens - 8399 2016-07-03T05:35:35: Edgars2007 - 8606; Feens - 8495 2016-07-25T07:30:52: Edgars2007 - 8898; Feens - 8696 2017-01-28T11:23:09: Edgars2007 - 9053; Feens - 9584 2017-11-20T04:47:34: Edgars2007 - 9132; Feens - 10102 2018-03-06T17:16:58: Edgars2007 - 9212; Feens - 10550 2018-05-03T14:46:18: Edgars2007 - 9293; Feens - 10740 2019-06-06T05:10:48: Edgars2007 - 12895; Feens - 11331 2019-09-21T17:46:39: Edgars2007 - 12929; Feens - 11492 2019-09-21T17:46:39: Edgars2007 - 12953; Feens - 11867
Toggle Highlighting
SQL
select now(); use lvwiki_p; SELECT r.rev_user, r.rev_user_text, COUNT(*) AS num_articles FROM revision r join page p on p.page_id=r.rev_page WHERE p.page_namespace=0 and p.page_is_redirect=0 and r.rev_parent_id=0 GROUP BY r.rev_user_text ORDER BY COUNT(*) DESC LIMIT 500;
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...