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
Awltux
.
Toggle Highlighting
SQL
-- 361082 = Gallery_of_sovereign_state_flags and namespace = 0 -- Country and flag_file_names SELECT REGEXP_REPLACE( il.il_to, '^Flag_of_(.*?)(_\\([a-zA-Z]+\\))?\.svg', '\\1' ) as country, il.il_to as flag_file_names FROM page p INNER JOIN imagelinks il on p.page_id = il.il_from and p.page_namespace = il.il_from_namespace WHERE p.page_id=361082 and il.il_to LIKE 'Flag_of_%svg' LIMIT 100;
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...