Wikipedia:People by year/Reports/Sortkeytest2/SQL

SELECT CONCAT(';', p_title, ' : ', p_categories) FROM `temp_peopleyr` WHERE p_sortkey NOT LIKE '%,%' AND p_sortkey LIKE '% %' AND p_sortkey = REPLACE(p_title, '_', ' ') AND p_title NOT LIKE '%of%' AND p_categories NOT LIKE '%Chinese%' AND p_categories NOT LIKE '%Japanese%' AND p_categories NOT LIKE '%Taiwanese%' AND p_categories NOT LIKE '%Korea%' AND p_categories NOT LIKE '%CPC%' AND p_categories NOT LIKE '%ROC%' AND p_categories NOT LIKE '%Iceland%' ORDER BY p_sortkey DESC LIMIT 10000