SELECT

  P.page_title,

  P.page_id,

  H.rev_timestamp

FROM page P

INNER JOIN revision H

    ON P.page_id = H.rev_page

INNER JOIN (

  SELECT MIN(rev_id) AS rev_id, rev_page

  FROM revision

  GROUP BY rev_page ) AS H2

    ON H.rev_id = H2.rev_id AND H.rev_page = H2.rev_page

WHERE P.page_namespace = 4

AND P.page_title LIKE '%/%'

AND P.page_title NOT LIKE '%コメント依頼%'

AND P.page_is_redirect = 0

AND NOT EXISTS (SELECT

                  1

                FROM templatelinks JOIN linktarget ON tl_target_id = lt_id

                WHERE tl_from_namespace = 4

                AND lt_namespace = 4

                AND lt_title = P.page_title)

AND NOT EXISTS (SELECT

                  1

                FROM pagelinks JOIN linktarget ON pl_target_id = lt_id

                WHERE pl_from_namespace = 4

                AND lt_namespace = 4

                AND lt_title = P.page_title)

AND NOT EXISTS (SELECT

                  1

                FROM categorylinks

                WHERE cl_from = P.page_id

                AND cl_to = '井戸端の話題')