Find Bad User Data Query

SELECT
    aou.shortname AS "Home Library",
    ac.barcode AS "Primary Barocde",
    au.id AS "Database ID",
    CASE WHEN au.email IS NOT NULL AND au.email !~* '^[^@<> ]+@[^@<> ]+\.[^@.*<> ]{2,}$' THEN 'BAD EMAIL' ELSE 'EMAIL OK' END AS "Email Status",
    au.email,
    CASE WHEN au.day_phone IS NOT NULL AND au.day_phone !~* '^[2-9]\d{2}-\d{3}-(\d{4})( x\d+)?$' THEN 'BAD DAY PHONE' ELSE 'DAY PHONE OK' END AS "Day Phone Status",
    au.day_phone,
    CASE WHEN au.evening_phone IS NOT NULL AND au.evening_phone !~* '^([2-9]\d{2}-\d{3}-\d{4}|011[- 0-9]+)( x\d+)?$' THEN 'BAD EVENING PHONE' ELSE 'EVENING PHONE OK' END AS "Evening Phone Status",
    au.evening_phone,
    CASE WHEN au.other_phone IS NOT NULL AND au.other_phone !~* '^([2-9]\d{2}-\d{3}-\d{4}|011[- 0-9]+)( x\d+)?$' THEN 'BAD OTHER PHONE' ELSE 'OTHER PHONE OK' END AS "Other Phone Status",
    au.other_phone,
    CASE WHEN ac2.barcode IS NOT NULL OR ac.id IS NULL THEN 'HAS BAD BARCODE(S)' ELSE 'BARCODES OK' END AS "Barcodes Status",
    CASE WHEN aua.post_code IS NOT NULL THEN 'HAS BAD POST CODE(S)' ELSE 'POST CODES OK' END AS "Post Codes Status"
FROM actor.usr au
    JOIN actor.org_unit aou ON au.home_ou = aou.id
    LEFT JOIN actor.card ac ON au.card = ac.id
    LEFT JOIN actor.card ac2 ON au.id = ac2.usr AND ac2.barcode !~* '^2\d{13}$' AND ac2.active
    LEFT JOIN actor.usr_address aua ON (au.id = aua.usr OR aua.id = au.mailing_address OR aua.id = au.billing_address) AND post_code !~* '(^\d{5}(-\d{4})?$)|(^[ABCEGHJKLMNPRSTVXY]{1}\d{1}[A-Z]{1} *\d{1}[A-Z]{1}\d{1}$)'
WHERE
    au.profile IN (SELECT id FROM permission.grp_descendants_distance(2)) AND (
        ac.id IS NULL
        OR (au.email IS NOT NULL AND au.email !~* '^[^@<> ]+@[^@<> ]+\.[^@.*<> ]{2,}$')
        OR (au.day_phone IS NOT NULL AND au.day_phone !~* '^[2-9]\d{2}-\d{3}-(\d{4})( x\d+)?$')
        OR (au.evening_phone IS NOT NULL AND au.evening_phone !~* '^([2-9]\d{2}-\d{3}-\d{4}|011[- 0-9]+)( x\d+)?$')
        OR (au.other_phone IS NOT NULL AND au.other_phone !~* '^([2-9]\d{2}-\d{3}-\d{4}|011[- 0-9]+)( x\d+)?$')
        OR (ac2.barcode IS NOT NULL)
        OR (aua.post_code IS NOT NULL)
    )
GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13
ORDER BY 1,2