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('kreuzfahrtschiffe') OR FakeUrl='Kreuzfahrtschiffe-home-B'0:
SELECT * FROM docs WHERE NAME like 'kreuzfahrtschiffe'0:
SELECT * FROM news WHERE TITLE like "kreuzfahrtschiffe" OR URL like "kreuzfahrtschiffe"0:
SELECT DISTINCT CATEGORY as NAME FROM news ORDER BY CATEGORY0:
SELECT cs.PictureUrl as ShipPictureOriginal, cs.ShortPictureUrl as ShipPictureSmall, cs.Content as ShipDescription, cs.AccommodationServiceID as ShipID, cs.Title as ShipName, cs.ItemUrl as ShipFakeUrl, cs.Stars, cso.GlobalId as ReedereiID, cso.Name as ReedereiName, cso.ItemUrl as RFakeUrl FROM cruise_ships cs INNER JOIN cruise_shipowners cso ON cs.ReedereiId = cso.GlobalId AND cso.LanguageID = 'de' WHERE cs.LanguageID = 'de' ORDER BY cs.ItemUrl ASC 0:
select * from config where NAME="NO_LOGO"0:
SELECT * FROM metas WHERE TYPE='default' Übersicht Kreuzfahrtschiffe - B

Übersicht Kreuzfahrtschiffe - B

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.

© Copyright 2006/2012