Untitled query #11344

SQL

USE mlwiki_p; SET @SNum := 0; SELECT 'ml', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   FROM revision r LEFT JOIN page p ON p.page_id = r.rev_page WHERE r.rev_page 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 = '1946-ൽ_ജനിച്ചവർ'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) 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 ORDER BY Date_Time ASC ;
SQL

Checking query status...
