Unanswered questions from users with reputation = 1

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 1000 p.id as [Post Link], p.score, p.viewcount, p.answercount, 
  u.reputation
from posts p, users u 
where p.owneruserid = u.id
  and p.answercount = 0
  and u.reputation = 1
order by p.creationdate desc
--limit 1000

Enter Parameters

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