Extract questions and answers- accepted and most voted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
q.id, q.Title, q.Body q_body,q.CreationDate, q.Tags, q.viewcount, answers.body aa_body

FROM
Posts answers



INNER JOIN Posts q
ON answers.parentid = q.id

WHERE (answers.id = q.AcceptedAnswerId) AND q.Tags like '%spring-boot%' AND q.viewcount > =100 AND answers.body like '%code%' AND q.CreationDate >=DATEADD(MONTH, -48, GETDATE())

order by q.CreationDate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results