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'
Noch Fragen zur Kreuzfahrt?
Kreuzfahrt Hotline:
+49 69 20456-830
Die Kreuzfahrtspezialisten von e-hoi helfen Ihnen gerne weiter!
Möchten Sie in Kontakt treten mit dem Team von Kreuzfahrten-pool.de?
Ihren Ansprechpartner finden Sie unter Kontaktanfragen.
© Copyright 2006/2012