Producto NO disponible

-3739
SELECT p.ID, p.Emisor, p.Interes, h.Nombre AS NombreEmisor, MAX(p.Cuotas) AS Cuotas 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 = 'Crucero' LEFT JOIN entidades as e ON e.Nombre = p.Entidad WHERE Archivado = 0 AND (p.Desde <= CURDATE() AND p.Hasta >= CURDATE()) AND p.Categoria = '100' AND p.Operador IN () AND pp.ID_Producto=3739 AND Cuotas!='1' GROUP BY NombreEmisor, Interes ORDER BY Cuotas DESC, NombreEmisor

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 ') AND pp.ID_Producto=3739 AND Cuotas!='1' GROUP BY NombreEmisor, Interes ORD' at line 6