36 lines
1.1 KiB
Text
36 lines
1.1 KiB
Text
|
SELECT session_id as Id,
|
||
|
|
min(min_timestamp) as StartedAt,
|
||
|
|
max(max_timestamp) - min(min_timestamp) as Duration,
|
||
|
|
countMerge(events_count) as EventsCount,
|
||
|
|
any(app_version) as AppVersion,
|
||
|
|
any(country_code) as CountryCode,
|
||
|
|
any(region_name) as RegionName,
|
||
|
|
any(os_name) as OsName,
|
||
|
|
any(os_version) as OsVersion
|
||
|
|
FROM sessions_live_v1
|
||
|
|
WHERE app_id = '{{app_id}}'
|
||
|
|
{% if country_code %}
|
||
|
|
AND country_code = '{{country_code}}'
|
||
|
|
{% endif %}
|
||
|
|
{% if os_name %}
|
||
|
|
AND os_name = '{{os_name}}'
|
||
|
|
{% endif %}
|
||
|
|
{% if app_version %}
|
||
|
|
AND app_version = '{{app_version}}'
|
||
|
|
{% endif %}
|
||
|
|
{% if date_to %}
|
||
|
|
AND (min_timestamp < '{{date_to}}' OR (min_timestamp = '{{date_to}}' AND session_id < '{{session_id}}'))
|
||
|
|
{% endif %}
|
||
|
|
{% if date_from %}
|
||
|
|
AND (min_timestamp > '{{date_from}}' OR (min_timestamp = '{{date_from}}' AND session_id > '{{session_id}}'))
|
||
|
|
{% endif %}
|
||
|
|
GROUP BY session_id
|
||
|
|
{% if event_name %}
|
||
|
|
HAVING hasAny(groupArrayMerge(events_name), ['{{event_name}}'])
|
||
|
|
{% endif %}
|
||
|
|
{% if date_from %}
|
||
|
|
ORDER BY StartedAt ASC, Id ASC
|
||
|
|
{% else %}
|
||
|
|
ORDER BY StartedAt DESC, Id DESC
|
||
|
|
{% endif %}
|
||
|
|
LIMIT 10
|