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
Chaduvari
.
Toggle Highlighting
SQL
select if(page_namespace=0,"main",if(page_namespace=1,"talk",if(page_namespace=2,"user",if(page_namespace=3,"user_talk",if(page_namespace=4,"wikipedia",if(page_namespace=5,"waiki_talk",if(page_namespace=6,"file",if(page_namespace=7,"file talk",if(page_namespace=10,"template",if(page_namespace=11,"template talk",if(page_namespace=12,"help",if(page_namespace=13,"help talk",if(page_namespace=14,"category",if(page_namespace=15,"category talk",if(page_namespace=8,"mediawiki",if(page_namespace=9,"mediawiki talk","other")))))))))))))))) as perubari,count(page_namespace) from page where page_is_redirect =0 -- page_id not in (select pp_page from page_props where pp_propname="disambiguation") group by page_namespace
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...
