Cacher is the code snippet organizer for pro developers

SELECT DISTINCT
  TC.HEFIRSTNAME AS FIRST_NAME,
  IsNull(TC.HELASTNAME, C.HENAME) AS LAST_NAME,
  TB.HEEMAIL AS EMAIL,
  CASE WHEN HC.HEHCVCID IS NOT NULL THEN 'ΝΑΙ' ELSE '' END AS VIP_STATUS,
  CASE WHEN TB.HEPHONETYPE1 = 1 THEN TB.HEPHONE1 WHEN TB.HEPHONETYPE2 = 1 THEN TB.HEPHONE2
    WHEN TB.HEPHONETYPE3 = 1 THEN TB.HEPHONE3 WHEN TB.HEPHONETYPE4 = 1 THEN TB.HEPHONE4
    WHEN TB.HEPHONETYPE5 = 1 THEN TB.HEPHONE5 ELSE NULL END AS MOBILE_PHONE
FROM
  HERESERVATIONS AS R
  INNER JOIN HECUSTOMERS AS C ON R.HEPRIMARYGUESTID = C.HEID
  INNER JOIN HETRADERS AS T ON T.HEID = C.HETRDRID
  INNER JOIN HEHOTELCUSTOMERS AS HC ON HC.HETRDRID = T.HEID
  INNER JOIN HETRADERBRANCHES AS TB ON TB.HETRDRID = T.HEID
  INNER JOIN HECONTACTS AS TC ON TC.HEID = T.HECNTCID
  INNER JOIN HECOUNTRIES AS CO ON CO.HEID = TC.HENATIONALITY
  INNER JOIN HEHOTELROOMS AS HR ON HR.HEID = R.HERMID
  INNER JOIN HEROOMTYPES AS RT ON RT.HEID = R.HERMTPID
  INNER JOIN HERATEPLANS AS RP ON RP.HEID = R.HERTPLID
  INNER JOIN HETREESMTSEG AS M ON M.HEID = R.HEMARKETSEGMENTID
WHERE
  TB.HEEMAIL IS NOT NULL