"""SQL queries for art_relations."""

# get expiring contracts with details
OBTAIN_EXPIRING_CONTRACTS = """
    SELECT
        v.company,
        v.vendor_id,
        vc.cont_end
    FROM
        vw_active_vendor_contract vac
    INNER JOIN vendor_contract vc
        ON vac.vendor_contract_id = vc.id
    INNER JOIN vendor v
        ON vc.vendor_id = v.vendor_id
    WHERE
        vc.unlimited_roll = 'N'
        AND vc.cont_end = DATE_ADD(CURDATE(), INTERVAL 30 DAY);
    """