Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
520 B
8
Indexable
Never
SELECT 
   kind, 
FROM 
    `browserstack-production.mobile.platform_stats_long_term_analytics` as p 
    join `automate.automate_test_sessions_partitioned` pstat 
    on session_id = pstat.hashed_id
WHERE 
   (DATE(_PARTITIONTIME) >= "2022-11-01" or _PARTITIONTIME is null)
   AND DATE(created_day) >= "2022-11-01"
   AND (pstat.device IS NOT NULL
    OR pstat.device = '')
   AND real_mobile = 1
   and user.group_id = 5780131
   AND kind = 'internet-connectivity-failure'
   AND pre_quit LIKE "%chrome not reachable%"