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
PiRSquared17
.
Toggle Highlighting
SQL
use metawiki_p; SELECT (case when page_namespace = -2 then 'Media' when page_namespace = 0 then '' when page_namespace = 2 then 'User' when page_namespace = 4 then 'Meta' when page_namespace = 6 then 'File' when page_namespace = 8 then 'MediaWiki' when page_namespace = 10 then 'Template' when page_namespace = 12 then 'Help' when page_namespace = 14 then 'Category' when page_namespace = 200 then 'Grants' when page_namespace = 202 then 'Research' when page_namespace = 206 then 'Iberocoop' when page_namespace = 470 then 'Schema' when page_namespace = 482 then 'Config' when page_namespace = 828 then 'Module' when page_namespace = 866 then 'CNBanner' when page_namespace = 1198 then 'Translations' when page_namespace = 2300 then 'Gadget' when page_namespace = 2302 then 'Gadget definition' end) as ns, page_title FROM page WHERE ( (page_namespace != 1198) AND ((page_namespace % 2) = 0) AND (page_title LIKE "%/fr") )
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...