NS wise page count

This query is marked as a draft This query has been published by Chaduvari.
SQL

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;
select page_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.
SQL

Checking query status...
