SELECT * FROM WSRecommender ( ON (SELECT * FROM WSRecommenderReduce ( ON (SELECT * FROM recommender_product) AS item_table PARTITION BY product_category_a ON (SELECT * FROM recommender_user) AS user_table PARTITION BY product_category Item1 ('product_category_a') Item2 ('product_category_b') ItemSimilarity ('product_similarity') UserItem ('product_category') UserID ('companyname') UserPref ('prod_preference') ) ) AS temp_input_table PARTITION BY usr, col1_item2 ) ORDER BY recommendation desc, item;