Questions with no answers and no comments older than 2 days, tagged "python", sorted by cdate

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Questions with no answers and no comments

select TOP 100
  p.Id as [Post Link]
  FROM Posts p
  WHERE 
  p.tags LIKE '%python%' AND
  p.PostTypeId = 1 AND 
  p.score >= 0 AND
  p.closeddate is null AND
  ISNULL(p.AnswerCount,0) = 0 AND
  ISNULL(p.CommentCount,0) = 0 
  order by p.CreationDate desc

Enter Parameters

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