Winter

Winterurlaub in Skandinavien!

Was ist heutzutage schon sicher? Sonnenklar, der Schnee in den skandinavischen Skigebieten (blendet richtig, kein Verschnitt)! Wir haben viele neue Winter-Reiseziele in sauberem, erstklassigem Schnee, mit traumhaften Hütten oder Hotels, endlosen Loipen und spektakulären Abfahrten ins Programm genommen. Natürlich werden Sie süchtig, wenn Sie erst einmal eines dieser Winter-Urlaubs-Erlebnisse genossen haben.

Rentiere, Hundeschlitten, Winter-Walsafari, dem Nordlicht auf der Spur – als Kurztrip und Stippvisite, Gruppen- oder Individualreise, mit Flug oder Fähre – alles und mehr zum Thema Winterurlaub finden Sie hier bei Ihrem Skandinavischen Reisebüro. Übrigens: auch die Preise für unser Winterferien-Angebot sind ein Hingucker und müssen sich im Vergleich nicht verstecken.

Quicklink

Über die folgenden Quicklinks springen Sie direkt zu den passenden Angeboten!


    SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=11 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=336 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Finnland > Nordlicht
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1179 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1612 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1705 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1706 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1707 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1708 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1709 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1479 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1048 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Finnland > Schneeabenteuer
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=939 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1611 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=800 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1002 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=801 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1003 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Finnland > Weihnachten/Silvester
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=941 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=338 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Schweden
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=583 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1645 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1487 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1496 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=874 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Island
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=942 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Island > Busrundreisen
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1269 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1651 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1480 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1290 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1138 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Island > Mietwagenrundreisen
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1270 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1283 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1006 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1327 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=618 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1660 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1010 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Estland
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1648 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1647 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Norwegen
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=582 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Norwegen > Nordlicht
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=935 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=809 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1652 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1067 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1370 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1372 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
  • Norwegen > Skiurlaub
    • SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=933 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1494 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1381 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=684 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=435 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1643 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC

Beliebte Angebote

Finnland > Nordlicht

Finnland > Schneeabenteuer

Finnland > Weihnachten/Silvester

Schweden

Island

Island > Busrundreisen

Island > Mietwagenrundreisen

Estland

Norwegen

Norwegen > Nordlicht

Norwegen > Skiurlaub

Newsletter

Mit unserem kostenlosen Newsletter verpassen Sie zukünftig keine Sparpreis oder Sonderangebote mehr. Die Hinweise zum Datenschutz habe ich gelesen.

Cookies erleichtern die Bereitstellung unserer Dienste. Mit der Nutzung unserer Dienste erklärst du dich damit einverstanden, dass wir Cookies verwenden Mehr Infos