Untitled query #10924

SQL

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


/**********************************************************************************/
use bnwiki_p; SET @snum := 0; SELECT 'bn' 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, Redir, 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 Redir
      		FROM 	revision r 	LEFT JOIN 	page p 	ON p.page_id = r.rev_page WHERE	r.rev_timestamp > 20180300000000  AND r.rev_timestamp < 20180331235959  AND p.page_namespace = 0 
		) 	AS t  	LEFT JOIN revision r2  ON r2.rev_page = t.pageid WHERE r2.rev_id = t.LastID ORDER BY Date_Time ;
/**********************************************************************************/
SQL

Checking query status...
