Arrivée le 24.04.2014 , Départ le 27.04.2014 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2014-04-24' BETWEEN du AND au) and ('2014-04-27' BETWEEN du AND au)) or (('2014-04-24' BETWEEN du1 AND au1) and ('2014-04-27' BETWEEN du1 AND au1)) or (('2014-04-24' BETWEEN du2 AND au2) and ('2014-04-27' BETWEEN du2 AND au2))) and o.id_offre = id_offre ) as price FROM `offre` o , `ville` v where o.id_ville = v.id_ville and nom <>'' and o.id_offre in (0,472,46,48,49,52,62,63,316,61,64,65,67,357,70,319,71,72,77,353,79,89,84,91,92,93,94,97,321,322,515,98,102,103,105,106,107,108,109,110,114,115,331,335,336,337,339,117,118,120,121,123,341,342,343,346,347,125,326,128,130,131,132,133,368,135,136,140,144,203,301,223,230,224,172,498,499,501,511,430,176,177,179,181,190,193,196,197,201,369,204,208,249,252,254,255,333,212,225,348,349,350,351,282,290,294,285,271,270,277,280,311,314,376,273,374,371,367,366,365,362,361,405,428,475,516,513,431,432,433,434,435,436,453,457,458,463,466,470,473,474,495,476,477,478,479,480,483,484,485,486,487,488,497,500,489,490,491,492,494,504,505,509,508,512,510,514 ) and o.`etat`=0 order by price ASC

Trier par Nom Catégorie du - au + Catégorie du + au -