Self-answered canonical questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Look for potential self-answered canonical questions, that is, self-answered questions with a score threshold on the answer and on the number of views.

Stack Overflow

Q&A for professional and enthusiast programmers

with duplicates as (
  select RelatedPostId as [target], count(*) as [count]
  from PostLinks
  where LinkTypeId = 3
  group by RelatedPostId
)

select
  max(q.Id) as [Post Link],
  max(q.OwnerUserId) as [User Link],
  max(d.count) as [Duplicates],
  max(q.ViewCount) as [Views],
  max(q.FavoriteCount) as [Favorites],
  max(q.Score) as [Q score],
  max(a.Score) as [A score]
from Posts a, Posts q
left join duplicates d on d.target = q.Id
where a.ParentId = q.Id
  and q.OwnerUserId = a.OwnerUserId
  and a.Score >= ##MinScore##
  and q.ViewCount >= ##MinViews##
  and q.ClosedDate is null
group by q.Id
order by Duplicates desc, max(q.ViewCount) desc

Enter Parameters

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