select unit.id, unit.id_project, unit.id_unitState, unit.floor, unit.number,
laspalmas_unitCustomData.departamento,
laspalmas_unitCustomData.vista,
laspalmas_unitCustomData.recamaras,
laspalmas_unitCustomData.m2interiores,
laspalmas_unitCustomData.m2terraza,
laspalmas_unitCustomData.m2total,
laspalmas_unitCustomData.priceM2, laspalmas_unitCustomData.price, laspalmas_unitCustomData.currency
from unit
left join laspalmas_unitCustomData on unit.id=laspalmas_unitCustomData.id_unit
Processing: #URLDecode(unitList.number)#...
created with ID=#salesUnit.getIdSalesUnit()# [#res.message#]