id) ->select('game_name', \Illuminate\Support\Facades\DB::raw('MAX(created_at) as last_played_at')) ->groupBy('game_name') ->orderByDesc('last_played_at') ->limit(8) ->get() ->map(fn($row) => [ 'game_name' => $row->game_name, 'slug' => strtolower(preg_replace('/[^a-z0-9]+/i', '-', $row->game_name)), 'last_played_at' => $row->last_played_at, ]); return response()->json(['data' => $games]); } }