0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

fork query

edited aug 22 17

created aug 22 17 Jarrod Roberson