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 cabin.settlement IN ('השרון') AND cabin.settlement IN ('גליל מערבי','קריות','רמת הגולן','גליל עליון','גליל תחתון','מרכז','מישור החוף','דרום','ירושלים והסביבה','חדרה זכרון ועמקים','השרון') AND cabinCat.catID = 252 AND cabinCat2.catID = 51 AND cabinCat3.catID = 261 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()