Unanswered, high-viewcount questions

1

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 h.PostId as pId, Cast(h.CreationDate as Date) as mergeDate
into #mergedQuestions
from PostHistory h
inner Join Posts p on p.ID = h.PostId
where h.PostHistoryTypeId = 37 and p.PostTypeId = 1
order by h.CreationDate;

select top 50 Score,ViewCount, ID as [Post Link]
  from posts
  where AnswerCount = 0
  and ClosedDate is NULL
  and ID not in (select pId from #mergedQuestions)
  order by cast(score as float)*cast(viewcount AS FLOAT) DESC;

Enter Parameters

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