, Tunis Arrivée le 25.01.2020 , Départ le 28.01.2020 (3 nuitées)
SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2020-01-25' BETWEEN du AND au) and ('2020-01-28' BETWEEN du AND au)) or (('2020-01-25' BETWEEN du1 AND au1) and ('2020-01-28' BETWEEN du1 AND au1)) or (('2020-01-25' BETWEEN du2 AND au2) and ('2020-01-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,46,52,59,65,77,91,321,103,105,106,107,108,109,114,337,117,121,341,343,347,326,128,144,225,351,294,280,371,414,516,436,457,458,463,476,512,517,523,527,528,543,566,581,583,585,594,599,606,620,622,623,625 ) and o.`etat`=0 and o.`id_ville`='1' order by price ASC
