PT2018 - Quarry

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

PT2018

SQL

SELECT 'Quary# 8678', NOW() UTC ; 
USE bnwiki_p; SET @SNum := 0; SELECT 'bn', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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 guwiki_p; SET @SNum := 0; SELECT 'gu', @SNum:=@SNum + 1 AS SNum, PageID, RevID, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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, Date_Time, Editor, New_Bytes, WikidataID, Article FROM ( 
SELECT p.page_id as PageID,r.rev_id as RevID,  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 ;

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