Test Multidatabse

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'

) FROM SELECT ML UNION TA;
SQL

Checking query status...
