Raw Count Group By Query

Hi guys,

this query works, as I execute it on phpmyadmin, but it won't via laravel:

$query = "SELECT
                        COUNT(*) AS visits,
                        users.id AS userid,
                        users.name,
                        users.slug,
                        user_visits.id,
                        user_visits.id_user,
                        user_visits.id_visitor,
                        user_visits.ip_address,
                        user_visits.created_at
                    FROM
                        user_visits
                    LEFT JOIN
                        users ON user_visits.id_user = users.id
                    WHERE
                        user_visits.ip_address = ?
                    GROUP BY
                        user_visits.id_user
                    ORDER BY
                        user_visits.created_at
                    DESC
                        LIMIT 1000";
        $grouped_visits = DB::select($query, [$visit->ip_address]);

I already set strict mode to false (config/database.php) which did not work.

Any ideas?