Exclusive Hotel Deals
A faster, easier way to save up to 50% off Hotels

Exclusive Hotel Deals
A faster, easier way to save Upto
50% off Hotels...

Can't change size of file (OS errno 28 - No space left on device)

SELECT * FROM ( SELECT ah.* FROM am_all_hotels as ah , am_all_hotel_rates as hr where hr.am_hotel_id=ah.id and hr.rate>0 ORDER BY RAND() limit 6 ) AS t GROUP BY t.HotelCityCode