Error 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 a.tipo, a.fecha_alta desc' at line 1
SQL: select a.tipo, a.id_categoria, a.id, b.titulo_producto, b.foto_producto from cat_productos a join cat_productos_lang b on a.id=b.id_producto where b.cod_idioma='es' and a.id_categoria= order by a.tipo, a.fecha_alta desc