移動の履歴 - Quarry

SQL

SELECT
	P.page_title AS "リダイレクト元",
	R.rd_title AS "リダイレクト先",
    H.rev_timestamp AS "リダイレクト元の初版作成日時",
    C.comment_text AS "リダイレクト元の初版コメント"
FROM page P
INNER JOIN redirect R
	ON P.page_id = R.rd_from 
INNER JOIN revision H
	ON P.page_id = H.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
	ON H.rev_id = H2.rev_id AND H.rev_page = H2.rev_page
INNER JOIN comment C
	ON H.rev_comment_id = C.comment_id
WHERE LEFT(H.rev_timestamp, 4) = '2006'
AND C.comment_text LIKE '%移動しました%';
SQL

Checking query status...
