Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *
- FROM
- `analytics_168921341.events_*` AS T,
- T.event_params
- WHERE
- /* event_name = 'sign_up' */
- /* AND event_params.key = 'guide_id'
- AND event_params.value.int_value = 51 */
- /* AND geo.country = 'United States'*/ /* 修改为指定国家 */
- /* AND platform = 'ANDROID' */
- user_id = '86715'
- AND _TABLE_SUFFIX BETWEEN '20181112' AND '20181112' /* 修改为events数据范围 */
- LIMIT 100
Add Comment
Please, Sign In to add comment