La Culture Corse
Histoire
La culture
Spécialités régionales
La nature

 

Séjour en Corse
Hôtels et location
Camping
Restaurants
Office de tourisme
Transports sur l'île
Produits Corses
Manifestations

 

Activités en Corse
Activité nature
Nautisme
Loisirs et bien être
Les plages de rêves

 

Informations pratiques
Partir de Nice
Périodes Propices
En cas d'urgence
Météo
SELECT IF(t.tarif_int=0, IF(t.tarif_ext=0, IF(t.tarif_ext_bal=0,t.tarif_suite,t.tarif_ext_bal),t.tarif_ext), t.tarif_int) tarif, c.id, #(SELECT GROUP_CONCAT(v.nom SEPARATOR ', ') FROM croisiere_itineraire i LEFT JOIN ville v ON v.id=i.id_ville WHERE i.id_croisiere=c.id ORDER BY i.id_croisiere ASC,jour ASC,heure_depart ASC) iti, (SELECT GROUP_CONCAT(v.nom ORDER BY i.jour ASC SEPARATOR ', ') FROM croisiere_itineraire i LEFT JOIN ville v ON v.id=i.id_ville WHERE i.id_croisiere=c.id ORDER BY i.id_croisiere ASC,jour ASC,heure_depart ASC) iti, (SELECT GROUP_CONCAT(CAST(date_depart as CHAR) ORDER BY date_depart SEPARATOR ',') FROM croisiere_tarif t WHERE t.id_croisiere=c.id ORDER BY date_depart ASC) datedep, (SELECT MIN(LEAST(IF(tarif_int=0,1000000,tarif_int), IF(tarif_ext=0,1000000,tarif_ext), IF(tarif_ext_bal=0,1000000,tarif_ext_bal), IF(tarif_suite=0,1000000,tarif_suite))) FROM croisiere_tarif t WHERE id=(SELECT id FROM croisiere_tarif t WHERE id_croisiere=c.id AND date_depart>'2010-03-12' ORDER BY LEAST(IF(tarif_int=0,1000000,tarif_int), IF(tarif_ext=0,1000000,tarif_ext), IF(tarif_ext_bal=0,1000000,tarif_ext_bal), IF(tarif_suite=0,1000000,tarif_suite)) LIMIT 1)) bestPrice, (SELECT tarif_brochure FROM croisiere_tarif t WHERE id=(SELECT id FROM croisiere_tarif t WHERE id_croisiere=c.id AND date_depart>'2010-03-12' ORDER BY LEAST(IF(tarif_int=0,1000000,tarif_int), IF(tarif_ext=0,1000000,tarif_ext), IF(tarif_ext_bal=0,1000000,tarif_ext_bal), IF(tarif_suite=0,1000000,tarif_suite)) LIMIT 1)) priceBrochure, /* (SELECT cabine_promo FROM croisiere_tarif t WHERE id=(SELECT id FROM croisiere_tarif t WHERE id_croisiere=c.id AND date_depart>'2010-03-12' ORDER BY LEAST(IF(tarif_int=0,1000000,tarif_int), IF(tarif_ext=0,1000000,tarif_ext), IF(tarif_ext_bal=0,1000000,tarif_ext_bal), IF(tarif_suite=0,1000000,tarif_suite)) LIMIT 1)) promo,*/ c.id idcruise, vol_inclus,transfert_inclus,croisiere_luxe,enfant_gratuit,duree_text,nom_tarif_int,nom_tarif_ext,nom_tarif_ext_bal,nom_tarif_suite,b.id id_bateau,b.nom nom_bateau,b.etoile etoile,a.id id_armateur,a.nom nom_armateur,a.url_petit_logo url_logo,a.description_petite description_logo,z.id id_zone, z.nom nomdestination, c.nom,wb.photo_bateau photo,wb.armateur wb_armateur,wb.nom wb_nom,z.description_petite description_photo FROM croisiere c JOIN bateau b ON b.id=c.id_bateau JOIN web_bateau wb ON wb.id=b.id JOIN armateur a ON a.id=b.id_armateur AND a.visible=1 JOIN zone_croisiere z ON z.id=c.id_zone_croisiere AND z.id != '' JOIN croisiere_tarif t ON t.id_croisiere=c.id AND t.date_depart>'2010-03-12' JOIN croisiere_itineraire ci ON ci.id_croisiere=c.id JOIN ville v ON v.id=ci.id_ville AND v.id IN (182,269,339,523,527,531,750) GROUP BY c.id ORDER BY CAST(bestPrice as UNSIGNED) ASC,t.date_depart ASC SQL error number: SQL error: