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 t0.categories_id, t1.categories_id, t2.categories_id, t3.categorie' at line 22
in:
[SELECT t4.categories_id AS categorie0, t3.categories_id AS categorie1, t2.categories_id AS categorie2, t1.categories_id AS categorie3, t0.categories_id AS categorie4 FROM zen_categories t0 right JOIN zen_categories t1 ON t1.parent_id = t0.categories_id right JOIN zen_categories t2 ON t2.parent_id = t1.categories_id right JOIN zen_categories t3 ON t3.parent_id = t2.categories_id right JOIN zen_categories t4 ON t4.parent_id = t3.categories_id, zen_products_to_categories p2c where ( t0.categories_id = 194 or t1.categories_id = 194 or t2.categories_id = 194 or t3.categories_id = 194 or t4.categories_id = 194 ) and p2c.categories_id = t4.categories_id and p2c.products_id = ORDER BY t0.categories_id, t1.categories_id, t2.categories_id, t3.categories_id, t4.categories_id]