POTM TAWS DEC19

SQL

SELECT
    act.actor_name as 'Editor',
    ndx.page_title as 'Work',
    sum(edp.page_namespace = 250) as 'Page-space: edits',
    sum(edp.page_namespace = 252) as 'Index-space: edits',
    sum(edp.page_namespace = 0) as 'Main-space: edits',
    COUNT(edp.page_id)-sum(edp.page_namespace in (0,250,252)) AS 'Other edits'
FROM
    tawikisource_p.page ndx
        INNER JOIN
    tawikisource_p.pagelinks lnk ON ndx.page_id = lnk.pl_from
        INNER JOIN
    tawikisource_p.page edp ON edp.page_title = lnk.pl_title
        INNER JOIN
    tawikisource_p.revision edt ON edp.page_id = edt.rev_page
    	INNER JOIN
    tawikisource_p.actor act ON act.actor_id = edt.rev_actor
WHERE
    ndx.page_title IN ('சடுகுடு_ஆட்டம்.pdf')
        AND ndx.page_namespace = 252 /* N.B. INDEX namespace! */
        AND (edt.rev_timestamp >= 20191101000000 /* Revision/edit */)
        AND (edt.rev_timestamp < 20200101000000 /* Revision/edit */)
GROUP BY ndx.page_title,act.actor_name;
SQL

Checking query status...
