Untitled query #83570

SQL

SELECT 
    page_title, 
    CONCAT(LEFT(rev_timestamp, 4), '-', SUBSTRING(rev_timestamp, 5, 2), '-', SUBSTRING(rev_timestamp, 7, 2)) AS creation_date,
    CONCAT(LEFT(MAX(revision.rev_timestamp), 4), '-', SUBSTRING(MAX(revision.rev_timestamp), 5, 2), '-', SUBSTRING(MAX(revision.rev_timestamp), 7, 2)) AS last_edit_date,
    COUNT(revision.rev_id) AS total_edits
FROM 
    categorylinks
JOIN 
    page ON page_id = cl_from
JOIN 
    revision ON page_id = rev_page
WHERE 
    cl_to = 'Inactive_WikiProjects'
AND 
    page_namespace = 4
AND 
    rev_parent_id = 0
GROUP BY 
    page_id;
SQL

Checking query status...
