Untitled query #80138

SQL

SELECT
	P.page_title AS "リダイレクト元カテゴリ",
	R.rd_title AS "リダイレクト先カテゴリ",
	A.actor_name AS "リダイレクト元の初版作成者",
    H.rev_timestamp AS "リダイレクト元の初版作成日時",
    C.comment_text AS "リダイレクト元の初版コメント",
	H2.rev_count AS "リダイレクト元の総版数"
FROM page P
INNER JOIN redirect R
	ON P.page_id = R.rd_from 
INNER JOIN revision H_FIRST
	ON P.page_id = H_FIRST.rev_page
INNER JOIN (
  SELECT MIN(rev_id) AS rev_id, rev_page, COUNT(rev_id) AS rev_count
  FROM revision
  GROUP BY rev_page ) AS H2_FIRST
	ON H_FIRST.rev_id = H2_FIRST.rev_id AND H_FIRST.rev_page = H2_FIRST.rev_page
INNER JOIN actor A
	ON H_FIRST.rev_actor = A.actor_id
INNER JOIN comment C
	ON H_FIRST.rev_comment_id = C.comment_id
WHERE P.page_namespace=14
AND R.rd_namespace=14
SQL

Checking query status...
