INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT DISTINCT xcart_products.productid, xcart_products.productcode, MIN(xcart_pricing.price) AS price, IF (xcart_products_lng.product IS NOT NULL AND xcart_products_lng.product != '', xcart_products_lng.product, xcart_products.product) AS product FROM xcart_products, xcart_pricing, xcart_product_links, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code='US' WHERE xcart_products.productid=xcart_product_links.productid2 AND xcart_product_links.productid1='16147' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND xcart_products.forsale='Y' AND xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' AND xcart_products.productid != '16147' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, product
Paper Hanger
- .22
- Targeting Systems
- Gator Outdoors
