Clínica de rehabilitación Zájara - Jardín de la Seda

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 ') HAVING distance < 50 ORDER BY distance ASC ' at line 11
SQL ==> SELECT distinct A.IdTLS_Asociado, A.*, P.Nombre as NomProvincia, L.Nombre as NomLocalidad, ( 6371 * acos( cos( radians(37.988105) ) * cos( radians( xGoogle ) ) * cos( radians( yGoogle ) - radians(-1.140422) ) + sin( radians(37.988105) ) * sin( radians( xGoogle ) ) ) ) AS distance FROM TLS_Asociado A, TLS_AsociadoEspecialidad AE, TLS_Provincia P, TLS_Localidad L WHERE A.Quitar is null AND AE.Quitar is null AND A.IdTLS_Asociado = AE.IdTLS_Asociado AND P.IdTLS_Provincia = A.IdTLS_Provincia AND L.IdTLS_Localidad = A.IdTLS_Localidad AND A.Premium is not null AND AE.IdTLS_Especialidad in () HAVING distance < 50 ORDER BY distance ASC LIMIT 3