Fork of カテゴリ間のリダイレクト by Tomigaoka
This query is marked as a draft This query has been published by FlatLanguage.

SQL

AخA
 
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
    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
INNER JOIN comment C
    ON H.rev_comment_id = C.comment_id
WHERE P.page_namespace=14
AND R.rd_namespace=14
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
All SQL code is licensed under CC0 License.

Checking query status...