Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH
- watch_device as
- (SELECT userId
- FROM wimc.mp_userDevice
- WHERE deviceType = 'watch'
- AND ts >= '2025-06-01'),
- user_setting AS
- (SELECT DISTINCT user_id::UInt64 AS user_id
- FROM stat.user_setting_history
- WHERE ts >= '2025-06-10'
- AND name = 'circles_concept_enabled'
- AND value IN (1, '1', '"1"'))
- SELECT toDate(ts) as date,
- count(parent) as users,
- uniqExact(parent) as uniqUesers
- from wimc.mp_parentChild pc
- join watch_device wd on pc.child = wd.userId
- join user_setting us on us.user_id = pc.parent
- where ts >= '2025-06-01'
- GROUP BY 1
- ORDER BY 1 DESC
- limit 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
