Query doesn't get executed when using orderByRaw()

I'm rather new to Laravel (ex frontend dev here) and today I've run into my first issue that I cannot figure out.

So I'm running a query on my User model and I am trying to use a raw statement for ordering :

$query = User::query()
    ->whereNotIn('username', $blockedUsers)
    ->orderByRaw('FLOOR(((comment_count - discussion_count) * 10 + discussion_count * 21 + votes * 31) / 135) DESC')
    ->offset($offset)
    ->take($limit)
    ->get();

The query runs perfectly fine when I try it on my dev environment but it doesn't get executed (and I get an empty list as result) when I try it on my production environment. I have checked the MYSQL logs and I was surprised to see that the query is Prepared and then Executed on my dev environment and only Prepared on my production environment.

When I change the query to this in my code, everything works fine, also on production :

$query = User::query()
    ->whereNotIn('username', $blockedUsers)
    ->orderBy('votes', 'desc')
    ->offset($offset)
    ->take($limit)
    ->get();

But now the results are not really in the right order...

This is a real mystery to me, if anyone has a clue, please let me know.