Arrivée le 03.10.2016 , Départ le 06.10.2016 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2016-10-03' BETWEEN du AND au) and ('2016-10-06' BETWEEN du AND au)) or (('2016-10-03' BETWEEN du1 AND au1) and ('2016-10-06' BETWEEN du1 AND au1)) or (('2016-10-03' BETWEEN du2 AND au2) and ('2016-10-06' 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,52,62,63,316,59,61,64,65,357,70,319,71,72,77,353,79,91,92,93,94,97,321,322,98,102,103,105,106,107,108,109,110,114,115,335,337,117,118,120,323,121,123,340,341,342,343,346,347,125,324,325,326,128,130,131,132,133,368,136,144,203,301,223,230,224,499,176,177,181,185,193,196,201,369,204,208,249,252,254,255,333,212,225,348,350,351,282,290,294,285,271,270,277,280,311,314,376,374,365,414,428,516,431,432,457,458,462,551,463,466,467,473,474,495,478,479,480,483,484,489,490,491,492,494,508,512,510,517,523,526,527,528,529,539,541,543,540,542,556,544,552,545,546,547,548,550,549,553 ) and o.`etat`=0 order by price ASC

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