Posts with answers, but none upvoted.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Magento

Q&A for users of the Magento e-Commerce platform

select top 500 p.Id as [Post Link], p.Score, p.AnswerCount from Posts p
left join Posts a on a.ParentId=p.Id
where p.PostTypeId=1 and a.PostTypeId=2 and a.Id is not null and p.AcceptedAnswerId is null
group by p.Id,p.Score,p.AnswerCount,p.ViewCount
having max(a.Score) <= 0
order by p.ViewCount desc

Enter Parameters

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