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
Matěj Suchánek
.
Toggle Highlighting
SQL
USE cswiki_p; SELECT page_title, COUNT(pl_from) FROM pagelinks JOIN page ON page_namespace = pl_namespace AND page_title = pl_title JOIN templatelinks ON tl_from = page_id WHERE tl_title = 'Pahýl' AND tl_namespace = 10 AND page_namespace = 0 GROUP BY page_title ORDER BY COUNT(pl_from) DESC LIMIT 100; /* SELECT linter_cat, COUNT(*), COUNT(DISTINCT linter_page) FROM linter GROUP BY linter_cat; SELECT linter_cat, COUNT(*), COUNT(DISTINCT linter_page) FROM linter JOIN page ON page_id = linter_page WHERE page_namespace IN (0, 10, 14) GROUP BY linter_cat; /* SELECT eu_entity_id, eu_aspect, COUNT(*) FROM wbc_entity_usage WHERE eu_aspect <> 'S' GROUP BY eu_entity_id, eu_aspect HAVING COUNT(*) >= 50 ORDER BY COUNT(*) DESC; */ /* SELECT page_namespace, page_title, eu_entity_id, eu_aspect FROM wbc_entity_usage JOIN page ON page_id = eu_page_id WHERE eu_aspect LIKE 'L.%' AND eu_aspect NOT IN ('L.cs', 'L.sk', 'L.en'); */
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...