Untitled query #68205

SQL

SELECT page_title
FROM page
JOIN (
  SELECT
    rev_page,
    COUNT(DISTINCT rev_actor) AS cnt
  FROM revision
  GROUP BY rev_page
  HAVING cnt = 1
) singleauth
  ON page_id = rev_page
LEFT JOIN pagelinks
  ON pl_title = page_title
  AND pl_namespace = 4
  AND pl_from <> 1171408 /* The report itself */
LEFT JOIN linktarget
  ON lt_title = page_title
  AND lt_namespace = 4
LEFT JOIN templatelinks
  ON tl_target_id = lt_id
WHERE
  page_namespace = 4
  AND page_is_redirect = 0
  AND page_title NOT LIKE "اشتباه‌یاب/موارد_درست/%"
  AND pl_title IS NULL
  AND lt_title IS NULL
SQL

Checking query status...
