Arrivée le 25.02.2019 , Départ le 28.02.2019 (3 nuitées)
SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2019-02-25' BETWEEN du AND au) and ('2019-02-28' BETWEEN du AND au)) or (('2019-02-25' BETWEEN du1 AND au1) and ('2019-02-28' BETWEEN du1 AND au1)) or (('2019-02-25' BETWEEN du2 AND au2) and ('2019-02-28' 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,52,316,61,67,319,72,77,78,353,79,84,97,321,322,105,106,107,108,109,111,114,331,337,121,123,347,326,128,135,144,301,224,430,176,177,181,185,196,201,249,254,255,225,348,350,351,282,294,285,271,280,311,371,365,362,428,435,436,438,453,455,457,462,463,467,468,576,473,476,478,480,483,486,500,510,520,527,531,543,554,542,553,564,570,612,577,578,580,581,583,585,594,599,603,606,607,608,609,610,611,613 ) and o.`etat`=0 and o.`id_ville`='80' order by price ASC