Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 3623 [code] => 3623 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An invalid floating point operation occurred. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An invalid floating point operation occurred. ) ) SELECT TOP 20 cabin.* , Cities.cordes , Cities.url , ACOS(SIN(PI()*31.98087767483643/180.0)*SIN(PI()*SUBSTRING ( cabin.cordes_zimmer ,1 , CHARINDEX (',' ,cabin.cordes_zimmer )-1)/180.0)+COS(PI()*31.98087767483643/180.0)*COS(PI()*SUBSTRING ( cabin.cordes_zimmer ,1 , CHARINDEX (',' ,cabin.cordes_zimmer )-1)/180.0)*COS(PI()*SUBSTRING ( cabin.cordes_zimmer ,CHARINDEX (',' ,cabin.cordes_zimmer )+1 , LEN(cabin.cordes_zimmer)-(CHARINDEX (',' ,cabin.cordes_zimmer )))/180.0-PI()*34.743711254713666/180.0))*6371 AS distance FROM cabin LEFT JOIN Cities ON (cabin.zones=Cities.name) WHERE cabin.sales != '*' AND cabin.id != '391' ORDER BY distance