SELECT p.*, h.Nombre AS NombreEmisor , c.Titulo
FROM promos AS p
LEFT JOIN entidades AS h ON p.Emisor = h.ID
LEFT JOIN producto_promos as pp ON pp.ID_Promocion = p.ID AND pp.Tipo_Producto = 'Paquete' LEFT JOIN entidades as e ON e.Nombre = p.Entidad
LEFT JOIN categorias AS c ON p.Categoria = c.ID AND Producto = 'Promocion'
WHERE Operador='' AND (p.Desde <= CURDATE() AND p.Hasta >= CURDATE()) AND p.Categoria ='100' AND Archivado = 0 AND pp.ID_Producto=
ORDER BY NombreEmisor, Cuotas
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY NombreEmisor, Cuotas' at line 7