SELECT TOP 6 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.max_guests, cabin.num_people_sleep, cabin.place_type, cabin.num_rooms, price_min 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 innerPage=1 AND ( ( (prices_z.weekend BETWEEN 1 AND 1000) OR (prices_z.weekend1 BETWEEN 1 AND 1000) ) OR ( (prices_z.weekend BETWEEN 1 AND 2000) OR (prices_z.weekend1 BETWEEN 1 AND 2000) ) OR ( (prices_z.weekend BETWEEN 1 AND 3000) OR (prices_z.weekend1 BETWEEN 1 AND 3000) ) OR ( (prices_z.weekend BETWEEN 3001 AND 10000) OR (prices_z.weekend1 BETWEEN 3001 AND 10000) ) ) 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.sales, cabin.max_guests, cabin.num_people_sleep, cabin.place_type, cabin.num_rooms, price_min ORDER BY NEWID()