移動の履歴 - Quarry

This query is marked as a draft This query has been published by FlatLanguage.

SQL

SELECT
	P.page_title AS "リダイレクト元",
	R.rd_title AS "リダイレクト先",
    H.rev_timestamp 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
WHERE LEFT(rev_timestamp, 4) = '2004';

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...