SELECT NEWID() newid, 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.address, cabin.sales, cabin.prices_min, cabin.price_min, cabin.categories 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 WHERE cabin.sales != '*' AND cabin.zones IN ('בית חרות','גבע כרמל','זכרון יעקב','חדרה','חוף דור','טבעון','יקנעם','יקנעם המושבה','יקנעם עילית','מגדים','נתניה','קיסריה','קרית טבעון','שדה יצחק','תל עדשים') AND cabin.settlement IN ('מרכז') AND ( (prices_z.weekday BETWEEN 1 AND 150) ) AND cabin.types = 'צימר' 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.address, cabin.sales, cabin.prices_min, cabin.price_min, cabin.categories