SELECT * FROM nPath ( ON clickstream PARTITION BY userid ORDER BY userid, sessionid, clicktime MODE (OVERLAPPING) PATTERN ('A.B') SYMBOLS (true AS A, true AS B) RESULT (FIRST (sessionid OF A) AS sessionid, FIRST (pagetype OF A) AS pageid, FIRST (pagetype OF B) AS next_pageid) ) ORDER BY sessionid;