Untitled query #3551

SQL

SELECT
    edt.rev_user_text as 'Editor',
    ndx.page_title as 'Work',
    sum(edp.page_namespace = 104) as 'Page-space: edits',
    sum(edp.page_namespace = 106) as 'Index-space: edits',
    sum(edp.page_namespace = 0) as 'Main-space: edits',
    COUNT(edp.page_id)-sum(edp.page_namespace in (0,104,106)) AS 'Other edits'
FROM
    enwikisource_p.page ndx
        INNER JOIN
    enwikisource_p.pagelinks lnk ON ndx.page_id = lnk.pl_from
        INNER JOIN
    enwikisource_p.page edp ON edp.page_title = lnk.pl_title
        INNER JOIN
    enwikisource_p.revision edt ON edp.page_id = edt.rev_page
WHERE
    ndx.page_title IN ('Queen_Mab_(Shelley).djvu')
        AND ndx.page_namespace = 106 /* N.B. INDEX namespace! */
        AND (edt.rev_timestamp > '20150401000000' /* Revision/edit */
        AND edt.rev_timestamp < DATE_FORMAT(NOW(), 'YYmmddHHiiss'))
GROUP BY ndx.page_title,edt.rev_user_text;
SQL

Checking query status...
