'not in' operator for the ModerationStateFilter uses the wrong conjunction

Try To Fix the Custom CMD Failed Patch #11.
Add the Interdiff For the 11-13 patch.

Fix the Failed Patch.

#6 has not been addressed.

I encountered the same issue. We have two moderation states: Trashed and Archived.

I wanted to filter out content from a custom view with both moderation states but it was impossible.

This patch seems to fix the issue in the core Moderated content view but I can still see the issue in a custom view using the Moderation state filter.

The patch seems to change the filter correctly like this:

SELECT "node_field_data"."langcode" AS "node_field_data_langcode", "node_field_revision"."changed" AS "node_field_revision_changed", "node_field_data"."nid" AS "nid"
FROM
{node_field_data} "node_field_data"
INNER JOIN {node_field_revision} "node_field_revision" ON node_field_data.vid = node_field_revision.vid
LEFT JOIN {content_moderation_state_field_revision} "content_moderation_state" ON node_field_revision.vid = content_moderation_state.content_entity_revision_id AND (content_moderation_state.content_entity_type_id = 'node' AND content_moderation_state.content_entity_id = node_field_revision.nid AND content_moderation_state.langcode = node_field_revision.langcode)
INNER JOIN {node} "node" ON node_field_revision.nid = node.nid
WHERE ("node"."type" IN ('article', 'blog', 'collection', 'education_training', 'event', 'external_app', 'page', 'person', 'project', 'research_group', 'subsite', 'thesis', 'webform', 'weblink')) AND (("content_moderation_state"."workflow" = 'default') AND ("content_moderation_state"."moderation_state" NOT IN ('trashed', 'archived')))
ORDER BY "node_field_revision_changed" DESC
LIMIT 10 OFFSET 0

But it does not yet filter out the content correctly based on the moderation state if multiple values are selected.