SELECT TOP 10 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 , areasCats.url AS areaUrl FROM cabin LEFT JOIN Cities ON cabin.zones=Cities.name LEFT JOIN areasCats ON cabin.settlement=areasCats.name LEFT JOIN cabinCat ON cabin.id = cabinCat.idCabin LEFT JOIN cabinCat AS cabinCat2 ON cabin.id = cabinCat2.idCabin LEFT JOIN cabinCat AS cabinCat3 ON cabin.id = cabinCat3.idCabin WHERE cabin.sales != '*' AND cabin.zones IN ('אמנון','אפיקים','גינוסר','דגניה א','דגניה ב','חד נס','טבריה','כחל','כנרת - קבוצה','כפר חיטים','כרכום','מגדל','נוף כנרת','סובב כנרת','עין גב','פוריה - נוה עובד','פוריה עילית','פוריה-כפר עבודה','רמות','תל קציר') AND cabinCat.catID = 2 AND cabinCat2.catID = 54 AND cabinCat3.catID = 247 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 , areasCats.url , cabinCat.catID , cabinCat2.catID , cabinCat3.catID ORDER BY NEWID()