14 lines
391 B
Text
14 lines
391 B
Text
|
SELECT uniq(user_id) as Users,
|
||
|
|
country_code as CountryCode,
|
||
|
|
region_name as RegionName
|
||
|
|
FROM (
|
||
|
|
SELECT session_id,
|
||
|
|
min(min_timestamp) AS timestamp,
|
||
|
|
any(user_id) AS user_id,
|
||
|
|
any(country_code) AS country_code,
|
||
|
|
any(region_name) AS region_name
|
||
|
|
FROM sessions_live_v1
|
||
|
|
WHERE app_id = '{{app_id}}'
|
||
|
|
GROUP BY session_id
|
||
|
|
HAVING timestamp >= now() - INTERVAL 1 HOUR
|
||
|
|
) GROUP BY country_code, region_name
|