4 months ago

Use SUM of value in related table in where clause

Posted 4 months ago by Kimmer

Hi all,

I'm struggling with what appears to be a difficult query. I'll try to explain as simple as possible.

I have a table called "tracks" and a table called 'votes"

A track can have many votes but a vote can be 1 or -1. These values are stored in a column named "vote" in the "votes" table. So each track has a score from the sum of its votes.

I'm trying to collect tracks below or above a certain score.

So in theory I would need something like this:

->where('sum(','<', 0) // for all tracks with a minus score

Obviously, this would be too easy.

Is anyone willing and able to nudge me in the right direction?


Please sign in or create an account to participate in this conversation.