SELECT * FROM npath ( ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime MODE (nonoverlapping) PATTERN ('^H.A*.P1.A*') SYMBOLS (pagetype='home' AS H, pagetype='page1' AS P1, TRUE AS A) RESULT (FIRST(sessionid OF A) AS sessionid, ACCUMULATE (pagetype OF ANY(H,P1,A)) AS path) ) ORDER BY sessionid;