SELECT t.trackId, t.userId, t.partyId, t.title, t.author, t.url, t.nominationDate
FROM Track t
LEFT JOIN vote v ON t.trackId = v.trackId
WHERE partyId=@PartyId
AND t.trackId NOT IN
    (SELECT ht.trackId
    FROM historyTrack ht)
GROUP BY t.trackId, t.userId, t.partyId, t.title, t.author, t.url, t.nominationDate
ORDER BY
    (SELECT COUNT(*)
    FROM vote
    WHERE vote.trackId = t.trackId) DESC