aoxu

数字货币招商
咨询请联系
24小时对接返款
出四件套
采集群成员
查开房
找人定位
接私人定制
日赚
日结

aoxu

#Provider: https://www.rixcloud.com
#Powered by rixCloud
#Version 20190814

# rixCloud, Inc.
# !! Service Warning !!
# Modifying Managed Configuration or using a third-party profile means voluntarily giving up rixCloud support services and Service Level Agreements(SLA).
# !! Service Warning !!

[General]

aoxu

Microsoft (R) Windows Debugger Version 10.0.18869.1002 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [C:\Windows\LiveKernelReports\NDIS-20190617-2027.dmp]
Kernel Bitmap Dump File: Kernel address space is available, User address space may not be available.

Symbol search path is: srv*
Executable search path is:
Windows 10 Kernel Version 17763 MP (16 procs) Free x64

aoxu

SELECT
  user_id, event_params.value.int_value/1000000 as price_in_usd, event_value_in_usd as exchanged_revenue_in_usd
FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
WHERE
  event_name = 'in_app_purchase'
  AND event_params.key = 'value'
  /* AND event_params.value.int_value = 51 */
  AND _TABLE_SUFFIX BETWEEN '20181117' AND '20181118' /* 修改为付费日期范围 */

aoxu

SELECT
  max_layer,
  COUNT(user_id) as user_count
FROM (
  SELECT
      user_id,
      max(event_params.value.int_value) as max_layer  /* 只要已解锁的最大矿层数 */
  FROM
    `analytics_168921341.events_*` AS T,
    T.event_params

aoxu

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'*/ /* 修改为指定国家 */

aoxu

SELECT
    user_id,
    max(event_params.value.int_value)  /* 只要已解锁的最大矿层数 */
FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
WHERE
  event_name = 'activate_manto'
  AND event_params.key = 'manto_id'
  AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181109'

aoxu

SELECT
  max_layer,
  COUNT(user_id) as user_count
FROM (
  SELECT
      user_id,
      max(event_params.value.int_value) as max_layer  /* 只要已解锁的最大矿层数 */
  FROM
    `analytics_168921341.events_*` AS T,
    T.event_params

aoxu

SELECT
    user_id,
    max(event_params.value.int_value) as max_layer  /* 只要已解锁的最大矿层数 */
FROM
  `analytics_168921341.events_*` AS T,
  T.event_params
WHERE
  event_name = 'activate_manto'
  AND event_params.key = 'manto_id'
  AND user_id IN (

aoxu

SELECT
  max_layer,
  COUNT(user_id) as user_count
FROM (
  SELECT
      user_id,
      max(event_params.value.int_value) as max_layer  /* 只要已解锁的最大矿层数 */
  FROM
    `analytics_168921341.events_*` AS T,
    T.event_params