Untitled query #10924

SQL

/*20180404 User:Viswaprabha*/
SELECT '8677' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 

/**********************************************************************************/

use mlwiki_p; SET @snum := 0; SELECT 'ml' AS lang, 	@snum := @snum + 1 AS SNum,
	PageID, FirstID,ParentID, LastID, r2.rev_timestamp AS LastTime,  r2.rev_len AS Bytes, Date_Time,
    r2.rev_user_text AS LastEditor, Article 
FROM
	(
		SELECT 	r.rev_id AS FirstID, r.rev_page AS RevPageID, r.rev_parent_id AS ParentID,
      			r.rev_timestamp AS Date_Time, r.rev_user_text AS Creator,
      			p.page_latest AS LastID, p.page_id AS PageID, p.page_title AS Article, 
      			p.page_namespace AS Namespace,  p.page_is_redirect  AS Redirect
      FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000  AND p.page_namespace = 0 AND p.page_is_redirect <> 1 
	)
	AS t 
	LEFT JOIN
		revision r2 
		ON r2.rev_page = t.pageid WHERE r2.rev_id = t.LastID ORDER BY Created ;
/**********************************************************************************/
SQL

Checking query status...
