SELECT TOP 1 cabin.* , Cities.cordes
, ACOS(SIN(PI()*31.749335/180.0)*SIN(PI()*SUBSTRING ( cabin.cordes_zimmer ,1 , CHARINDEX (',' ,cabin.cordes_zimmer )-1)/180.0)+COS(PI()*31.749335/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.703225/180.0))*6371 AS distance
FROM cabin LEFT JOIN Cities ON (cabin.zones=Cities.name) WHERE types='צימר' AND cabin.sales != '*' AND cabin.id NOT IN (2596) ORDER BY distance
<![CDATA[Array
(
[0] => Array
(
[0] => 42000
[SQLSTATE] => 42000
[1] => 3623
[code] => 3623
[2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]An invalid floating point operation occurred.
[message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]An invalid floating point operation occurred.
)
)
]]>
