Warning: pg_query() [function.pg-query]: Query failed: ERREUR: Entrée manquante de la clause FROM dans la sous-requête de la table « residence_diffuse » at character 693 in /home/www/wwwroot/_commun/classes/connect.class.php on line 85
SQL error : SELECT tbl.* FROM ( SELECT DISTINCT ON(dn_tarifs.residence_id ) dn_tarifs.residence_id, dn_tarifs.pax, min(min_prix) as min_prix,MAX(dispo) AS tarif_dispo, dn_tarifs.prix AS tarif_prix, dn_tarifs.nuite_id, CASE WHEN (COALESCE(dn_tarifs.date_promo, 0) > 0) THEN dn_tarifs.date_promo ELSE CASE WHEN (COALESCE(dn_tarifs.tarif_prix_promo, 0) > 0) THEN ceil((dn_tarifs.tarif_prix_promo*100)/dn_tarifs.prix) END END AS date_promo, tarif_prix_promo, date_d,date_f, contrainte_id, AVG(residence_score_theme.score) as score FROM _dn.dn_tarifs INNER JOIN _dn.diffuse USING (residence_id) INNER JOIN web.residence_score_theme ON (residence_score_theme.residence_id = residence_diffuse.residence_id) WHERE vendeur_id=23 AND etat=1 AND dispo > 0 AND date_promo > 0 AND date_d >= '01/03/2010' AND date_d < '01/04/2010' AND (num = '74' OR num = '38' OR num = '73' OR region_id = 5 OR region_id = 103 OR region_id = 104 OR num = '04' OR num = '05' OR num = '01' OR num = '69' OR num = '07' OR num = '06' OR num = '42' OR pays_id = '41') AND type IN (3, 6, 2, 7, 4, 1, 5, 10, 8) AND dn_tarifs.date_d > CURRENT_DATE + 2 GROUP BY dn_tarifs.residence_id , dn_tarifs.pax, min_prix, date_promo, prix, tarif_prix_promo, date_d, date_f, contrainte_id, dn_tarifs.nuite_id,dispo ORDER BY dn_tarifs.residence_id ,min_prix ) AS tbl ORDER BY tbl.score DESC LIMIT 6 OFFSET 0;