1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

;with voters as
(
Select users.UserId
    , users.UserDisplayName
    , CreationDate
From PostHistory
cross apply openjson(Text, '$.Voters') 
       with ( UserId int '$.Id'
            , UserDisplayName nvarchar(150) '$.DisplayName') users
where posthistorytypeid in (10,11,12,13,14,15,19,20,35) 
and Text is not null 
and len(text) > 0 
and users.userid = ##userid?1233251##
)

select UserDisplayName
     , min(creationdate) [first seen]
     , max(creationdate) [last seen]     
from voters
group by UserDisplayName
order by min(creationdate) desc

fork query

edited aug 16 20

created aug 16 20 rene