select accomm_province_id from location_province where province = "south africa" AND location_city.country_id = "1"Unknown column 'accomm_province_id' in 'field list'