UC TLA dabs with no lc page

SQL

SELECT Pu.page_title, rd_title,CONCAT(SUBSTR(Pu.page_title,1,1),"*",LOWER(BINARY SUBSTR(Pu.page_title,2)),"%") FROM page Pu
JOIN redirect ON rd_from = Pu.page_id AND rd_namespace = 0 AND rd_title REGEXP BINARY "_\\(disambiguation\\)$"
AND rd_title NOT LIKE CONCAT(SUBSTR(Pu.page_title,1,1),LOWER(BINARY SUBSTR(Pu.page_title,2)),"%")
WHERE page_is_redirect = 1
AND 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(Pu.page_title,2))))
ORDER BY Pu.page_title*/LIMIT 10;
SQL

Checking query status...
