or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

Sign up to our newsletter and become the first to know about our latest deals and promotions

Itinerary for Cruise Panorama, Active Discovery on the Danube ex Linz to Budapest

Cruise Itinerary

Day Port Arrive Depart
Day 1 Linz, Austria Embark
Day 2 Engelhartszell, Austria
Day 2 Linz, Austria
Day 3 Grein, Austria
Day 4 Spitz, Austria
Day 4 Vienna, Austria
Day 5 Vienna, Austria
Day 6 Vienna, Austria
Day 7 Visegrad, Hungary
Day 7 Budapest, Hungary
Day 8 Budapest, Hungary Disembark Hotel
Day 9 Budapest, Hungary

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 172

Total elapsed time: 0.099907159805298

# Query Time
(1) connect 0.0006260871887207
(2) DESCRIBE `specials` 0.0032749176025391
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'active-discovery-on-the-danube-2-400-air-credit-per-couple') AND (orchid_available = 1) LIMIT 1 0.0014758110046387
(4) DESCRIBE `cruises` 0.0015780925750732
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74790))) 0.00036001205444336
(6) DESCRIBE `avid_specials` 0.00066709518432617
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1442170 and class = 'Special') OR (item_id = 74790 and class = 'Cruise') OR (item_id = 888 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094914436340332
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1442170') 0.0001978874206543
(9) DESCRIBE `ships` 0.0013699531555176
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 888))) 0.00024914741516113
(11) DESCRIBE `ships` 0.0012710094451904
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.0001978874206543
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(15) DESCRIBE `itineraries` 0.00066494941711426
(16) DESCRIBE `ports` 0.00094389915466309
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00023388862609863
(18) DESCRIBE `ports` 0.00066494941711426
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0001978874206543
(20) DESCRIBE `ports` 0.00080108642578125
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019502639770508
(22) DESCRIBE `specialsailingdates` 0.00063705444335938
(23) DESCRIBE `sailingdates` 0.000762939453125
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 472038))) 0.00026893615722656
(25) DESCRIBE `ports` 0.00075697898864746
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0004420280456543
(27) DESCRIBE `ports` 0.0010979175567627
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.0002598762512207
(29) DESCRIBE `ports` 0.00072598457336426
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00024890899658203
(31) DESCRIBE `ports` 0.00068402290344238
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00019407272338867
(33) DESCRIBE `ports` 0.0007472038269043
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00020718574523926
(35) DESCRIBE `ports` 0.00066804885864258
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00018405914306641
(37) DESCRIBE `ports` 0.00066399574279785
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00022697448730469
(39) DESCRIBE `ports` 0.00070309638977051
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00018501281738281
(41) DESCRIBE `ports` 0.00066590309143066
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00022411346435547
(43) DESCRIBE `ports` 0.00067806243896484
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00019502639770508
(45) DESCRIBE `ports` 0.00073003768920898
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021004676818848
(47) DESCRIBE `ports` 0.00068306922912598
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00019693374633789
(49) DESCRIBE `ports` 0.00083398818969727
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00022196769714355
(51) DESCRIBE `ports` 0.00070810317993164
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00019216537475586
(53) DESCRIBE `ports` 0.00070595741271973
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020503997802734
(55) DESCRIBE `ports` 0.00075507164001465
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018906593322754
(57) DESCRIBE `ports` 0.00065994262695312
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.00028395652770996
(59) DESCRIBE `ports` 0.00074315071105957
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4277') 0.00021505355834961
(61) DESCRIBE `ports` 0.00099587440490723
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00027012825012207
(63) DESCRIBE `ports` 0.00069403648376465
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018501281738281
(65) DESCRIBE `ports` 0.00069403648376465
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019502639770508
(67) DESCRIBE `ports` 0.00067996978759766
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018596649169922
(69) DESCRIBE `ports` 0.00072288513183594
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00022506713867188
(71) DESCRIBE `ports` 0.00083088874816895
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017714500427246
(73) DESCRIBE `specialsmultipricing` 0.00064992904663086
(74) DESCRIBE `leadpricing` 0.00067782402038574
(75) DESCRIBE `specials` 0.0018219947814941
(76) DESCRIBE `currencies` 0.00061988830566406
(77) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00021600723266602
(78) DESCRIBE `cruiselines` 0.0010271072387695
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.0002439022064209
(80) DESCRIBE `orchid_image` 0.00076007843017578
(81) DESCRIBE `cruiselines` 0.00093603134155273
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00021100044250488
(83) DESCRIBE `cruises` 0.00124192237854
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74790') 0.00025105476379395
(85) DESCRIBE `deckplans` 0.00068807601928711
(86) DESCRIBE `cabins` 0.00080490112304688
(87) DESCRIBE `shipphotos` 0.00077986717224121
(88) DESCRIBE `specialitineraries` 0.00084805488586426
(89) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'pre' AND special_id = '1442170') ORDER BY `order` ASC 0.00035500526428223
(90) DESCRIBE `ports` 0.00081396102905273
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00025606155395508
(92) DESCRIBE `ports` 0.00081896781921387
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00023603439331055
(94) DESCRIBE `ports` 0.00088310241699219
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00028705596923828
(96) DESCRIBE `ports` 0.0010340213775635
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00031900405883789
(98) DESCRIBE `ports` 0.0010111331939697
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00023508071899414
(100) DESCRIBE `ports` 0.00078892707824707
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00023794174194336
(102) DESCRIBE `ports` 0.00083303451538086
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00022602081298828
(104) DESCRIBE `ports` 0.00079488754272461
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00023889541625977
(106) DESCRIBE `ports` 0.00078296661376953
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00020885467529297
(108) DESCRIBE `ports` 0.00067996978759766
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00022292137145996
(110) DESCRIBE `ports` 0.00066590309143066
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00018501281738281
(112) DESCRIBE `ports` 0.00069689750671387
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00019693374633789
(114) DESCRIBE `ports` 0.00081300735473633
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00020098686218262
(116) DESCRIBE `ports` 0.00066590309143066
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00018191337585449
(118) DESCRIBE `ports` 0.00066399574279785
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00019311904907227
(120) DESCRIBE `ports` 0.00066709518432617
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00023508071899414
(122) DESCRIBE `ports` 0.00074505805969238
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018310546875
(124) DESCRIBE `ports` 0.00066804885864258
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019598007202148
(126) DESCRIBE `ports` 0.00066995620727539
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019693374633789
(128) DESCRIBE `ports` 0.00069117546081543
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018501281738281
(130) DESCRIBE `ports` 0.00066900253295898
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020599365234375
(132) DESCRIBE `ports` 0.00066494941711426
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019717216491699
(134) DESCRIBE `ports` 0.00066900253295898
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018405914306641
(136) DESCRIBE `ports` 0.00073885917663574
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020408630371094
(138) DESCRIBE `ports` 0.00066399574279785
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.0001978874206543
(140) DESCRIBE `ports` 0.00067019462585449
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4277') 0.00018596649169922
(142) DESCRIBE `ports` 0.00066709518432617
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.00020503997802734
(144) DESCRIBE `ports` 0.00066614151000977
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020098686218262
(146) DESCRIBE `ports` 0.00066494941711426
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018501281738281
(148) DESCRIBE `ports` 0.00066494941711426
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020503997802734
(150) DESCRIBE `ports` 0.00069189071655273
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019693374633789
(152) DESCRIBE `ports` 0.00070595741271973
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018692016601562
(154) DESCRIBE `ports` 0.0006721019744873
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020813941955566
(156) DESCRIBE `ports` 0.00072216987609863
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020098686218262
(158) DESCRIBE `ports` 0.00067305564880371
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018906593322754
(160) DESCRIBE `ports` 0.00066804885864258
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00023698806762695
(162) DESCRIBE `specialitineraries` 0.00074315071105957
(163) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'post' AND special_id = '1442170') ORDER BY `order` ASC 0.00028896331787109
(164) DESCRIBE `cruises` 0.0018808841705322
(165) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 45259, 69465, 66859, 66414, 67892, 69524, 66478, 66529)) ORDER BY FIND_IN_SET(id, '66959,11517,45259,69465,66859,66414,67892,69524,66478,66529') 0.00091814994812012
(166) DESCRIBE `cruiselines` 0.0013298988342285
(167) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '33', '101', '19', '18', '8', '15', '218', '23', '151', '114', '20', '24', '120', '212', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '47,33,101,19,18,8,15,218,23,151,114,20,24,120,212,30,180,262') 0.00079011917114258
(168) DESCRIBE `ships` 0.0014557838439941
(169) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '1139', '888', '1266', '78', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1163', '5', '74', '98', '150', '163', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1159', '1262', '1302', '1492', '1539', '1587', '1673', '1674')) ORDER BY FIND_IN_SET(id, '517,160,1359,1139,888,1266,78,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1163,5,74,98,150,163,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1159,1262,1302,1492,1539,1587,1673,1674') 0.0025260448455811
(170) DESCRIBE `cruisetypes` 0.00097012519836426
(171) DESCRIBE `destinations` 0.00099277496337891
(172) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '50', '35', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '21', '25', '37', '40', '8', '38', '53')) ORDER BY FIND_IN_SET(id, '22,43,50,35,54,48,11,29,12,26,28,39,49,2,21,25,37,40,8,38,53') 0.00093317031860352