select topic.id, ( SELECT id reply_id FROM ( SELECT rownum r , replies.* FROM nf_posts replies start with parent_id = topic.id connect by parent_id = PRIOR id ORDER BY UPDATED_DATE DESC ) WHERE r = 1 ) from nf_posts topic where parent_id is null