Re: Help with a Left Join

[Brandon Rodriguez]

Still odd, when I move the games_ratings.rating>0 condition back up to the LEFT JOIN, so the query is this:

SELECT games_files.id, games_files.trackname, games_files.screenshot, games_files.user, games_files.time, AVG( games_ratings.rating ) AS average_rating
FROM games_files
LEFT JOIN games_ratings ON games_files.id = games_ratings.trackid AND games_ratings.rating >0
WHERE games_files.type =4
GROUP BY games_files.id
ORDER BY games_files.id DESC
LIMIT 10

The query's execution time is cut to 21 seconds....