SELECT HANDLE FROM (SELECT B.HANDLE, B.IMOVEL, DATAINICIATIVAVENDA, MAX(B.DATAINICIATIVAVENDA) OVER(PARTITION BY B.IMOVEL) MAX_DATA FROM K9_IM_IMOVELINICIATIVASVENDA B LEFT JOIN IM_PROPRIEDADEIMOBILIARIAS IM ON B.IMOVEL = IM.HANDLE LEFT JOIN K9_IM_CANAISVENDA C ON B.CANALVENDA = C.HANDLE WHERE B.STATUSVENDA NOT IN(1001, 1006, 1007, 1008) AND B.TIPOINICIATIVAVENDA = 1002 AND C.TIPO = 1002 AND B.IMOVEL IN(43537,43526,43524,43516,43514,43510,43470,43425,43422,34503)) WHERE DATAINICIATIVAVENDA = MAX_DATA)