SELECT r.id, r.name, v2.votes
FROM restaurants r LEFT JOIN (
    SELECT top 1 v.id_restaurant AS restid, COUNT(v.id_user) AS votes
    FROM user_votes v
    WHERE v.DATE = ?1
    GROUP BY v.id_restaurant
    ORDER BY votes  DESC
) v2 ON r.id = v2.restid