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;