INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'ON'
SQL QUERY FAILURE: SELECT xcart_products.*, xcart_products.avail-0 AS avail, min(xcart_pricing.price) AS price , IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant FROM xcart_products, xcart_pricing LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid='1523' 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 = '') GROUP BY xcart_products.productid