SELECT SQL_CALC_FOUND_ROWS Allocation.Hotel_id, Allocation.nights, Allocation.beds, Allocation.extbeds,
Allocation.adults, Allocation.children, Allocation.roomCategory_id, Price.start_date, Price.Tour_id, Price.value,
Board.name AS board_name, RoomType.name AS RoomTypeName, Hotel.name AS hotname, Hotel.stars,
City.name AS city_name, Tour.Currency_id, Currency.name AS curr_name, RoomCategory.name AS roomcat,
RoomCategory.id AS room_id, Resort.name AS resort_name, Country.name AS country_name FROM Allocation
INNER JOIN Price ON Allocation.Price_id=Price.id
INNER JOIN Board ON Board.id=Allocation.Board_id
INNER JOIN RoomType ON RoomType.id=Allocation.RoomType_id
INNER JOIN Hotel ON Allocation.Hotel_id=Hotel.id
INNER JOIN City ON Hotel.City_id=City.id
INNER JOIN Tour ON Tour.id=Price.Tour_id
INNER JOIN Currency ON Currency.id=Tour.Currency_id
INNER JOIN RoomCategory ON RoomCategory.id=Allocation.roomCategory_id
INNER JOIN Resort ON Resort.id=City.Resort_id
INNER JOIN Country ON Country.id=City.Country_id
$where ORDER BY Price.id DESC LIMIT $start, $onPage