0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select  
        -- select answeres that have source code for java questions
        a.Body as "Answeres",
        a.Score, 
        q.Id as [Post Link],
        q.Tags as " Question Tags" ,
        q.Body, 
        q.AnswerCount, 
        q.Id

FROM Posts a

JOIN Posts q on a.ParentId=q.Id

Join PostTags t on q.Id = t.PostId

WHERE 
q.AnswerCount>1
AND
a.Body like'%<code>%'

AND 

(
-- java tag
t.TagId= 17 
-- Or  

--t.TagId= 78533
)

Order by q.Id Desc

fork query

edited nov 13 17

created nov 9 17 Farouq.AlOmari