Untitled query #2470

SQL

SELECT
    r.rev_user_text,
    p1.page_title,
    COUNT(p2.page_id) AS 'Edit Count'
FROM
    enwikisource_p.page p1
        INNER JOIN
    enwikisource_p.pagelinks pl ON p1.page_id = pl.pl_from
        INNER JOIN
    enwikisource_p.page p2 ON p2.page_title = pl_title
        INNER JOIN
    enwikisource_p.revision r ON p2.page_id = r.rev_page
WHERE
    p1.page_title IN ('Great_Neapolitan_Earthquake_of_1857.djvu')
        AND p1.page_namespace = 106 /* N.B. INDEX namespace! */
        AND (r.rev_timestamp > '20150201000000'
        AND r.rev_timestamp < DATE_FORMAT(NOW(), 'YYmmddHHiiss'))
GROUP BY page_title,rev_user_text;
SQL

Checking query status...
