-- essa query  busca a carteira do imovel e o id da cidade do imovel
SELECT   CARTEIRA.id as id_wallet, LOCALIZACAO_CSTM.jjwg_address_cache_id_c AS id_city
FROM aos_products IMOVEL
JOIN aos_products_cstm IMOVEL_CSTM ON IMOVEL.id=IMOVEL_CSTM.id_c
JOIN aos_products_accounts_1_c IMOVEL_CARTEIRA ON IMOVEL.id = IMOVEL_CARTEIRA.aos_products_accounts_1aos_products_ida
JOIN accounts CARTEIRA ON  IMOVEL_CARTEIRA.aos_products_accounts_1accounts_idb = CARTEIRA.id
JOIN aos_products_fp_event_locations_1_c IMOVEL_LOCALIZACAO ON IMOVEL.id = IMOVEL_LOCALIZACAO.aos_products_fp_event_locations_1aos_products_ida
JOIN fp_event_locations LOCALIZACAO ON IMOVEL_LOCALIZACAO.aos_products_fp_event_locations_1fp_event_locations_idb = LOCALIZACAO.id
JOIN fp_event_locations_cstm LOCALIZACAO_CSTM ON LOCALIZACAO.id = LOCALIZACAO_CSTM.id_c
WHERE IMOVEL.deleted = 0
AND CARTEIRA.deleted = 0
AND IMOVEL_CARTEIRA.deleted = 0
AND IMOVEL_LOCALIZACAO.deleted = 0
AND LOCALIZACAO.deleted=0
AND IMOVEL.id = ''; -- id do imovel