"""SQL Queries."""

SELECT_EMAIL_ADDRESSES_FOR_VENDOR = """
    SELECT email_address
    FROM inbound_major_label_mapping labels
    JOIN error_reporting_email_address emails
    USING (inbound_major_label_mapping_id)
    WHERE labels.vendor_id = %s
    AND labels.subaccount_id is NULL;
"""

SELECT_EMAIL_ADDRESSES_FOR_SUBACCOUNT = """
    SELECT email_address
    FROM inbound_major_label_mapping labels
    JOIN error_reporting_email_address emails
    USING (inbound_major_label_mapping_id)
    WHERE labels.vendor_id = %s
    AND labels.subaccount_id = %s;
"""