SELECT * FROM npath ( ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime MODE (nonoverlapping) PATTERN ('REFERRER{2,}') SYMBOLS (referrer IS NOT NULL AS REFERRER) RESULT (FIRST(sessionid OF REFERRER) AS sessionid, FIRST(productname OF REFERRER) AS product) ) ORDER BY sessionid;