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

SQL

x
 
USE mlwiki_p;
SELECT
'ml', t.TotBytes, q.eu_entity_id  , t.page_id AS PID, r2.rev_id AS CreateRID, r2.rev_timestamp AS CreateTime, r2.rev_user_text AS Creator, 
r1.rev_id AS LastRID, r1.rev_timestamp AS LastTime, r1.rev_user_text AS LastEditor, r1.rev_len AS LastSize, 
t.cnt AS Edits, t.page_title AS Title 
FROM ( 
  SELECT COUNT(*) AS cnt,p.page_lang, SUM(r.rev_len) as TotBytes, r.rev_timestamp, p.page_id, p.page_title, p.page_latest, p.page_namespace  
  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'
OR cl_to = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_സൃഷ്ടിക്കപ്പെട്ട_ലേഖനങ്ങൾ'
OR cl_to = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_വികസിപ്പിക്കപ്പെട്ട_ലേഖനങ്ങൾ'
))) AND p.page_namespace = 0
  GROUP BY page_namespace, page_title ) AS t
LEFT JOIN revision r2 ON r2.rev_page = t.page_id AND r2.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = t.page_latest 
LEFT JOIN wbc_entity_usage q ON  q.eu_page_id = r1.rev_page  WHERE  q.eu_entity LIKE 'Q%'
ORDER BY r2.rev_timestamp ASC
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...