Toggle navigation
βeta
Home
New Query
Recent Queries
Discuss
Database tables
MediaWiki
Wikibase
Replicas browser and optimizer
Login
Fork
Fork of
Number of Lexemes on Wikidata
by
Lucas Werkmeister (WMDE)
This query is marked as a draft
This query has been published
by
Vesihiisi
.
SQL
USE wikidatawiki_p; SELECT actor.actor_name as Username, COUNT(actor.actor_name) AS cnt FROM page JOIN revision ON page.page_id=revision.rev_page JOIN actor ON revision.rev_actor=actor.actor_id WHERE page.page_namespace=146 AND revision.rev_parent_id=0 # No parent rev = page creation GROUP BY actor.actor_name ORDER BY cnt DESC #LIMIT 20;
By running queries you agree to the
Labs ToS
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
All SQL code is licensed under
CC0 License
.
Checking query status...