SELECT

  P.page_title,

  P.page_id

FROM page P

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 = '井戸端の話題')