SELECT m.*, SUM(ur.rating) / COUNT(ur.user_id) AS average_rating, COUNT(ur.user_id) AS num_users, ur2.rating
FROM song_archive m
LEFT OUTER JOIN song_ratings ur ON m.song_id = ur.id
LEFT OUTER JOIN song_ratings ur2 ON ur2.id = m.song_id AND ur2.user_id = -1
WHERE m.user_id = 4335
GROUP BY m.song_id
ORDER BY m.song_name, m.author_name
LIMIT 0, 25 Line : 92 File : search-userssongs.php
