1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT DISTINCT q.Id, q.AnswerCount, q.Score, a.Id, q.Title
FROM Posts q JOIN PostHistory h ON q.Id=h.PostId
JOIN Posts a ON q.AcceptedAnswerId=a.Id
WHERE q.PostTypeId=1 AND q.AcceptedAnswerId IS NOT NULL
AND q.Tags LIKE '%mi-yodeya-series%'
ORDER BY q.Score DESC, q.AnswerCount DESC;

fork query

edited sep 2 18

created sep 2 18 ..28092