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
Bdijkstra
.
Pages without an explicit category sort key in categories where more than 90% of them contain a comma.
Toggle Highlighting
SQL
USE nlwiki_p; SELECT page_namespace, page_title, cf.cl_to, cf.commas FROM page, ( # fraction of pages in a category having a comma in the sortkey SELECT cl_to, (COUNT(*) / (cat_pages+cat_subcats+cat_files)) AS commas FROM categorylinks, category WHERE cl_to=cat_title AND cl_sortkey_prefix REGEXP ',' GROUP BY cl_to HAVING commas > 0.9 AND commas < 1 LIMIT 250) cf, categorylinks cl WHERE page_id=cl.cl_from AND page_title REGEXP '^\\p{L}+(_\\p{L}+)+(_\\(.+\\))?$' AND page_title NOT REGEXP '^\\p{L}+_[IVX]+_van_\\p{L}+$' AND page_title NOT REGEXP '^\\p{L}+(_\\p{L}+)*_en_\\p{L}+(_\\p{L}+)*$' AND cl.cl_to=cf.cl_to AND cl.cl_sortkey_prefix='' ORDER BY page_namespace, page_title
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...