0:
0:
SELECT ModuleID FROM modules WHERE Name='cruise_routes'0:
SELECT cr.Title as Name, cr.Duration as Duration, SUBSTRING(cr.AccommodationServiceID,6) as RouteID, cr.Content as tmpDescription, cs.ShortPictureUrl as Picture, cs.PictureUrl, cr.ItemUrl as FAKE, SUBSTRING(cs.AccommodationServiceID,5) as ShipID, cs.ItemUrl as SFakeUrl, cs.Title as ShipName, cso.ItemUrl as RFakeUrl, cso.GlobalId as ReedereiID, cso.Name as ReedereiName, SUBSTRING(cd.AccommodationServiceID,5) as DestinationID, cd.Title as DestinationName, cd.ItemUrl as DFakeUrl FROM cruise_routes cr INNER JOIN cruise_ships cs ON cr.ShipId = cs.AccommodationServiceID INNER JOIN cruise_shipowners cso ON cs.ReedereiId = cso.GlobalId AND cso.LanguageID = 'de' INNER JOIN cruise_destinations cd ON cr.DestinationId = cd.AccommodationServiceID WHERE cr.IsSpecial = 10:
SELECT DISTINCT CATEGORY as NAME FROM news ORDER BY CATEGORY0:
SELECT * FROM articles WHERE VISIBLE=1 ORDER BY PRIORITY0:
SELECT DISTINCT CATEGORY as NAME FROM news ORDER BY CATEGORY0:
SELECT * FROM banners WHERE CATEGORY='Default' AND VISIBLE=1 ORDER BY RAND() LIMIT 10:
SELECT * FROM links WHERE lower(TITLE) like lower('nord%ostsee%kanal%154%dst%1') OR FakeUrl='nord-ostsee-kanal' AND ACTION='search' AND ID='154'0:
SELECT * FROM docs WHERE NAME like 'nord%ostsee%kanal%154%dst%1'0:
SELECT * FROM news WHERE TITLE like "nord%ostsee%kanal%154%dst%1" OR URL like "nord%ostsee%kanal%154%dst%1"0:
SELECT DISTINCT CATEGORY as NAME FROM news ORDER BY CATEGORY0:
select * from config where NAME="NO_LOGO"0:
SELECT ParentId FROM cruise_destinations WHERE LanguageID = 'de' AND CatalogID > 0 AND AccommodationServiceID = 'DEST154'0:
SELECT COUNT(DISTINCT cr.AccommodationServiceID) as Cnt FROM cruise_routes cr INNER JOIN cruise_route_destination crd ON crd.LanguageID = 'de' AND crd.RouteId = cr.AccommodationServiceID INNER JOIN cruise_destinations cd ON cd.LanguageID = 'de' AND crd.DestinationId=cd.AccommodationServiceID AND cd.ExternalID LIKE ('DEST154%') INNER JOIN cruise_ships cs ON cs.LanguageID = 'de' AND cr.ShipId = cs.AccommodationServiceID INNER JOIN cruise_shipowners cso ON cso.LanguageID = 'de' AND cr.ReedereiId = cso.GlobalId WHERE cr.LanguageID = 'de' 0:
SELECT Title, Content, PageTitle, Keywords, Description, Noindex FROM cruise_destinations WHERE AccommodationServiceID = 'DEST154'0:
select * from config where NAME="NO_LOGO"0:
SELECT ParentId FROM cruise_destinations WHERE LanguageID = 'de' AND CatalogID > 0 AND AccommodationServiceID = 'DEST154'0:
SELECT COUNT(DISTINCT cr.AccommodationServiceID) as Cnt FROM cruise_routes cr INNER JOIN cruise_route_destination crd ON crd.LanguageID = 'de' AND crd.RouteId = cr.AccommodationServiceID INNER JOIN cruise_destinations cd ON cd.LanguageID = 'de' AND crd.DestinationId=cd.AccommodationServiceID AND cd.ExternalID LIKE ('DEST154%') INNER JOIN cruise_ships cs ON cs.LanguageID = 'de' AND cr.ShipId = cs.AccommodationServiceID INNER JOIN cruise_shipowners cso ON cso.LanguageID = 'de' AND cr.ReedereiId = cso.GlobalId WHERE cr.LanguageID = 'de' 0:
SELECT Title, Content, PageTitle, Keywords, Description, Noindex FROM cruise_destinations WHERE AccommodationServiceID = 'DEST154'0:
SELECT * FROM metas WHERE TYPE='default'
Es wurden keine Kreuzfahrten gefunden ...
Suche
Search:

Newsletter
Name:  

E-Mail:

  
Hotline

Noch Fragen zur Kreuzfahrt?

Kreuzfahrt Hotline:
+49 69 20456-830

Die Kreuzfahrtspezialisten von e-hoi helfen Ihnen gerne weiter!

Kontaktanfragen

Möchten Sie in Kontakt treten mit dem Team von Kreuzfahrten-pool.de?

Ihren Ansprechpartner finden Sie unter Kontaktanfragen.

Australien Tipps

Mehr Infos zu Australien:
Der Downunder-Dago beschreibt Australien in vielen Facetten.
Monkey Mia ist einer der wenigen Plätze auf der Welt, an denen man mit den Delphinen schwimmen kann ...

Hotline

Noch Fragen zur Kreuzfahrt?

Kreuzfahrt Hotline:
+49 69 20456-830

Die Kreuzfahrtspezialisten von e-hoi helfen Ihnen gerne weiter!

© Copyright 2006/2012