An Error Was Encountered

Error Number: 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 type_id' at line 1

SELECT products.image,products.id,products.name,products.price FROM products WHERE subcategories_id= ORDER BY type_id