0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT p.Id
, p.Title
, p.Tags
, P.AnswerCount
,p.AcceptedAnswerId
,P.CreationDate
,p. ViewCount
, p.Body 
,a.Body
,t.TagName

FROM Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id -- to get bot question and answer
JOIN PostTags pt ON pt.PostId=p.Id
JOIN Tags t on t.Id =pt.TagId
WHERE p.PostTypeId=1
AND p.Title like '%regression'
-- AND p.AcceptedAnswerId not null 
-- AND t.TagName like '%C++%'

fork query

edited jul 7 19

created jul 7 19 anonymous