Untitled query #2477

SQL

SELECT
    ndx.page_title as 'Index',
    edp.page_title as 'Page',
    cat.cl_to as 'State',
    edt.rev_user_text as 'Last Editor'
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.categorylinks cat ON edp.page_id = cat.cl_from
        INNER JOIN
    enwikisource_p.revision edt ON edp.page_id = edt.rev_page
WHERE
    ndx.page_title IN ('Popular_Science_Monthly_Volume_29.djvu')
        AND ndx.page_namespace = 106 /* N.B. INDEX: namespace! */
        AND edp.page_namespace = 104 /* N.B. PAGE:  namespace! */
GROUP BY
    edt.rev_timestamp
ORDER BY
    ndx.page_title ASC,
    edp.page_title ASC;
SQL

Checking query status...
