Extract questions and answers- accepted and most voted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT Top 50
q.id, q.Title, q.Body q_body,q.CreationDate, q.Score q_score, q.AnswerCount, q.Tags, q.viewcount,answers.parentid aa_pid, 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 '%penvi%' AND q.viewcount > =200 AND q.CreationDate >=cast('2019-1-1' as datetime)

Enter Parameters

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