Old questions to review

0

Please login or register to vote for this query.

(click on this box to dismiss)

Photography

Q&A for professional photographers, photo editors, and serious enthusiasts

select
  score, 
  creationDate,
  id AS [Post Link],
  p.id,
  ViewCount,
  LastEditDate,
  (score * 1.0) / ViewCount
  
from posts p
where posttypeid = 1
  and score <= 5
  and acceptedanswerid is null
  and closeddate is null
  and CreationDate <= dateadd(month, -12, getdate())
  and LastEditDate <= dateadd(month, -6, getdate())
order by ViewCount * Score

Enter Parameters

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