SQL query works in DB client but not works within the Laravel app

I have a custom SQL query that is loading perfectly fine within my Sequel Pro database application, however when this is loaded through my Laravel app I am getting an error on my web app.

The error i'm getting it as follows : Syntax error or access violation: 1055 't.player' isn't in GROUP BY

The query is below in the gist http://ift.tt/2m81wzE

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ltQBmM
via IFTTT