Highest Voted Answers by Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT TOP 200 a.Score, q.Title, a.ID As [Post Link],
    a.OwnerUserID [User Link], COALESCE(a.LastEditDate, a.CreationDate) LastChange 
FROM Tags t
INNER JOIN PostTags pt ON pt.TagID = t.ID
INNER JOIN Posts q ON q.ID = pt.PostID
INNER JOIN Posts a ON a.ParentID = q.ID
WHERE TagName = '##Tag##'

ORDER BY a.Score DESC

Enter Parameters

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