SELECT *
FROM BPS_Patients
WHERE (StatusText = 'Active' OR StatusText = 'Inactive')
AND Ethnicity IN ('Afghan','Albanian','Algerian','Armenian','Austrian','Azeri','Belarusan','Bosnian','Bruneian','Bulgarian','Burmese','Cambodian','Chinese','Cook Islander','Croatian','Cypriot','Czech','Egyptian','Estonian','Fijian','Filipino','Georgian','Gibraltarian','Greek','Hungarian','i-Kiribati','Indonesian','Italian','Japanese','Kazakh','Korean','Kosovar','Lao','Latvian','Libyan','Lithuanian','Macedonian','Malaysian','Maltese','Moldovan','Mon','Mongolian','Montenegrin','Moroccan','Nauruan','New Caledonian','New Zealander','Niuean','Ni-Vanuatu','Papua New Guinean','Pitcairn Islander','Polish','Portuguese','Roma/Gypsy','Romanian','Russian','Samoan','Serbian','Singaporean','Slovak','Slovene','Solomon Islander','South Sudanese','Spanish','Sundanese','Taiwanese','Tajik','Thai','Timorese','Tokelauan','Tongan','Tunisian','Turkish','Turkmen','Tuvaluan','Ukrainian','Vietnamese')
ORDER BY surname, firstname
-- ASHM Query -- Ethnicity is in known countries in Central, North-East and South-East Asia, the Pacific Islands, North and Sub-Saharan Africa, and Southern and Eastern Europe --