1054 - Unknown column 's.specials_date_available' in 'on clause'
SELECT p.products_id, p.products_image, p.products_tax_class_id,
p.products_date_added, p.products_status, p.products_price,
IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,
pd.products_name, pd.products_limited, pd.products_collectors,
m.manufacturers_name AS brand_name
FROM products p
LEFT JOIN specials s
ON p.products_id = s.products_id
AND s.status = 1
AND (s.specials_date_available IS NULL OR s.specials_date_available <= NOW())
AND (s.expires_date IS NULL OR s.expires_date > NOW())
LEFT JOIN products_description pd ON pd.products_id = p.products_id
LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
WHERE pd.language_id = '6'
AND p.manufacturers_id = '122'
AND p.products_id != '1163'
AND p.products_status = 1
AND p.products_price > 0
LIMIT 12 OFFSET 0
[TEP STOP]
|
