how to view active history for the specific day for specific tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/329611/how-to-view-active-history-for-the-specific-day-for-specific-tag

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct p.id as [Post Link]
     , case when p.posttypeid = 1 then 'Q' else 'A' end as qa
     , p.creationdate
     , p.score
     , p.owneruserid as [User Link]
from posts  p
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id)
inner join tags t on t.id = pt.tagid
inner join posthistory ph on ph.postid = p.id
where t.tagname = ##tag:string##
and ph.creationdate between ##date:string## and dateadd(d, 1, cast(##date:string## as date))

Enter Parameters

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