Untitled query #11344

SQL

USE mlwiki_p; SET @SNum := 0; SELECT 'ml', @SNum:=@SNum + 1 AS SNum, PageID,  WikidataID, Article 
FROM ( 
SELECT p.page_id as PageID, p.page_title as Article   
  FROM page p 
  WHERE p.page_id IN ( 
		SELECT page_id FROM page p2 WHERE p2.page_namespace = 0 AND p2.page_title IN ( SELECT page_title FROM page WHERE page_id IN (
		SELECT cl_from FROM categorylinks WHERE cl_to LIKE '%-ൽ_ജനിച്ചവർ'
))) AND p.page_namespace = 0   
  GROUP BY page_namespace, page_title  ) 
AS t 
  LEFT JOIN 
  (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  
   FROM wbc_entity_usage q   
   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') 
AS q1 ON QPageID = PageID 
GROUP BY PageID 
ORDER BY Article ASC ;
SQL

Checking query status...
