recent_payments AS (
    SELECT
        uid,
        MAX(PaidTill)::date AS paid_till_date
    FROM
        analytics.money
    WHERE
        ChargeNumber >= 1
        AND was_refunded != 1
        AND CONCAT(Type, Value) IN ('subscription_30', 'subscription_365')
        AND USDGross >= 0.25
        -- AND PaidTill >= today() - INTERVAL '30 day'
    GROUP BY uid
),