Search Hotel

Hotels in Birbhum


1 - Can't create/write to file '/tmp/#sql_60b1_1.MYI' (Errcode: 28 - No space left on device)

SELECT IF(h.hotel_currency = 'INR', round(h.min_budget,0),round(h.min_budget*71.50,0)) min_budget_inr, IF(h.hotel_currency='USD',round(h.min_budget,0),round(h.min_budget/71.50,0)) min_budget_usd , h.memberID, h.hotel_logo, h.hotelDesc, h.hotelCatg, h.hotel_class, h.check_in_out_time, h.hotel_currency, h.min_budget, h.hotel_dining, h.no_rooms, m.paid_status, m.phone, m.mobilePhone, m.new_mobile_phone, m.file_name, m.compName, m.memberID, m.city_code, m.city_other, m.sub_city_code,m.state, m.country_code, m.address, m.webAddress, m.contact_visibility_status FROM members m JOIN hotels h ON m.memberID = h.memberID WHERE m.activeStatus IN ('Y','B') && m.memberType = '2' && h.activeStatus = 'Y' && m.city_code = '15982' && m.test_status='0' GROUP BY m.memberID ORDER BY m.paid_status DESC, min_budget_inr ASC

[TEP STOP]