Arrivée le 17.10.2019 , Départ le 20.10.2019 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2019-10-17' BETWEEN du AND au) and ('2019-10-20' BETWEEN du AND au)) or (('2019-10-17' BETWEEN du1 AND au1) and ('2019-10-20' BETWEEN du1 AND au1)) or (('2019-10-17' BETWEEN du2 AND au2) and ('2019-10-20' 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,63,316,59,61,64,65,67,319,72,77,353,79,84,94,97,321,322,102,103,105,106,107,108,110,111,114,115,116,331,337,117,323,121,123,340,341,342,343,347,125,326,127,128,134,368,135,136,144,301,224,499,173,430,176,177,181,185,193,196,201,249,254,255,333,212,225,348,282,290,294,285,271,270,280,311,314,376,374,373,372,371,365,428,516,431,437,435,436,438,453,455,457,458,459,462,551,463,466,467,468,576,473,476,483,484,486,500,492,509,508,512,510,517,520,521,527,531,543,540,554,542,556,552,545,548,550,553,564,566,570,572,612,577,580,581,582,583,585,587,594,597,598,600,601,605,606,607,608,609,610,611,613,614,615,617,618,619,620,621,622,623 ) and o.`etat`=0 order by price ASC

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