0

Please login or register to vote for this query.

(click on this box to dismiss)

Search UserId's Favorites for a Tag string. Tag searches use a % wildcard by default.

Q&A for anime and manga fans

-- 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],
       Votes.CreationDate

FROM Votes, Posts

WHERE
     (Votes.PostId=Posts.Id) AND
     (Votes.VoteTypeId = 5) AND
     (Votes.UserId=##User:int##) AND
     (Posts.Tags LIKE '%##TagName##%')

ORDER BY Votes.CreationDate DESC
--ORDER BY Posts.Score DESC

fork query

edited jan 24 12 gideon

created dec 13 11 penningtonthing