nlwiktionary Metapage titles starting with lower case

SQL

SELECT 
	pl.page_namespace AS ns, 
    pl.page_title AS lct, 
    pl.rd_title AS lcrd, 
    pu.page_title AS uct, 
    pu.rd_title AS ucrd
FROM
	(SELECT page_namespace, page_title, rd_title
     FROM page LEFT JOIN redirect ON page_id=rd_from
     WHERE page_namespace IN (4, 6, 10, 12, 14, 828) AND page_title REGEXP '^\\p{Ll}'
    ) pl, 
	(SELECT page_namespace, page_title, rd_title
     FROM page LEFT JOIN redirect ON page_id=rd_from
     WHERE page_namespace IN (4, 6, 10, 12, 14, 828) AND page_title REGEXP '^\\p{Lu}'
    ) pu
WHERE
    pl.page_namespace=pu.page_namespace AND
    pl.page_title=pu.page_title		# case-insensitive compare
HAVING (lcrd IS NULL AND ucrd IS NULL) OR (lcrd != uct AND lct != ucrd)
ORDER BY ns, lct

SQL

Checking query status...