Advertisement
kirzecy670

Untitled

Dec 3rd, 2024
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.28 KB | None | 0 0
  1. traffic as
  2.   (select distinct uid
  3.    from stat.funnelTrack
  4.    where dt between '2023-01-01' and yesterday()
  5.      and action = 'appsflyer_attribution'
  6.      and deviceType = 1
  7.      and appVersion % 2 = 1
  8.      and lower(visitParamExtractString(addJson, 'network')) = 'organic'),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement