Arrivée le 21.10.2018 , Départ le 24.10.2018 (3 nuitées)

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

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