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
ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ
.
Toggle Highlighting
SQL
select ROW_NUMBER() OVER(order by pt_namespace asc, pt_title asc) num, -- get row number CONCAT('[[', case when pt_namespace = 2303 then 'Gadget definition talk:' when pt_namespace = 2302 then 'Gadget definition:' when pt_namespace = 2301 then 'Gadget talk:' when pt_namespace = 2300 then 'Gadget:' when pt_namespace = 829 then 'Module talk:' when pt_namespace = 828 then 'Module:' when pt_namespace = 710 then 'TimedText:' when pt_namespace = 711 then 'TimedText talk:' when pt_namespace = 119 then 'Draft talk:' when pt_namespace = 118 then 'Draft:' when pt_namespace = 101 then 'Portal talk:' when pt_namespace = 100 then 'Portal:' when pt_namespace = 15 then 'Category talk:' when pt_namespace = 14 then 'Category:' when pt_namespace = 13 then 'Help talk:' when pt_namespace = 12 then 'Help:' when pt_namespace = 11 then 'Template talk:' when pt_namespace = 10 then 'Template:' when pt_namespace = 9 then 'MediaWiki talk:' when pt_namespace = 8 then 'MediaWiki:' when pt_namespace = 7 then 'File talk:' when pt_namespace = 6 then 'File:' when pt_namespace = 5 then 'Wikipedia talk:' when pt_namespace = 4 then 'Wikipedia:' when pt_namespace = 3 then 'User talk:' when pt_namespace = 2 then ':User:' when pt_namespace = 1 then 'Talk:' when pt_namespace = 0 then '' end, replace(pt_title, '_', ' '), ']]') as 'Page title' -- Format as wikilink, replace _ with space from protected_titles join `comment` on pt_reason_id = comment_id -- join with comment table, escaped with ` since it is a reserved word and comment_text regexp '.*[Gg][Rr][Aa][Ww][Pp].*' -- Text of reason in creation protection log includes "grawp" order by pt_namespace asc, pt_title asc; -- arrange by namespace and title in asceding order
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...