Immobili

SELECT immobili.*, categoria.ref AS categoriaRef, categoria.nome AS categoriaNome, fornitore.ragsoc AS fornitoreNome, cliente.nome AS clienteNome, cliente.cell AS clienteCell, cliente.mail AS clienteMail, be_status.nome AS statusLabel, be_status.classe AS statusClass, be_status.deliver AS delivered, be_status.progress AS progress, localita.nome AS localita_label, immobili_tipo.tipo AS tipologia_label FROM immobili LEFT JOIN categoria ON (immobili.id_cat = categoria.id) LEFT JOIN fornitore ON (immobili.id_fornitore = fornitore.id) LEFT JOIN cliente ON (immobili.id_cliente = cliente.id) LEFT JOIN be_status ON (immobili.id_status = be_status.id) LEFT JOIN bk_localita AS localita ON (immobili.id_localita = localita.id) LEFT JOIN immobili_tipo ON (immobili.tipologia = immobili_tipo.id) WHERE immobili.active = 1 AND immobili.id = 102