Arrivée le 05.03.2015 , Départ le 08.03.2015 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2015-03-05' BETWEEN du AND au) and ('2015-03-08' BETWEEN du AND au)) or (('2015-03-05' BETWEEN du1 AND au1) and ('2015-03-08' BETWEEN du1 AND au1)) or (('2015-03-05' BETWEEN du2 AND au2) and ('2015-03-08' 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,63,316,59,61,64,65,67,319,71,72,77,353,79,89,84,91,92,93,94,97,322,515,98,102,103,105,106,107,108,109,111,114,115,116,331,337,117,118,120,323,121,123,342,343,346,347,125,326,128,130,131,132,133,368,135,140,144,203,223,230,224,172,499,502,176,177,181,190,196,201,369,208,249,252,254,255,212,225,348,349,350,351,282,287,344,294,285,271,270,277,280,311,314,376,273,367,366,365,362,428,516,431,432,433,436,438,453,452,457,458,462,463,466,473,474,495,477,478,479,480,483,484,488,497,489,490,492,494,508,512,510,517,526,527,528,530,529,531,532,533,535,536,537 ) and o.`etat`=0 order by price ASC

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