AND tblRegion.r_name='Otago' OR tblRegion.r_name='Auckland' OR tblRegion.r_name='Northland ...