"""Subaccount with contact details."""

SUBACCOUNT_WITH_CONTACTS_SQL = """
SELECT
    s.subaccount_id,
    v.vendor_id,
    s.subaccount_uuid,
    s.subaccount_name,
    s.description,
    CAST(s.date_deleted AS CHAR) as date_deleted,
    s.country_id,
    vc.id as vend_contact_id
FROM
    subaccount s
JOIN vendor v
    ON v.vendor_id = s.vendor_id
    AND v.vendor_id = {vendor_id}
LEFT JOIN vend_contact vc
    ON vc.subaccount_id = s.subaccount_id
    AND vc.active = 'Y'
WHERE s.date_deleted IS {date_deleted}
GROUP BY s.subaccount_id
ORDER BY s.subaccount_name ASC, vc.id ASC
{limit_offset};
"""