Untitled query #2454

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 ('A_Portrait_of_the_Artist_as_a_Young_Man_(Huebsch_1916).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...
