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;