WSRecommender version 1.3, WSRecommenderReduce version 1.4
SELECT * FROM WSRecommender
ON (
SELECT * FROM WSRecommenderReduce (
ON item_table AS ItemTable PARTITION BY item1_column
ON user_table AS UserTable PARTITION BY item_column
[ USING
[ Item1 ('item1_column') ]
[ Item2 ('item2_column') ]
[ ItemSimilarityScore ('similarity_column') ]
[ UserItemColumn ('item_column') ]
[ UserIDColumn ('user_column') ]
[ UserPrefColumn ('preference_column') ]
[ AccumulateItem ({ 'accumulate_item_column' | accumulate_item_column_range }[,...]) ]
[ AccumulateUser ({ 'accumulate_user_column' | accumulate_user_column_range }[,...]) ]
]
) AS alias_1
) AS temporary_table PARTITION BY usr, col1_item2
) AS alias_2;