הובלות ביהודה ושומרון

SELECT cabin.name, cabin.id, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, cabin.types, cabin.settlement, cabin.zones, cabin.sales ,cabin.num_employes ,cabin.trucks, cabin.img, cabin.service_areas, cabin.num_rates, cabin.logo_txt, cabin.logo_colors , cabin.whatsapp , idTz , movies , areasCats.url AS areaUrl FROM cabin LEFT JOIN Cities ON cabin.zones=Cities.name LEFT JOIN areasCats ON cabin.settlement=areasCats.name LEFT JOIN cabin_srvs_areas ON cabin.id = cabin_srvs_areas.idCabin WHERE cabin.sales != '*' AND (cabin_srvs_areas.srv_name='יהודה ושומרון' OR cabin.service_areas='1') GROUP BY cabin.name, cabin.id, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, cabin.types, cabin.settlement, cabin.zones, cabin.sales ,cabin.num_employes ,cabin.trucks, cabin.img, cabin.service_areas, cabin.num_rates, cabin.logo_txt, cabin.logo_colors , cabin.whatsapp , idTz , movies , areasCats.url ORDER BY ACOS(SIN(PI()*32.078034/180.0)*SIN(PI()*SUBSTRING ( cabin.cordes_zimmer ,1 , CHARINDEX (',' ,cabin.cordes_zimmer )-1)/180.0)+COS(PI()*32.078034/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.292407/180.0))*6371