LTA:ELLSが作成した、現在未使用のカテゴリ

Fork of LTA:ELLSが作成した、現在未使用のカテゴリ by Tomigaoka

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

SQL

SELECT p.page_namespace, p.page_title, block.ipb_user, block_comment.comment_text
FROM page p
INNER JOIN (
  SELECT rev_page, MIN(rev_id) AS first_rev_id
  FROM revision
  GROUP BY rev_page) rev_group
ON p.page_id = rev_group.rev_page
INNER JOIN revision first_rev
ON rev_group.rev_page = first_rev.rev_page
AND rev_group.first_rev_id = first_rev.rev_id
INNER JOIN actor first_actor
ON first_rev.rev_actor = first_actor.actor_id
INNER JOIN ipblocks block
ON first_actor.actor_user = block.ipb_user
INNER JOIN comment block_comment
ON block.ipb_reason_id = block_comment.comment_id
WHERE block_comment.comment_text LIKE '%HEATHROW%'

SQL

Checking query status...