Okay,
So basically there is a better way of writing for the same output the Order By and Group By are giving me?
I’ve tried a few different queries without the group by and am at a loss. This was the only one that outputted exactly what I wanted.
I’m thinking about just running a query grabbing top three films. And then, while looping that in PHP, just running individual queries to grab the top video for each film. so, in essence four queries. More efficient?
Cheers
Ryan