Wikipedia:People by year/Sortkeys not AZ/SQL
Appearance
SELECT DISTINCT CONCAT(';', p_sortkey, ' : [[', REPLACE(p_title, '_', ' '), ']] ', IF(y2='0000', CONCAT('(born [[', y1,']])'), CONCAT('([[', y1, ']]-[[',y2,']])')), IF(p_categories='', '', CONCAT(', ', p_categories)) ) INTO OUTFILE 'wp_sortkey_not_AZ.txt' FROM temp_peopleyr WHERE p_sortkey REGEXP '^[^A-Z]'