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 മലയാളം*/ 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 ( 'Q13109885', 'Q13110042', 'Q25588974' ) IN ( USE mlwiki_p as ML UNION tawiki_p as TA;);
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...