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='16133' 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 != '16133' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, product
Aerial Assault Automatic Trap
- Automatic Trap
- Traps
- Gator Outdoors
