select unit.id, unit.id_project, unit.id_unitState, unit.floor, unit.number,
hys_unitCustomData.recamaras,
hys_unitCustomData.banos,
hys_unitCustomData.estudio,
hys_unitCustomData.dobleAltura,
hys_unitCustomData.niveles,
hys_unitCustomData.m2interiores,
hys_unitCustomData.m2terraza,
hys_unitCustomData.m2patio,
hys_unitCustomData.cajones,
hys_unitCustomData.bodega,
hys_unitCustomData.cServicio,
hys_unitCustomData.tvRoom,
hys_unitCustomData.descripcion,
hys_unitCustomData.price, hys_unitCustomData.currency
from unit
left join hys_unitCustomData on unit.id=hys_unitCustomData.id_unit
Processing: #URLDecode(unitList.number)#...
created with ID=#salesUnit.getIdSalesUnit()# [#res.message#]