Output a maximum of two similar users (hub) and recommend two products (authority) for each user. Use frequency of purchase as a weight factor.
SELECT * FROM pSALSA ( ON user_product_nodes AS vertices PARTITION BY nodename ON women_apparel_log AS edges PARTITION BY username SourceKey ('username') TargetKey ('product') EdgeWeight ('frequency') MaxHubNum ('2') MaxAuthorityNum ('2') TeleportProb ('0.15') RandomWalkLength ('500') ) ORDER BY username, hub_score DESC, authority_score DESC;