 |
 |
|||||
|
| ||||||||||
|
||||||||||
| ||||||||||
|
||||||||||
| ||||||||||
|
||||||||||
| ||||||||||
|
||||||||||
|
|||||||||||||||||||||||||||||||||||||||||
|
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-07-29' 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-07-29' 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-07-29' 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-07-29' 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: 1045 SQL error: Access denied for user '100x100corse'@'mail.volaincrociera.com' (using password: YES) | ||||||||||||||||||||||||||||||||||||||||
