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, page_len/*, COUNT(pl_from)*/ FROM page # LEFT JOIN pagelinks # ON pl_title = page_title AND pl_from_namespace = 0 LEFT JOIN templatelinks AS stub ON stub.tl_title = "Pahýl" AND stub.tl_from = page_id AND stub.tl_from_namespace = 0 LEFT JOIN templatelinks AS dab ON dab.tl_title LIKE "Rozcestník%" AND dab.tl_from = page_id AND dab.tl_from_namespace = 0 LEFT JOIN templatelinks AS cv ON stub.tl_title = "Copyvio" AND cv.tl_from = page_id AND cv.tl_from_namespace = 0 WHERE stub.tl_from IS NULL AND dab.tl_from IS NULL AND cv.tl_from IS NULL AND page_is_redirect = 0 AND page_len < 400 AND page_namespace = 0 GROUP BY page_title ORDER BY page_len;
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...