Untitled query #10924

This query is marked as a draft This query has been published by Viswaprabha.
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 ;
/**********************************************************************************/

use guwiki_p; SET @snum := 0; SELECT 'gu' 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 ;
/**********************************************************************************/

use hiwiki_p; SET @snum := 0; SELECT 'hi' 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 ;
/**********************************************************************************/

use knwiki_p; SET @snum := 0; SELECT 'kn' 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 ;
/**********************************************************************************/

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, 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 ;
/**********************************************************************************/

use mrwiki_p; SET @snum := 0; SELECT 'mr' 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 ;
/**********************************************************************************/

use orwiki_p; SET @snum := 0; SELECT 'or' 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 ;
/**********************************************************************************/

use pawiki_p; SET @snum := 0; SELECT 'pa' 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 ;
/**********************************************************************************/

use sawiki_p; SET @snum := 0; SELECT 'sa' 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 ;
/**********************************************************************************/

use tawiki_p; SET @snum := 0; SELECT 'ta' 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 ;
/**********************************************************************************/
use tewiki_p; SET @snum := 0; SELECT 'te' 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 ;
/**********************************************************************************/
use urwiki_p; SET @snum := 0; SELECT 'ur' 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 ;
/**********************************************************************************/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
