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)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

select distinct top 10000 as [Post Link], as users,
us.reputation as reputation,,p.title,p.body, p.ClosedDate,
 p.AnswerCount,ph.comment,a.body as answerBody, p.AcceptedAnswerId,
from posts p
inner join posthistory ph 
   on ph.postid =
inner join Posts a
   on p.Id = a.ParentId
inner join users us
   on p.OwnerUserId =
where (
p.closeddate is not null
and p.AcceptedAnswerId is not null
and p.posttypeid = 1 -- Q
and ph.posthistorytypeid  = 10 -- closed
and ph.comment in (1, 101)) -- dupe
and (p.answercount > 5)
and  > 2386231
---OR ((p.posttypeid=1) and (p.answercount > 0))
order by p.Id asc

Enter Parameters

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