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