Försöker göra en stored procedure som hämtar en "highscore lista" ur mina tabeller

artists (aid, namn)
records (rid, title, published, aid)
songs (sid, title, rid, uid, played, category)
users (uid, username)
votes (vid, uid, sid, score)

detta är mitt nuvarande (och antagligen patetiska) försök

SET TERM ^ ;
CREATE PROCEDURE sp_view_hiscore(interesting_date DATE,
                                    category VARCHAR(50))
AS
BEGIN
SELECT artist.name, songs.title, records.title, records.published, COUNT(votes.score)
FROM artists INNER JOIN 
    (records  INNER JOIN 
        (songs  INNER JOIN
            (users  INNER JOIN
                votes ON (votes.sid = songs.sid) AND (votes.uid = users.uid))
            ON songs.uid = users.uid)
        ON songs.sid = records.rid)
    ON artists.aid = records.aid
WHERE (songs.played = :interesting_date) AND (songs.category = :category)
ORDER BY COUNT(votes.score) DESCENDING;

END ^
SET TERM ; ^