وپ ٹائیگر ترمیمی دوڑ

SQL

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

USE urwiki_p; SET @SNum := 0; SELECT DISTINCT '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 = 'ٹائیگر_ترمیمی_دوڑ،_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 ;




/**********************************************************************************/
SELECT 	'8677' AS QuarryNumber, 'Last Updated (UTC):' + now() AS TIME ;

use urwiki_p; SET @snum := 0; SELECT DISTINCT '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 ;
SQL

Checking query status...
