how can I list questions which has (one or more answers) or marked as duplicate?


Please login or register to vote for this query.

(click on this box to dismiss)

Board and Card Games

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

select distinct top 10 as [Post Link], p.ClosedDate, p.AnswerCount, p.Body
from posts p
inner join posthistory ph 
   on ph.postid =
inner join comments cm
   on cm.postid =   
where (p.closeddate is not null
and p.posttypeid = 1 -- Q
and ph.posthistorytypeid  = 10 -- closed
and ph.comment in (1, 101)) -- dupe
and (p.answercount > 5)
---OR ((p.posttypeid=1) and (p.answercount > 0))
order by p.Id desc

Enter Parameters

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