リンクされていないプロジェクトページ

SQL

SELECT
  P.page_namespace,
  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 = '井戸端の話題')
ORDER BY H.rev_timestamp DESC;
SQL

Checking query status...
