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
Viswaprabha
.
Toggle Highlighting
SQL
/* This query gets a list of site links in a particular language (here mlwiki) against a long list of Wikidata Items For Malayalam Wikipedia USE mlwiki_p as ML; SELECT * FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' AND `eu_entity_id` in ( List of wikidata QIDs ); List member eg: {'Q1','Q2',....} */ /*USE mlwiki_p as ML; USE tawiki_p as TA;/*Malayalam മലയാളം*/ Use mlwiki_p; SELECT * FROM page where page_title in ( 'അണ്ടി_(വിവക്ഷകൾ)' ) LEFT JOIN `wbc_entity_usage` ON page.`page_id` = wbc_entity_usage.`eu_page_id` /*LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` */ WHERE `eu_aspect` = 'S';
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...