1054 - Unknown column 'p.best_price' in 'order clause'
SELECT DISTINCT p.products_fsk18, p.products_shippingtime, p.products_model,
p.products_ean, pd.products_name, m.manufacturers_name,
p.products_quantity, p.products_image, p.products_weight,
pd.products_short_description, pd.products_description, p.products_id,
p.manufacturers_id, p.products_price, p.products_vpe,
p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed,
p.products_tax_class_id
FROM products_description pd, products_to_categories p2c, products p
LEFT JOIN manufacturers m
ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN specials s
ON p.products_id = s.products_id
WHERE p.products_status = '1'
AND p.products_id = p2c.products_id
AND pd.products_id = p2c.products_id
AND pd.language_id = '1'
AND p2c.categories_id = '8' ORDER BY p.best_price ASC
[ECB SQL Error]