Untitled query #68960

SQL

SELECT
    B.page_id,
    B.page_title,
    B.rev_id,
	B.rev_timestamp,
    B.rev_len,
    B.comment_text,
    B.cats
FROM
(
SELECT
	p.page_id,
	p.page_title,
    rev.rev_id,
    rev.rev_timestamp,
    rev.rev_len,
    c.comment_text,
    GROUP_CONCAT(DISTINCT cl.cl_to) AS cats
FROM
	flaggedpage_pending fpp
    INNER JOIN revision rev
    ON rev.rev_page = fpp_page_id
    AND rev.rev_id >= fpp.fpp_rev_id
    INNER JOIN comment c
    ON rev.rev_comment_id = c.comment_id
    INNER JOIN page p
    ON p.page_id = fpp.fpp_page_id
    INNER JOIN categorylinks cl
    ON cl.cl_from = p.page_id
WHERE
	p.page_namespace = 0

GROUP BY
	p.page_id,
	p.page_title,
    rev.rev_id,
    rev.rev_timestamp,
    rev.rev_len,
    c.comment_text

ORDER BY
	p.page_title,
    rev.rev_id

) B

LIMIT 10
SQL

Checking query status...
