Untitled query #2477

SQL

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

Checking query status...
