Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- uid,
- simpleJSONExtractString(addJson, 'details') AS rejection_reason,
- dt AS rejection_date
- FROM stat.funnelTrack
- WHERE action IN ('feature_disabled', 'feature_deactivated')
- AND dt >= today()
- AND (
- simpleJSONExtractString(addJson, 'experiment') = 'android_gmd_57483_newApp_v01_ru_experiment'
- OR simpleJSONExtractString(addJson, 'experimentId') = 'android_gmd_57483_newApp_v01_ru_experiment'
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement