mlWiki:New articles since 20180101

SQL

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

use mlwiki_p; SET @snum := 0; SELECT 'ml' AS lang, 	@snum := @snum + 1 AS SNum,
	PageID, FirstID,LastID, Created, r2.rev_timestamp AS LastTime,  r2.rev_len AS Bytes, Creator,
    r2.rev_user_text AS LastEditor, page_title
FROM
	(
		SELECT 	r.rev_id AS FirstID, r.rev_page AS RevPageID, r.rev_parent_id AS ParentID,
      			r.rev_timestamp AS Created, r.rev_user_text AS Creator,
      			p.page_latest AS LastID, p.page_id AS PageID, p.page_title AS page_title, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180101000000 AND r.rev_parent_id = 0 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...
