Single-character title articles not assigned to WikiProjects

Detects articles WITH SINGLE-CHARACTER TITLES that are not assigned to any Wikiprojects, regardless of whether or not they have talk pages. Hopefully this database treats "character" as meaning "Unicode code point", or there's not much point to this; this; https://mariadb.com/kb/en/pcre/#unicode-character-properties suggests it probably does.

SQL

SELECT
  article.page_title,
  article.page_id,
  talk.page_id AS talk_id
FROM
  page AS article
  LEFT JOIN page_props ON pp_page = article.page_id  AND pp_propname = 'disambiguation'
  LEFT JOIN page AS talk ON talk.page_title = article.page_title AND talk.page_namespace = 1 AND talk.page_is_redirect = 0
WHERE
  article.page_namespace = 0
  AND article.page_title RLIKE "^.$"
  AND pp_page IS NULL
  AND article.page_is_redirect = 0
  AND NOT (article.page_title LIKE "List_of_%")
  AND NOT (article.page_title LIKE "Lists_of_%")
  AND NOT EXISTS (
    SELECT
      1
    FROM
      categorylinks
    WHERE
      article.page_id = cl_from
      AND (
        cl_to IN (
          "Temporary_maintenance_holdings",
          "Candidates_for_speedy_deletion",
          "Requested_RD1_redactions"
        )
        OR cl_to LIKE "%_names"
        OR cl_to LIKE "%_surnames"
        OR cl_to LIKE "Lists_of_%"
      )
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      templatelinks
      JOIN linktarget ON lt_id = tl_target_id
    WHERE
      tl_from = article.page_id
      AND lt_namespace = 10
      AND (
        lt_title IN (
          "Wi",
          "Surname",
          "Given_name",
          "Animal_common_name",
          "Plant_common_name",
          "Nickname",
          "Dmbox"
        )
        OR lt_title LIKE "%index%"
        OR lt_title LIKE "%redirect%"
      )
  )
  AND (
    (talk.page_id IS NULL)
    OR (
      (talk.page_id IS NOT NULL)
      AND NOT EXISTS (
        SELECT
          1
        FROM
          categorylinks
        WHERE
          talk.page_id = cl_from
          AND (
            cl_to LIKE "%WikiProject_%"
            OR cl_to LIKE "%-Class_%_articles"
            OR cl_to LIKE "%-importance_%_articles"
            OR cl_to LIKE "%-priority_%_articles"
            OR cl_to LIKE "Unassessed_%_articles"
          )
      )
      AND NOT EXISTS (
        SELECT
          1
        FROM
          templatelinks
          JOIN linktarget ON lt_id = tl_target_id
        WHERE
          tl_from = talk.page_id
          AND lt_namespace = 10
          AND (lt_title LIKE "%WikiProject_%")
      )
    )
  )
ORDER BY
  article.page_title

SQL

Checking query status...