A-Class, but not good or featured, articles

There's no single category listing all A-Class articles.  The tc.cl_to matches in this query contain the entire [[Category:A-Class articles]] subtree, without any false positives I can find; the raw data is at <https://petscan.wmflabs.org/?project=wikipedia&categories=A-Class%20articles&ns%5B14%5D=1&depth=10&sortby=ns_title&doit=>.

For [[WP:RAQ#A-level article that are not GA or FA]] circa 10 January 2022.

SQL

SELECT main.page_title
FROM page AS main
WHERE main.page_namespace = 0
  AND main.page_title IN (SELECT talk.page_title
                          FROM page AS talk
                          JOIN categorylinks AS tc ON tc.cl_from = talk.page_id
                          WHERE talk.page_namespace = 1
                          AND (tc.cl_to LIKE 'A-Class\_%articles%'
                               OR tc.cl_to LIKE 'All\_Wikipedia\_A-Class\_%'
                               OR tc.cl_to LIKE 'High-importance\_A-Class\_%'
                               OR tc.cl_to LIKE 'Low-importance\_A-Class\_%'
                               OR tc.cl_to LIKE 'Mid-importance\_A-Class\_%'
                               OR tc.cl_to = 'Successful\_requests\_for\_biography\_A-Class\_review'
                               OR tc.cl_to LIKE 'Top-importance\_A-Class\_%'
                               OR tc.cl_to LIKE 'Unknown-importance\_A-Class\_%'
                               OR tc.cl_to LIKE 'Wikipedia\_A-Class\_%'))
  AND NOT EXISTS (SELECT 1
                  FROM categorylinks AS mc
                  WHERE mc.cl_from = main.page_id
                    AND mc.cl_to IN ('Good_articles', 'Featured_articles'))
ORDER BY main.page_title ASC;

SQL

Checking query status...