Serius error occurred, please contact the system administratorSELECT COUNT(h.hotel_id) AS num  FROM gp_hotel AS h 
			INNER JOIN gp_comuni AS comu ON comu.comuni_id = h.comuni_id 
			LEFT JOIN gp_hotel_descrizioni hl ON (hl.hotel_id = h.hotel_id AND hl.languages_id=2)
			INNER JOIN gp_province AS pro ON pro.province_id = comu.province_id 
			INNER JOIN gp_categorie AS cat ON cat.categorie_id = h.categorie_id 
			INNER JOIN gp_classificazione_hotel_descrizioni as chdv ON chdv.classificazione_id=h.classificazione_id
			INNER JOIN gp_classificazione_hotel AS class ON class.classificazione_id = h.classificazione_id  INNER JOIN gp_hotel_has_caratteristiche AS hhc ON (hhc.hotel_id = h.hotel_id AND hhc.caratteristiche_id=)  WHERE h.hotel_id IN (SELECT hotel_id FROM gp_view_hotel_active)  AND pro.province_id=2