SELECT t1.IDN, t1.hotelCode, t1.hotelName, t1.hotelCategory, t1.hotelWeb, t1.hotelEmail, t1.hotelPhone, t1.continentIDN, t1.regionIDN, t1.countryISONO, t1.locationIDN, t1.airportIATA, t1.hotelAddress, t1.hotelLocationOnMap, t1.latitude, t1.longitude, t1.managerName, t1.recommended,, t1.propertyType, COALESCE(t3.hotelDescription,t2.hotelDescription) hotelDescription FROM prd_hotels AS t1 LEFT JOIN prd_hotels_description AS t2 ON (t1.hotelCode = t2.hotelCode) AND t2.langIDN = 1 LEFT JOIN prd_hotels_description AS t3 ON (t1.hotelCode = t3.hotelCode) AND t3.langIDN = 2 WHERE t1.hotelcode = AND t1.vStatus = 1