Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT COUNT(*) AS implausibly_long_totalLength
  2. FROM log.ReadingDepth_16325045 AS a
  3. JOIN log.ReadingDepth_16325045 AS b
  4. ON a.event_pageToken = b.event_pageToken
  5. WHERE a.event_action = 'pageLoaded'
  6. AND b.event_action= 'pageUnloaded'
  7. AND (b.timestamp - a.timestamp) < (b.event_totalLength + 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement