SELECT COUNT(id) as nr FROM JT_HotelMaster WHERE eStatus='Active' AND hotel_approve=1 AND tour_type = 0 AND network_on_off=1  AND (iProvinceID=Bali) ;Unknown column 'Bali' in 'where clause'