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
Jura1
.
Toggle Highlighting
SQL
# test # See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg use wikidatawiki_p; SELECT pp1.pp_sortkey, SUM(CASE WHEN pp1.pp_sortkey = 0 THEN 1 ELSE 0 END) AS "0", SUM(CASE WHEN pp1.pp_sortkey = 1 THEN 1 ELSE 0 END) AS "1", SUM(CASE WHEN pp1.pp_sortkey < 6 THEN 1 ELSE 0 END) AS "2-5", SUM(CASE WHEN pp1.pp_sortkey < 11 THEN 1 ELSE 0 END) AS "6-10", SUM(CASE WHEN pp1.pp_sortkey > 10 THEN 1 ELSE 0 END) AS ">10", COUNT(*) FROM page_props As pp1, page_props As pp2 WHERE pp1.pp_propname="wb-claims" AND pp2.pp_propname="wb-sitelinks" AND pp2.pp_sortkey = 0 AND pp1.pp_page = pp2.pp_page GROUP BY pp1.pp_sortkey;
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...