View source for Wiki143:People by year/Reports/Sortkeytest2/SQL

<pre>
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
</pre>