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

Question

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 https://gist.github.com/anonymous/56734604007a2698277809a528c50095

Answer 1

I turned the MySQL strict setting to 'OFF' and this is working ok now.