jupotours.be

Nieuwstraat, 15
3300 Tienen

Tel. +32 16 81 44 74

Fax /

jupo@scarlet.be

Lic. A 1735

Tips & Trics

Abonneer u op de nieuwsbrief.
Click hier

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` = '72' 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` = '72' 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

Nieuwstraat, 15
3300 Tienen

Tel. +32 16 81 44 74

Fax /

jupo@scarlet.be

Lic. A 1735

Tips & Trics

Abonneer u op de nieuwsbrief.
Click hier