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 മലയാളം*/
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` as t WHERE t.wbc_entity_usage.`eu_aspect` = 'S';

/*LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` */
SQL

Checking query status...
