SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='11'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='8'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='3'
ORDER BY price_promo ASC
SELECT
skiathos_promo_prices.id_promo AS promo_id,
skiathos_promo_prices.id_room AS id_room,
skiathos_promo_prices.id_period AS id_period,
skiathos_promo_prices.price AS price_promo,
skiathos_prices.price AS price,
skiathos_rooms.exclude_best_price AS exclude_best_price
FROM
skiathos_prices LEFT JOIN (skiathos_promo_prices JOIN skiathos_promo JOIN skiathos_rooms)
ON
skiathos_promo_prices.id_room=skiathos_prices.id_room
AND skiathos_promo_prices.id_period=skiathos_prices.id_period
AND skiathos_promo_prices.id_promo=skiathos_promo.id
AND skiathos_prices.id_hotel=skiathos_promo.id_hotel
AND skiathos_prices.id_room=skiathos_rooms.id
WHERE
skiathos_promo_prices.id_promo='5'
ORDER BY price_promo ASC
