1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

select p.id [Post Link]

from posthistory ph

inner join posts p on p.id = ph.postid

cross apply openjson(text, '$.Voters') with (Id integer  '$.Id') v

where ph.posthistorytypeid = 11 -- reopened

and p.owneruserid = ##userid:int?18147##

and v.id = ##closeid:int?88163##

fork query

created jan 13 24 galacticninja