mtravel.be

C. Marichalstraat, 2
8730 Beernem

Tel. +32 50 78 28 00

Fax +32 50 78 27 00

info@mtravel.be

Lic. A 5973

Tips and Trics

Abonneer u op de nieuwsbrief.
Click hier

Find us on Facebook

SELECT DISTINCT `avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations`.`idHolidea` as value,`avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations`.`title`as text FROM `avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations` INNER JOIN `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas` ON `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`destination`=`avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations`.`idHolidea` WHERE `avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations`.`lang`='nl-NL' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`idagency` = '94' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`visible` = '1' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`lang` = 'nl-NL' ORDER BY `avitour_travelprmaster`.`ROBAIRavintranet_booking_destinations`.`title` ASC SELECT DISTINCT `avitour_travelprmaster`.`ROBAIRavintranet_booking_categories`.`idHolidea` as value,`avitour_travelprmaster`.`ROBAIRavintranet_booking_categories`.`title`as text FROM `avitour_travelprmaster`.`ROBAIRavintranet_booking_categories` INNER JOIN `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas` ON `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`category`=`avitour_travelprmaster`.`ROBAIRavintranet_booking_categories`.`idHolidea` WHERE `avitour_travelprmaster`.`ROBAIRavintranet_booking_categories`.`lang`='nl-NL' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`idagency` = '94' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`visible` = '1' AND `avitour_travelprmaster`.`ROBAIRavintranet_booking_datas`.`lang` = 'nl-NL' ORDER BY `avitour_travelprmaster`.`ROBAIRavintranet_booking_categories`.`title` ASC

Ons aanbod

Min. Prijs
  
Max. Prijs
  

COM_AVIFLUX_NOTRAVEL_IN_THESE_CATEGORY

C. Marichalstraat, 2
8730 Beernem

Tel. +32 50 78 28 00

Fax +32 50 78 27 00

info@mtravel.be

Lic. A 5973

Tips and Trics

Abonneer u op de nieuwsbrief.
Click hier

Find us on Facebook