INVALID SQL: 1176 : Key 'productid' doesn't exist in table 'xcart_variants' SQL QUERY FAILURE:SELECT xcart_variants.*, MIN(xcart_pricing.price) as price, IF(xcart_images_W.id IS NULL, '', 'Y') as is_image, xcart_images_W.image_path as image_path_W FROM xcart_variants USE INDEX (productid) LEFT JOIN xcart_pricing ON xcart_variants.productid = xcart_pricing.productid AND xcart_pricing.variantid = xcart_variants.variantid AND xcart_pricing.membershipid = '0' AND xcart_pricing.quantity = '1' LEFT JOIN xcart_images_W ON xcart_images_W.id = xcart_variants.variantid WHERE xcart_variants.productid = '242' GROUP BY xcart_variants.variantid The bamboo Jacket :: Jackets :: Sale & Consignment :: Linda Ayre Custom Couture Dress Design in San Francisco
