A Database Error Occurred

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 c1.nombre ASC' at line 3

SELECT * from tblcategorias_new c1 JOIN tblcategorias_lang_new c2 ON c1.id_categoria = c2.id_categoria WHERE c2.id_lang="es_ES" AND c1.city_name = 'barcelona' AND c2.city_name = 'barcelona' AND c1.id_categoria = order by c1.nombre ASC

Filename: /var/www/smartsalus_git/models/categorias_model.php

Line Number: 78