0

Please login or register to vote for this query.

(click on this box to dismiss)

Give me a list of votes I casted.

Q&A about the site for Joomla! administrators, users, developers and designers

-- Which votes did I gave?
-- Give me a list of votes I casted.

DECLARE @UserId int = ##UserId##

SELECT
    Posts.Title,
    VoteTypes.Name 
FROM Votes
    INNER JOIN Posts ON Posts.Id = Votes.PostId
    INNER JOIN VoteTypes ON VoteTypes.Id = Votes.VoteTypeId
WHERE 
    Votes.UserId = @UserId

fork query

edited jan 17 12 kiamlaluno

created may 24 10 sam.saffron