Unclosed Posts with no answer and 1 comment (not by author), ordered by comment age

1

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.ViewCount, p.CreationDate,c.CreationDate from Posts p
inner join Comments c on c.PostId=p.Id and c.UserId!=p.OwnerUserId
where p.PostTypeId=1 and p.AnswerCount=0 and ClosedDate is null and p.CommentCount = 1 and c.Text like '%?'
order by c.CreationDate asc

Enter Parameters

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