Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default. Changed sort to order by date the post was favorited.
Q&A for professional and enthusiast programmers
-- Search UserId's Favorites for Tags with <TagName> (Wildcard)
-- Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default.
SELECT Posts.id as [Post Link],
Posts.Score as [Score],
Posts.Tags as [Tagged With],
FROM Votes, Posts
(Votes.VoteTypeId = 5) AND
(Posts.Tags LIKE '%##TagName##%')
ORDER BY Votes.CreationDate DESC
--ORDER BY Posts.Score DESC