Showing Unpopular Questions from Reasonably high-rep users.

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

declare @somedaysago datetime
declare @now datetime
declare @some int
declare @repthresh int
set @repthresh = ##ReputationThreshold:int?300##
set @some = ##NumberOfDays:int?30##

set @some = @some*-1
set @now = getdate()
set @somedaysago = dateadd(day,@some,@now)



Select p.Id as [Post Link], p.Score, u.Id as [User Link],p.ViewCount as Views,
  u.Reputation, p.ClosedDate
  from Posts as p
  
  inner join Users as u
    on p.OwnerUserId = u.Id
  where u.Reputation > @repthresh
  and p.PostTypeId = 1
  and p.AcceptedAnswerId is Null
  and p.CreationDate > @somedaysago
  and p.ClosedDate is Null
  order by p.Score desc

Enter Parameters

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