Untitled query #79615

SQL

SELECT
	CONCAT('Category:', P.page_title) AS "リダイレクト元のページ名",
	CONCAT ('Category:', R.rd_title) AS "リダイレクト先のページ名",
	--COUNT(H.rev_id) AS "リダイレクト元の履歴数",
	--MIN(H.rev_id) AS "リダイレクト元の初版RIVID",
	--A.actor_name,
	1
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 actor A
--ON H.rev_actor = A.actor_id


WHERE P.page_namespace=14
AND R.rd_namespace=14
--GROUP BY P.page_title, R.rd_title
LIMIT 10
SQL

Checking query status...
