discussion

WITH
abs_true AS (
SELECT discussion_id
FROM abstractmessage
WHERE dtype = 'NewRootMessage' AND fault = true
),
msg_true AS (
SELECT DISTINCT discussion_id
FROM messagepair
WHERE answerfault = true
),
abs_false AS (
SELECT DISTINCT discussion_id
FROM abstractmessage
WHERE dtype = 'NewRootMessage' AND fault = false
)
-- Проверка первого условия
SELECT abs_true.discussion_id AS "Failed Discussion ID for First Condition"
FROM abs_true
LEFT JOIN msg_true ON abs_true.discussion_id = msg_true.discussion_id
WHERE msg_true.discussion_id IS NULL
UNION ALL
-- Проверка второго условия
SELECT msg_true.discussion_id AS "Failed Discussion ID for Second Condition"
FROM msg_true
LEFT JOIN abs_false ON msg_true.discussion_id = abs_false.discussion_id
WHERE abs_false.discussion_id IS NOT NULL;