INVALID SQL: 1054 : Unknown column 'xcart_products_categories.categoryid' in 'on clause' SQL QUERY FAILURE:SELECT DISTINCT sp2.productid, xcart_products.* FROM xcart_stats_customers_products as sp1, xcart_stats_customers_products AS sp2, xcart_products_categories, xcart_products, xcart_categories LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid WHERE sp1.productid='97' AND sp1.login=sp2.login AND sp2.productid!='97' AND xcart_products.productid=sp2.productid AND xcart_products.forsale='Y' AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.main = 'Y' AND xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' AND xcart_category_memberships.membershipid IN ('', 0) ORDER BY xcart_products.product LIMIT 5 MSM Shampoo - 8 fl oz - Zeolite Support
