Arrivée le 22.08.2018 , Départ le 25.08.2018 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2018-08-22' BETWEEN du AND au) and ('2018-08-25' BETWEEN du AND au)) or (('2018-08-22' BETWEEN du1 AND au1) and ('2018-08-25' BETWEEN du1 AND au1)) or (('2018-08-22' BETWEEN du2 AND au2) and ('2018-08-25' 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,319,71,72,77,78,353,79,91,92,97,322,102,103,109,110,116,331,120,323,121,123,340,341,343,346,125,325,326,128,131,132,133,134,368,136,140,144,301,223,230,231,224,499,502,173,175,430,177,181,201,369,208,249,254,255,225,350,351,282,290,334,294,271,270,277,280,379,376,374,373,372,371,367,366,370,362,428,432,433,435,436,438,459,462,551,463,466,467,468,576,473,479,480,483,484,486,505,508,512,518,521,527,528,541,543,542,556,547,548,549,553,566,568,571,570,573,575,586,584,593,574,577,582,583,585,587,591,594,596,597,599,600 ) and o.`etat`=0 and o.`id_ville`='80' order by price ASC

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