Angebot
Bitte wählen...
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1433 AND RELEASED=2 ORDER BY ORDERSFinnland
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1521 AND RELEASED=2 ORDER BY ORDERS Nordlichterwoche im Torassieppi Winterdorf
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1479 AND RELEASED=2 ORDER BY ORDERS Stippvisite Finnisch Lappland
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=899 AND RELEASED=2 ORDER BY ORDERS Den Nordlichtern ganz nah an Silvester
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=338 AND RELEASED=2 ORDER BY ORDERS Mit dem Nordlichtclub auf der Jagd in Luosto
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1612 AND RELEASED=2 ORDER BY ORDERS Nordlicht Abenteuer
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1639 AND RELEASED=2 ORDER BY ORDERS Den Nordlichtern ganz nah
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1048 AND RELEASED=2 ORDER BY ORDERSIsland
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1526 AND RELEASED=2 ORDER BY ORDERS Ferienhaus Idylle unter Nordlichtern
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1006 AND RELEASED=2 ORDER BY ORDERS Erlebnis Nordlicht und heiße Quellen
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1290 AND RELEASED=2 ORDER BY ORDERS Island Polarlicht Expedition
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1138 AND RELEASED=2 ORDER BY ORDERSNorwegen
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1531 AND RELEASED=2 ORDER BY ORDERS Polarlicht in Tromsø
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=809 AND RELEASED=2 ORDER BY ORDERS Per Schneeschuh dem Nordlicht entgegen
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1495 AND RELEASED=2 ORDER BY ORDERS Lyngenalpen – ein Nordlichtabenteuer
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1372 AND RELEASED=2 ORDER BY ORDERS Kleingruppenreise Nordlicht & Polarnacht am Eismeer
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1429 AND RELEASED=2 ORDER BY ORDERS Nordlicht und Sterne
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=864 AND RELEASED=2 ORDER BY ORDERS Magie des Nordlichtes
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1447 AND RELEASED=2 ORDER BY ORDERS Nordlichter und Wale in Nordnorwegen
SELECT
(SELECT ID FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ID,
(SELECT NAME FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS NAME,
(SELECT ARTICLE FROM gla_index WHERE ID=IF( LENGTH((SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID)) IS NULL,gi.ID,(SELECT index_rev_content FROM gla_index_dc WHERE index_id=gi.ID))) AS ARTICLE
FROM gla_index AS gi
WHERE PARENT=1652 AND RELEASED=2 ORDER BY ORDERS