Is there a query that will list the highest voted post (question or answer) for each tag on a site?
I think this SEDE query I just wrote does the job.
For reference, here is the complete query:
SELECT TagName, QuestionID AS [Post Link], q_.Score AS [Q score], AnswerID AS [Post Link], a_.Score AS [A score] FROM (SELECT TagName, (SELECT TOP 1 q.Id FROM Posts AS q INNER JOIN PostTags AS qt ON q.Id = qt.PostId WHERE qt.TagId = t.Id ORDER BY q.Score DESC) AS QuestionID, (SELECT TOP 1 a.Id FROM Posts AS a INNER JOIN PostTags AS at ON a.ParentId = at.PostId WHERE at.TagId = t.Id ORDER BY a.Score DESC) AS AnswerID FROM Tags AS t) AS temp INNER JOIN Posts AS q_ ON temp.QuestionId = q_.Id LEFT OUTER JOIN Posts AS a_ ON temp.AnswerId = a_.Id ORDER BY q_.Score DESC
and note that SEDE is updated only once a week, on Sunday morning.