SELECT user_id, pp.uid as user_uid
FROM analytics.parent_properties pp
JOIN analytics.pushes_sent ps ON ps.user_uid = pp.uid
WHERE
    ps.dt >= '2025-01-01'
    AND sub_type = 'AA'
    AND pushes_sent.dt >= '2025-01-01'
    AND pp.platform in ('iOS', 'Android')
GROUP BY 1
LIMIT 100;