Fork of Untitled query #8473 by Maxitaxi2804
This query is marked as a draft This query has been published by Viswaprabha.

SQL

x
 
# For Language Malayalam
SELECT
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, 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
GROUP BY t.page_namespace, t.page_title;# Quarry for extracting details about new or expanded articles created during Project Tiger Ediatathon 2018
#Creator User:ViswaPrabha
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...