List of questions reopened by a specific user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cardano Meta

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##

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results