1054 - Unknown column 'p.products_quantity' in 'field list'
SELECT distinct
p.products_id,
p.products_price,
p.products_model,
p.products_quantity,
p.products_shippingtime,
p.products_fsk18,
p.products_image,
p.products_weight,
p.products_tax_class_id,
pd.products_name,
pd.products_short_description,
pd.products_description,
pd.producent,
p2c.categories_id,
tcd.categories_name FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' LEFT OUTER JOIN products_to_categories AS p2c ON (p.products_id = p2c.products_id) LEFT OUTER JOIN categories_description AS tcd ON (p2c.categories_id = tcd.categories_id ) WHERE p.products_status = '1' AND pd.language_id = '3'AND pd.producent='Shiseido' AND tcd.categories_name= 'Damskie' ORDER BY pd.producent, pd.products_name
[XT SQL Error]