0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select top 200 
    p.id  as [Post Link]
    ,tags ,creationdate
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where creationdate < dateadd( d, -60, getdate())
and year(creationdate) = 2013
and posttypeid = 1
and not exists (
  select 1 from posts 
  where posttypeid=2 and parentid = p.id)
and t.tagname = '##tag##'
and closeddate is null
and communityowneddate is null
and score > 2
order by creationdate desc

fork query

edited aug 3 14 Unihedron

created jan 18 14 rene