select a.Id, a.PostTypeId, a.title, a.Body,a.AcceptedAnsw...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select a.Id, a.PostTypeId, a.title, a.Body,a.AcceptedAnswerId, b.Body 
as AnswerBody, a.Tags, a.Score,a.ViewCount, b.Score 
as AnswerScore, a.AnswerCount, a.CommentCount, a.CreationDate, a.LastActivityDate 
from Posts as a left join Posts as b on 
(a.Id = b.ParentId and a.AcceptedAnswerId = b.Id) where 
a.PostTypeId = 1 and a.AcceptedAnswerId is not null and a.Score > 0 
and a.Tags like '%parameterized-unit-test%'

Enter Parameters

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