SELECT distinct( travelistica.mt_program.id) as program_id,
travelistica.mt_program.type_id, travelistica.mt_program_cache_prices.L_price as price,travelistica.mt_program.supplier_id as supplier_id FROM
travelistica.mt_program, travelistica.mt_program_cache_prices
WHERE travelistica.mt_program.id in (6844,6911,6901,6891,6828) and travelistica.mt_program.language_code='en' and
travelistica.mt_program.id=travelistica.mt_program_cache_prices.program_id group by travelistica.mt_program.id ORDER BY travelistica.mt_program_cache_prices.L_price asc LIMIT 0, 8Array
(
[0] => Array
(
[program_id] => 6828
[type_id] => 2
[price] => 353.00
[supplier_id] => 723
)
[1] => Array
(
[program_id] => 6911
[type_id] => 2
[price] => 375.00
[supplier_id] => 723
)
[2] => Array
(
[program_id] => 6901
[type_id] => 2
[price] => 457.00
[supplier_id] => 723
)
[3] => Array
(
[program_id] => 6844
[type_id] => 2
[price] => 477.00
[supplier_id] => 723
)
[4] => Array
(
[program_id] => 6891
[type_id] => 2
[price] => 765.00
[supplier_id] => 723
)
)
SELECT distinct( travelistica.mt_program.id) as program_id,
travelistica.mt_program.type_id, travelistica.mt_program_cache_prices.L_price as price,travelistica.mt_program.supplier_id as supplier_id FROM
travelistica.mt_program, travelistica.mt_program_cache_prices
WHERE travelistica.mt_program.id in (6841,6707,6903,6875,6899) and travelistica.mt_program.language_code='en' and
travelistica.mt_program.id=travelistica.mt_program_cache_prices.program_id group by travelistica.mt_program.id ORDER BY travelistica.mt_program_cache_prices.L_price asc LIMIT 0, 8Array
(
[0] => Array
(
[program_id] => 6903
[type_id] => 2
[price] => 606.00
[supplier_id] => 723
)
[1] => Array
(
[program_id] => 6841
[type_id] => 2
[price] => 782.00
[supplier_id] => 723
)
[2] => Array
(
[program_id] => 6875
[type_id] => 2
[price] => 1009.00
[supplier_id] => 723
)
[3] => Array
(
[program_id] => 6899
[type_id] => 2
[price] => 1080.00
[supplier_id] => 723
)
[4] => Array
(
[program_id] => 6707
[type_id] => 2
[price] => 1184.00
[supplier_id] => 723
)
)
SELECT distinct( travelistica.mt_program.id) as program_id,
travelistica.mt_program.type_id, travelistica.mt_program_cache_prices.L_price as price,travelistica.mt_program.supplier_id as supplier_id FROM
travelistica.mt_program, travelistica.mt_program_cache_prices
WHERE travelistica.mt_program.id in (6907,6717,6932,6934,6910,6710,6745) and travelistica.mt_program.language_code='en' and
travelistica.mt_program.id=travelistica.mt_program_cache_prices.program_id group by travelistica.mt_program.id ORDER BY travelistica.mt_program_cache_prices.L_price asc LIMIT 0, 8Array
(
[0] => Array
(
[program_id] => 6907
[type_id] => 2
[price] => 584.00
[supplier_id] => 723
)
[1] => Array
(
[program_id] => 6910
[type_id] => 2
[price] => 689.00
[supplier_id] => 723
)
[2] => Array
(
[program_id] => 6934
[type_id] => 2
[price] => 955.00
[supplier_id] => 723
)
[3] => Array
(
[program_id] => 6717
[type_id] => 2
[price] => 1030.00
[supplier_id] => 723
)
[4] => Array
(
[program_id] => 6932
[type_id] => 2
[price] => 1337.00
[supplier_id] => 723
)
[5] => Array
(
[program_id] => 6710
[type_id] => 2
[price] => 1708.00
[supplier_id] => 723
)
[6] => Array
(
[program_id] => 6745
[type_id] => 2
[price] => 1899.00
[supplier_id] => 723
)
)
travelistica.ae.com: Travel offers, travel sales, travel opportunities, travel discounts, beaches travel offers, safari | travelistica.ae
Best Collection
More than 200,000 hotels, resorts apartments and hotels.
It Fits You
All Lodging Types and dfferent payment methods
Best Attention
We respond to your questions and requests with agility and speed
Best Price
Our discounts can reach up to 70% over the hotel price.
We guarantee the best price in vacational packages
We guarantee the best price in vacational packages
We guarantee the best price in vacational packages
Great Trips
Featured
Europe Tours
Embark on a journey through the enchanting corridors of Europe, where culture intertwines with art and history in a captivating dance. Explore the romantic streets of Paris, savor the flavors of Italian cuisine in Rome, and marvel at the lights of the Eiffel Tower on an unforgettable night in the City of Light. Make your trip an adventure to remember in Europe, where beauty meets civilization with unparalleled elegance. Join us to explore charming places and create everlasting memories. Letus Go?
Receive our newsletter with the best offers!