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.vip,
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 = 1
WHERE
t1.hotelcode =
AND
t1.vStatus = 1