Wikipedia:People by year/Sortkeys not AZ/SQL

From Wikipedia, the free encyclopedia
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]'