SELECT TOP 30 cabin.name, cabin.id, cabin.units, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, Cities.sub_area, cabin.settlement, cabin.zones, cabin.sales, cabin.max_guests, cabin.num_people_sleep, cabin.place_type, cabin.num_rooms,cabin.num_rates, cabin.price_min, cabin.price_min_wday, bfast, pricesMin.lmin_wend, zimer_type, categories, cabin.address , ACOS(SIN(PI()*33.013122/180.0)*SIN(PI()*SUBSTRING ( cabin.cordes_zimmer ,1 , CHARINDEX (',' ,cabin.cordes_zimmer )-1)/180.0)+COS(PI()*33.013122/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()*35.440172/180.0))*6371 AS distance FROM cabin LEFT JOIN Cities ON (cabin.zones=Cities.name) LEFT JOIN cabinCat ON cabin.id = cabinCat.idCabin LEFT JOIN prices_z ON cabin.id = prices_z.idCabin LEFT JOIN pricesMin ON cabin.id = pricesMin.idCabin WHERE cabin.sales != '*' AND cabin.types='צימר' AND cabin.id NOT IN (2016,385,573,1204) GROUP BY cabin.name, cabin.id, cabin.units, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, Cities.sub_area, cabin.settlement, cabin.zones, cabin.sales, cabin.max_guests, cabin.num_people_sleep, cabin.place_type, cabin.num_rooms,cabin.num_rates, cabin.price_min, cabin.price_min_wday, bfast, pricesMin.lmin_wend, zimer_type, categories, cabin.address , cabinCat.catID , cabinCat2.catID HAVING (COUNT(cabin.id) > 0) ORDER BY distance