Untitled query #8679

SQL

# 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
SQL

Checking query status...
