"""SQL queries for getting account payments."""
SQL_GET_VENDOR_PAYMENTS = """
SELECT vendor_id, paidfor_period_id, check_no, sum(check_amt)
FROM checkspaid cp
INNER JOIN releases r on r.upc=cp.upc
INNER JOIN artist_info a on r.artist_id=a.artist_id
WHERE a.vendor_id=:vendor_id
AND paidfor_period_id IN :periods
GROUP BY paidfor_period_id, check_no
UNION
SELECT vendor_id, paidfor_period_id, check_no, sum(check_amt)
FROM vendor_checkspaid
WHERE vendor_id=:vendor_id AND paidfor_type <> 'spotify_equity'
AND paidfor_period_id IN :periods
GROUP BY paidfor_period_id, check_no
ORDER BY paidfor_period_id DESC
"""