0

Please login or register to vote for this query.

(click on this box to dismiss)

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##%');

fork query

created dec 12 11 penningtonthing