Arrivée le 02.07.2017 , Départ le 05.07.2017 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2017-07-02' BETWEEN du AND au) and ('2017-07-05' BETWEEN du AND au)) or (('2017-07-02' BETWEEN du1 AND au1) and ('2017-07-05' BETWEEN du1 AND au1)) or (('2017-07-02' BETWEEN du2 AND au2) and ('2017-07-05' 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,46,52,62,63,316,59,61,64,65,67,357,319,71,72,77,353,79,89,84,91,92,93,94,97,321,322,102,103,105,106,107,108,109,110,111,114,116,331,335,117,118,120,121,123,340,341,342,343,346,347,125,324,325,326,127,128,131,327,132,133,134,135,136,144,203,301,223,230,224,499,173,177,193,196,201,369,204,208,249,252,254,255,212,225,350,351,282,290,334,294,285,271,270,277,280,311,314,379,376,374,373,367,366,365,362,428,516,431,432,433,436,438,453,452,455,457,458,462,551,463,466,467,473,474,495,478,479,480,483,484,486,487,497,500,492,494,505,508,512,517,520,521,527,528,541,543,540,554,542,569,560,556,544,552,547,548,561,565,549,553,564,559,562,566,567,568,571,570,572 ) and o.`etat`=0 and o.`id_ville`='80' order by price ASC

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