Arrivée le 29.05.2018 , Départ le 01.06.2018 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2018-05-29' BETWEEN du AND au) and ('2018-06-01' BETWEEN du AND au)) or (('2018-05-29' BETWEEN du1 AND au1) and ('2018-06-01' BETWEEN du1 AND au1)) or (('2018-05-29' BETWEEN du2 AND au2) and ('2018-06-01' 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,103,110,116,331,120,323,121,123,340,341,342,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,282,334,294,285,271,270,277,280,376,374,373,372,371,367,366,365,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,581,582,583,585,587,594 ) and o.`etat`=0 and o.`id_ville`='80' order by price ASC

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