parent_all_child_id

c_ids AS ( -- UID Родителей, ID Детей, Целевые дети
    SELECT
        uid,
        json_data.2 AS children_id,
        json_data.3 AS children_status
    FROM
        analytics.parent_properties
    ARRAY JOIN
        children AS json_data
    WHERE last_active_datetime >= today() - interval '7' day
    and is_full_register
),