Project Tiger Editathon 2018 Multilingual Monitor

This query is marked as a draft This query has been published by Viswaprabha.

Project Tiger Editathon 2018 Multilingual Monitor

SQL

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

USE bnwiki_p; SET @SNum := 0; SELECT 'bn', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'ব্যাঘ্র_প্রকল্প_এডিটাথন_২০১৮-এর_অংশ_হিসেবে_তৈরিকৃত_নিবন্ধ'	OR  cl_to = 'ব্যাঘ্র_প্রকল্প_এডিটাথন_২০১৮-এর_অংশ_হিসেবে_সম্প্রসারিত_নিবন্ধ'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE enwiki_p; SET @SNum := 0; SELECT 'en', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018'	OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE guwiki_p; SET @SNum := 0; SELECT 'gu', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE hiwiki_p; SET @SNum := 0; SELECT 'hi', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;


USE knwiki_p; SET @SNum := 0; SELECT 'kn', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'ಪ್ರಾಜೆಕ್ಟ್_ಟೈಗರ್_೨೦೧೮ ಸಮಯದಲ್ಲಿ_ರಚಿಸಿದ_ಲೇಖನಗಳು' OR  cl_to = 'ಪ್ರಾಜೆಕ್ಟ್_ಟೈಗರ್_೨೦೧೮ನ_ಸ್ಪರ್ಧೆಯಲ್ಲಿ_ವಿಸ್ತರಿಸಲಾದ_ಲೇಖನಗಳು'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE mlwiki_p; SET @SNum := 0; SELECT 'ml', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_സൃഷ്ടിക്കപ്പെട്ട_ലേഖനങ്ങൾ' OR cl_to = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_വികസിപ്പിക്കപ്പെട്ട_ലേഖനങ്ങൾ'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE mrwiki_p; SET @SNum := 0; SELECT 'mr', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE orwiki_p; SET @SNum := 0; SELECT 'or', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'ଟାଇଗର_ପ୍ରକଳ୍ପ_ଗଣସମ୍ପଦନା_୨୦୧୮_ଅନ୍ତର୍ଗତ_ଗଢା_ଯାଇଥିବା_ପ୍ରସଙ୍ଗ' OR  cl_to = 'ଟାଇଗର_ପ୍ରକଳ୍ପ_ଗଣସମ୍ପାଦନା_୨୦୧୮_ଅନ୍ତର୍ଗତ_ଉନ୍ନତ_କରା_ଯାଇଥିବା_ପ୍ରସଙ୍'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE pawiki_p; SET @SNum := 0; SELECT 'pa', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'ਉਹ_ਲੇਖ_ਜੋ_ਪ੍ਰੋਜੈਕਟ_ਟਾਈਗਰ_ਲੇਖ_ਲਿਖਣ_ਮੁਕਾਬਲੇ_ਅਧੀਨ_ਬਣਾਏ_ਗਏ' OR  cl_to = 'ਉਹ_ਲੇਖ_ਜੋ_ਪ੍ਰੋਜੈਕਟ_ਟਾਈਗਰ_ਲੇਖ_ਲਿਖਣ_ਮੁਕਾਬਲੇ_ਅਧੀਨ_ਵਧਾਏ_ਗਏ'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE sawiki_p; SET @SNum := 0; SELECT 'sa', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE tawiki_p; SET @SNum := 0; SELECT 'ta', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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_மூலம்_உருவாக்கிய_கட்டுரைகள்' OR  cl_to = 'வேங்கைத்_திட்டம்_கட்டுரைப்_போட்டி_2018_மூலம்_விரிவாக்கிய_கட்டுரைகள்'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE tewiki_p; SET @SNum := 0; SELECT 'te', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'வఇంకా_విలువకట్టని_పంజాబ్_ఎడిటథాన్_వ్యాసాలు' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;

USE urwiki_p; SET @SNum := 0; SELECT 'ur', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Parent,New,Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,r.rev_parent_id as Parent,p.page_latest as New,  r.rev_timestamp as Date_Time, r.rev_user_text as Editor, r.rev_len as New_Bytes, p.page_title as Article   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 = 'Articles_created_as_part_of_Project_Tiger_editathon_2018' OR  cl_to = 'Articles_expanded_as_part_of_Project_Tiger_editathon_2018'
))) AND p.page_namespace = 0   GROUP BY page_namespace, page_title, rev_id ) AS t LEFT JOIN (SELECT  q.eu_entity_id as WikidataID, q.eu_page_id as QPageID  FROM wbc_entity_usage q   WHERE q.eu_aspect = 'S' AND q.eu_entity_id LIKE 'Q%') AS q1 ON QPageID = PageID ORDER BY Date_Time ASC ;




/**********************************************************************************/
SELECT 	'8677' AS QuarryNumber, 'Last Updated (UTC):' + now() AS TIME ;
use bnwiki_p; SET @snum := 0; SELECT 'bn' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;


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

use sdwiki_p; SET @snum := 0; SELECT 'sd' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp = 20180229000000 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 ;


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

use guwiki_p; SET @snum := 0; SELECT 'gu' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use hiwiki_p; SET @snum := 0; SELECT 'hi' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;

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

use knwiki_p; SET @snum := 0; SELECT 'kn' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use mrwiki_p; SET @snum := 0; SELECT 'mr' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use orwiki_p; SET @snum := 0; SELECT 'or' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use pawiki_p; SET @snum := 0; SELECT 'pa' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use sawiki_p; SET @snum := 0; SELECT 'sa' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use tawiki_p; SET @snum := 0; SELECT 'ta' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use tewiki_p; SET @snum := 0; SELECT 'te' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;
/**********************************************************************************/

use urwiki_p; SET @snum := 0; SELECT 'ur' 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, Article 
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 Article, p.page_namespace AS Namespace 
		FROM
			revision r 
			LEFT JOIN
				page p 
				ON p.page_id = r.rev_page 
      			WHERE	r.rev_timestamp > 20180301000000 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 ;

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...