• Telefones atendimento
  • (31) 3774-3933
  • .
  • (31) 9.8855-3933
  • CRECI PJ: 6170
Table './zadmin_sig2laurentiimoveis/sig_imoveis_clicks' is marked as crashed and should be repairedSELECT i.id, i.titulo, i.tipo, i.mapa, i.codigoYoutube, i.situacao, i.posicao, ie.bairro, ie.cidade, i.condominio, i.iptu, i.idadeDoImovel, i.areaTotal, i.areaConstruida, i.areaLote, i.frente, i.salas, i.quartos, i.banheiros, i.suites, i.varandas, i.vagas, i.unidadesPorAndar, i.pavimentos, i.texto, i.codigoImovel, IF(SITUACAO='Locacao', valorAluguel, valor) as valores, (SELECT COUNT(*) FROM sig_imoveis_clicks AS c WHERE c.idImovel=i.id) AS qtdClicks FROM sig_imoveis AS i LEFT JOIN sig_imoveis_enderecos AS ie ON ie.idImovel=i.id WHERE i.status='Ativo' AND i.id='1605'