3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

SELECT [id] [Post Link] ,id, creationDate, score, viewcount
FROM   posts q 
WHERE  posttypeid = 1 
       AND creationdate < ( Getdate() - 30 ) 
       AND COALESCE(answercount,0) = 0 
       AND Score > 0
       AND closeddate IS NOT NULL 
       AND id NOT IN (SELECT postid 
                      FROM   posthistory 
                      WHERE  (posthistorytypeid = 10 
                      AND COMMENT in ( 1 )) 
                      or posthistorytypeid in (17,18,35,37,38))
ORDER BY SCORE DESC

fork query

edited mar 26 12 sam.saffron

created feb 15 12 conradfrix