$q->join('order_flags', function ($join) {
                    /** @var JoinClause|EloquentBuilder $join */
                    $join->on('order_change_logs.order_id', '=', 'order_flags.order_id');
                    $join->where('order_flags.type', '=', 'sent_changes');
                    $join->latest('sent_at');
                    $join->limit(1);
                });