$messageCount = DB::table('wire_messages as wm')
        ->join('wire_participants as wp', 'wm.conversation_id', '=', 'wp.conversation_id')
        ->where('wp.participantable_id', $user_id)
        ->where('wm.sendable_id', '!=', $user_id)
        ->whereColumn('wm.created_at', '>', 'wp.last_active_at')
        ->count();