Q&A for power users of Apple hardware and software
;with data as (
, row_number() over (partition by id order by postid) [row]
cross apply string_split(comment, ' ') rd
where posthistorytypeid = 24
and charindex('|', comment) = 0
where row = 1 and value <> 'Proposed'