1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pd.products_name' at line 1

select m.manufacturers_name, p.products_id, p.products_price, p.products_model, p.products_status, pd.products_name from manufacturers m, products p, products_description pd, products_to_categories ptc where m.manufacturers_id = p.manufacturers_id and pd.products_id = p.products_id and ptc.products_id = p.products_id and ptc.categories_id = ORDER BY pd.products_name