declare @tag varchar(255) = ##Tag:string##; select posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

declare @tag varchar(255) = ##Tag:string##;

select 
  posts.id as [Post Link],
  ClosedDate,
  Tags,
  AcceptedAnswerId
from posts
inner join posttags on posttags.postid = posts.id
inner join tags on posttags.tagid = tags.id
LEFT JOIN postlinks on postlinks.PostId=Posts.Id
where  tags.tagname = @tag
  and ClosedDate IS NOT NULL -- Has to be closed
  and DATEDIFF(DAY, ClosedDate, GetDate()) > 16
  and Score <= 0
  and postlinks.Id IS NULL -- no duplicates
ORDER BY AnswerCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results