Protected questions by tag

0

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 top 50 posts.id as [Post Link]
from posthistory as pq
inner join posts on pq.postid = posts.id
inner join posttags on posttags.postid = posts.id
inner join tags on posttags.tagid = tags.id
left outer join posthistory as uq
  on uq.postid = posts.id
  and uq.posthistorytypeid = 20
  and uq.creationdate > pq.creationdate
where pq.posthistorytypeid = 19
  and uq.posthistorytypeid is null
  and tags.tagname = ##tagName:string##

Enter Parameters

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