1054 - Unknown column 'p.products_quantity' in 'order clause'

SELECT DISTINCT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, p.products_name,p.categories_name, p.products_date_added FROM( SELECT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, pd.products_name, null as categories_name, p.products_date_added FROM products_description pd INNER JOIN products p ON (p.products_id=pd.products_id AND p.products_status=1) INNER JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) INNER JOIN categories c ON (c.categories_id=p2c.categories_id AND c.categories_status=1) WHERE pd.products_description LIKE ('%jacke%') AND pd.language_id='2' UNION SELECT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, pd.products_name, null as categories_name, p.products_date_added FROM products_description pd INNER JOIN products p ON (p.products_id=pd.products_id AND p.products_status=1) INNER JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) INNER JOIN categories c ON (c.categories_id=p2c.categories_id AND c.categories_status=1) WHERE pd.products_name LIKE ('%jacke%') AND pd.language_id='2' UNION SELECT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, pd.products_name, null as categories_name, p.products_date_added FROM products p INNER JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) INNER JOIN categories c ON (c.categories_id=p2c.categories_id AND c.categories_status=1) INNER JOIN products_description pd ON (p.products_id=pd.products_id AND pd.language_id='2') WHERE p.products_model LIKE ('%jacke%') AND p.products_status=1 UNION SELECT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, pd.products_name, null as categories_name, p.products_date_added FROM products p INNER JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) INNER JOIN categories c ON (c.categories_id=p2c.categories_id AND c.categories_status=1) INNER JOIN products_description pd ON (p.products_id=pd.products_id AND pd.language_id='2') WHERE p.products_style_number LIKE ('%jacke%') AND p.products_status=1 UNION SELECT p.products_id, p.products_price, p.products_image, p.products_tax_class_id, p.products_video, p.products_model, pd.products_name, cd.categories_name, p.products_date_added FROM categories_description cd INNER JOIN products_to_categories p2c ON (cd.categories_id=p2c.categories_id) INNER JOIN categories c ON (c.categories_id=p2c.categories_id AND c.categories_status=1) INNER JOIN products_description pd ON (p2c.products_id=pd.products_id AND pd.language_id='2') INNER JOIN products p ON (p.products_id=pd.products_id AND p.products_status=1) WHERE cd.categories_name LIKE ('%jacke%') AND cd.language_id='2' ) p WHERE products_id > 0 AND p.products_image!='' GROUP BY p.products_id ORDER BY p.products_quantity DESC

[XT SQL Error]