INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE:
Code: Select all
SELECT
COUNT(xcart_products.productid),
MIN(xcart_pricing.price) as price ,
xcart_products_lng.product as product_lng,
xcart_products_lng.descr as descr_lng,
xcart_products_lng.full_descr as fulldescr_lng,
IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant,
IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options,
MIN(v_pricing.price) as v_price
FROM
xcart_products,
xcart_pricing ,
xcart_featured_products,
xcart_products_categories,
xcart_categories
LEFT JOIN xcart_products_lng ON
xcart_products_lng.productid =
xcart_products.productid AND
xcart_products_lng.code = 'US'
LEFT JOIN xcart_classes ON
xcart_classes.productid = xcart_products.productid
LEFT JOIN xcart_variants ON
xcart_variants.productid = xcart_products.productid
LEFT JOIN xcart_pricing as v_pricing ON
v_pricing.variantid = xcart_variants.variantid AND
v_pricing.quantity = 1 AND
v_pricing.membership IN ('','')
WHERE
xcart_products.productid=xcart_featured_products.productid AND
xcart_featured_products.avail='Y' AND
xcart_featured_products.categoryid='0 AND
xcart_pricing.productid=xcart_products.productid AND
xcart_pricing.quantity=1 AND
xcart_pricing.membership IN ('','') AND
xcart_products.product_type <> 'C' AND
xcart_products.product_type <> 'B' AND
xcart_pricing.variantid = 0 AND
xcart_products_categories.productid=xcart_products.productid AND
xcart_products_categories.categoryid = xcart_categories.categoryid AND
xcart_categories.membership IN ('','') AND
xcart_products.forsale='Y'
GROUP BY
xcart_products.productidI can not find out the location of this sql sentence so that i can not repair it, dear friend! can you help me? thanks so much!
Jcart | I formatted for you so people could actually read it.. I suggest you do the same next time.