select hc.UserId [User Link], u.displayname,, p.titl...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select hc.UserId [User Link], u.displayname,, p.title, answers.score, p.Id
from PostHistory hc
inner join posts p on
inner join posts answers on and hc.userid=answers.owneruserid
inner join users u on
where hc.PostHistoryTypeId=10
and hc.Comment like '101%'
and hc.Text like '%BindingReason":{"GoldTagBadge%'
and hc.CreationDate > getdate()-365
and hc.UserId = 177800

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results