gistfile1.txt

SELECT DISTINCT message_id 
FROM SELECT *, id AS message_id FROM user_messages WHERE user_id = ? 
AND read = false AND parent_id IS NULL AS initial_messages 
UNION
SELECT *, parent_id AS message_id FROM user_messages WHERE user_id = ? 
AND read = false AND parent_id IS NOT NULL AS replies;