ML-Revisions - Quarry

SQL

USE mlwiki_p;
# For Language Malayalam
SELECT
t.page_id AS PID, t.cnt AS Edits, t.page_title AS Title

FROM (
SELECT COUNT(*) AS cnt, p.page_id, p.page_title, p.page_latest, p.page_namespace  FROM  page p WHERE 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 = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_വികസിപ്പിക്കപ്പെട്ട_ലേഖനങ്ങൾ')))
AND p.page_namespace = 0
  
GROUP BY page_namespace, page_title ) AS t
LEFT JOIN revision on revision.rev_page = t.page_id;
SQL

Checking query status...
