WITH (
              extract(visitParamExtractString(sentPayload, 'message'), '"custom_type":"([^"]+)"') AS m_type,
              extract(visitParamExtractString(sentPayload, 'message'), '"subType":"([^"]+)"') AS m_sub_type,
              visitParamExtractString(sentPayload, 'custom_type') AS s_type,
              visitParamExtractString(sentPayload, 'subType') AS s_sub_type
            )
        SELECT dtSent                                                               AS dt,
               tsSent                                                               AS ts,
               status                                                               AS status,
               multiIf(userDeviceOs = 1 AND m_type != '', m_type,
                       userDeviceOs = 2 AND s_type != '', s_type, '')               AS type,
               multiIf(userDeviceOs = 1 AND sentDebug != 'huawei' AND m_sub_type != '', m_sub_type,
                       userDeviceOs = 1 AND sentDebug = 'huawei' AND s_sub_type != '', s_sub_type,
                       userDeviceOs = 2 AND s_sub_type != '', s_sub_type, pushType) AS sub_type,
               title                                                                AS title,
               text                                                                 AS text,
               toUInt64(userId)                                                     AS user_id,
               userUid                                                              AS user_uid,
               userType                                                             AS user_type,
               userDeviceOs                                                         AS user_device_os
        FROM logs.pushes_sent AS ps