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
Dizionarios
.
Toggle Highlighting
SQL
USE enwiktionary_p; -- show tables; -- describe category; -- select cat_id from category where cat_title = 'Sicilian_terms_with_IPA_pronunciation'; -- describe categorylinks; -- WITH linked(pageid) AS -- (select cl_from from categorylinks where cl_to LIKE 'Sicilian_terms_with_IPA_pronunciation') -- SELECT * from page where page_id in (select cl_from from categorylinks where cl_to LIKE 'Sicilian_terms_with_IPA_pronunciation') LIMIT 10; describe page; -- select * from categorylinks where category LIKE 'Sicilian_terms_with_IPA_pronunciation' LIMIT 10; select cl_from, cl_to from categorylinks where cl_to LIKE 'Sicilian_terms_with_IPA_pronunciation' -- select cl_to from link_ids; -- select page_title from page where
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...