Untitled query #30503

SQL

SELECT page_namespace, (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 = 100 then 'Portal'
when page_namespace = 101 then 'Portal talk'
when page_namespace = 828 then 'Module'
when page_namespace = 829 then 'Module talk'
end) as namespace_name'
SQL

Checking query status...
