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 CASE WHEN page_namespace=0 THEN "main" WHEN page_namespace=1 THEN "talk" WHEN page_namespace=2 THEN "user" WHEN page_namespace=3 THEN "user talk" WHEN page_namespace=4 THEN "wikipedia" WHEN page_namespace=5 THEN "wikipedia talk" WHEN page_namespace=6 THEN "file" WHEN page_namespace=7 THEN "file talk" WHEN page_namespace=8 THEN "mediawiki" WHEN page_namespace=9 THEN "mediawiki talk" WHEN page_namespace=10 THEN "template" WHEN page_namespace=11 THEN "template talk" WHEN page_namespace=12 THEN "help" WHEN page_namespace=13 THEN "help talk" WHEN page_namespace=14 THEN "category" WHEN page_namespace=15 THEN "category talk" WHEN page_namespace=828 THEN "module" WHEN page_namespace=819 THEN "module talk" WHEN page_namespace=100 THEN "vedika" WHEN page_namespace=101 THEN "vedika talk" ELSE "other" END as Namespace, 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 /* use tawiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as taperubari,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; use mlwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as mlperubari,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; use knwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as knperubari,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; use hiwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as hiperubari,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; use mrwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as mrperubari,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; use bnwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as bnperubari,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; use pawiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as paperubari,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; use guwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as guperubari,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; use aswiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as asperubari,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; use orwiki_p; 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",if(page_namespace=828,"module",if(page_namespace=829,"module talk",if(page_namespace=100,"vedika",if(page_namespace=101,"vedika talk","other")))))))))))))))))))) as orperubari,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...