Missing primary articles (cswiki)

SQL

SELECT P1.page_title AS first_title, P2.page_title AS second_title
FROM page AS P1, page AS P2
WHERE P1.page_namespace = 0
AND (
  P1.page_title LIKE 'A%\_(%)' OR P1.page_title LIKE 'B%\_(%)'
  OR P1.page_title LIKE 'C%\_(%)' OR P1.page_title LIKE 'D%\_(%)'
  OR P1.page_title LIKE 'E%\_(%)' OR P1.page_title LIKE 'F%\_(%)'
  OR P1.page_title LIKE 'G%\_(%)' OR P1.page_title LIKE 'H%\_(%)'
  OR P1.page_title LIKE 'I%\_(%)' OR P1.page_title LIKE 'J%\_(%)'
  OR P1.page_title LIKE 'K%\_(%)' OR P1.page_title LIKE 'L%\_(%)'
  OR P1.page_title LIKE 'M%\_(%)' OR P1.page_title LIKE 'N%\_(%)'
  OR P1.page_title LIKE 'O%\_(%)' OR P1.page_title LIKE 'P%\_(%)'
  OR P1.page_title LIKE 'Q%\_(%)' OR P1.page_title LIKE 'R%\_(%)'
  OR P1.page_title LIKE 'S%\_(%)' OR P1.page_title LIKE 'T%\_(%)'
)
AND P1.page_title NOT LIKE '%)%(%' AND P1.page_title NOT LIKE '%(%(%'
AND P2.page_namespace = 0 AND P2.page_title LIKE CONCAT(SUBSTRING_INDEX(P1.page_title, '_(', 1), '\_(%)')
AND P1.page_title < P2.page_title AND P1.page_is_redirect = 0 AND P2.page_is_redirect = 0
AND SUBSTRING_INDEX(P1.page_title, '_(', 1) = SUBSTRING_INDEX(P2.page_title, '_(', 1)
AND NOT EXISTS (
  SELECT 1 FROM page AS P3 WHERE P3.page_namespace = 0 AND P3.page_title = SUBSTRING_INDEX(P1.page_title, '_(', 1)
)
ORDER BY P1.page_title;
SQL

Checking query status...
