UC TLA dabs with no lc page

SQL

SELECT Pu.page_title
FROM page Pu
JOIN categorylinks ON cl_from = Pu.page_id AND cl_type = "page" AND cl_to = "All_disambiguation_pages"
WHERE Pu.page_namespace = 0 AND Pu.page_title REGExP BINARY "^[A-Z][A-Z][A-Z]$"
AND NOT EXISTS (SELECT 1 FROM page Pl WHERE Pl.page_namespace = 0
                AND Pl.page_title = CONCAT(SUBSTR(Pu.page_title,1,1),LOWER(SUBSTR(CAST(Pu.page_title AS CHAR),2))))
ORDER BY Pu.page_title

AخA
 
SELECT Pu.page_titleFROM page PuJOIN categorylinks ON cl_from = Pu.page_id AND cl_type = "page" AND cl_to = "All_disambiguation_pages"WHERE Pu.page_namespace = 0 AND Pu.page_title REGExP BINARY "^[A-Z][A-Z][A-Z]$"AND NOT EXISTS (SELECT 1 FROM page Pl WHERE Pl.page_namespace = 0                AND Pl.page_title = CONCAT(SUBSTR(Pu.page_title,1,1),LOWER(SUBSTR(CAST(Pu.page_title AS CHAR),2))))ORDER BY Pu.page_title

SQL

Checking query status...