SELECT TOP 50 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, cabin.categories,cabin.zimer_type,cabin.orders_online , cabin_ext.image_text FROM cabin
LEFT JOIN Cities ON cabin.zones = Cities.name
LEFT JOIN cabinCat ON cabin.id = cabinCat.idCabin
LEFT JOIN cabin_ext ON cabin.id = cabin_ext.idCabin LEFT JOIN cabinCat AS cabinCat2 ON cabin.id = cabinCat2.idCabin
LEFT JOIN prices_z ON cabin.id = prices_z.idCabin
WHERE cabin.sales != '*' AND cabin.settlement IN ('מרכז','במישור החוף')
AND cabin.settlement IN ('בגליל המערבי','ברמת הגולן והכנרת','בגליל עליון','מרכז','במישור החוף','בדרום')
AND cabinCat.catID = 16 AND cabinCat2.catID = 17 AND ( cabin.zimer_type = 2) 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, cabin.categories,cabin.zimer_type,cabin.orders_online , cabin_ext.image_text , cabinCat.catID , cabinCat2.catID ORDER BY NEWID()
וילות במרכז עם בריכה עם בריכה מחוממת וילות - RRR.co.il וילות
