PT2018-Test3 - Quarry

SQL

USE mlwiki_p;
SELECT
'ml',  t.PID AS PID, t.RID AS RID, t.RTime AS RevTime, t.Editor AS RevEditor,t.RBytes as RBytes, 
/*r1.rev_id AS LastRID, r1.rev_timestamp AS LastTime, r1.rev_user_text AS LastEditor, r1.rev_len AS LastSize, */ 
t.cnt AS Edits, t.Title AS Title 
FROM ( 
  SELECT COUNT(*) AS cnt, r.rev_timestamp as RTime, r.rev_id as RID, r.rev_user_text AS Editor, r.rev_len as RBytes,
  p.page_id as PID, p.page_title AS Title, p.page_latest AS LastRev , p.page_namespace  
	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 = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_വികസിപ്പിക്കപ്പെട്ട_ലേഖനങ്ങൾ'
												))) AND p.page_namespace = 0
  GROUP BY page_namespace, page_title ) AS t

/*LEFT JOIN revision r2 		ON r2.rev_page = PID 
LEFT JOIN revision r1 		ON r1.rev_id = LastRev */


ORDER BY Revtime ASC
;

/* ELECT TOP 1 * FROM Table ORDER BY ID DESC 
SELECT T1.Number, T2.Column1, T2.Column3 
FROM FirstTable T1
LEFT JOIN ( SELECT ID, NUMBER, Colunmn2, Column3,
              ROW_NUMBER() OVER (PARTITION BY Number ORDER BY ID ASC) as NumOrder
            FROM SecondTable
) T2 ON T1.Number = T2.Number AND T2.NumOrder = 1*/
SQL

Checking query status...
