Query Favorites by UserId and Tag Name. Tag searches use a % wildcard by default.
Q&A for professional and enthusiast programmers
-- List of Favorites for a UserId Tagged with <TagName> -- Query Favorites by UserId and Tag Name. Tag searches use a % wildcard by default. SELECT Posts.id as [Post Link], Posts.Tags as [Tagged With] FROM Votes, Posts WHERE (Votes.PostId=Posts.Id) AND (Votes.VoteTypeId = 5) AND (Votes.UserId=##User:int##) AND (Posts.Tags LIKE '%<##TagName##>%') AND (Posts.Title LIKE '%##BodyText##%') AND (Posts.Body LIKE '%##TitleText##%');