Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
wd
by
Edgars2007
This query is marked as a draft
This query has been published
by
Hanhaohh
.
From http://quarry.wmflabs.org/query/3811
Toggle Highlighting
SQL
USE lvwiki_p; SELECT page_title, page_namespace, COUNT(DISTINCT eu_entity_id), COUNT(eu_aspect), eu_touched FROM wbc_entity_usage JOIN page ON page_id = eu_page_id GROUP BY eu_page_id ORDER BY COUNT(DISTINCT eu_entity_id) DESC, COUNT(eu_aspect) DESC, page_title LIMIT 40;
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...