Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) AS implausibly_long_totalLength
- FROM log.ReadingDepth_16325045 AS a
- JOIN log.ReadingDepth_16325045 AS b
- ON a.event_pageToken = b.event_pageToken
- WHERE a.event_action = 'pageLoaded'
- AND b.event_action= 'pageUnloaded'
- AND (b.timestamp - a.timestamp) < (b.event_totalLength + 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement