- private function queryChatlog(Channel $channel) {
- return ChatLog::where('type', '=', 'chat')
- ->where('banned', '=', false)
- ->where('created_at', '<', now()->sub(1, 'day'))
- ->where(function ($query) use ($channel) {
- $query->whereNull('detected_language');
- $query->orWhereIn('detected_language', $this->getPreferredLanguages($channel));
- })
- ->inRandomOrder();
- }
-