+ ->where('created_at', '<', now()->sub(7, 'day'))
+ ->whereNotIn('classification', ['gg', 'gl', 'number', 'o7'])
+ ->where(function ($query) use ($lang) {
+ $query->whereNull('detected_language');
+ $query->orWhere('detected_language', '=', $lang);
+ })
+ ->orderBy('channel_id')
+ ->orderBy('created_at')
+ ->chunk(5000, function ($msgs) use (&$count, $db) {
+ $previous = null;