Arrivée le 21.12.2018 , Départ le 24.12.2018 (3 nuitées)
SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2018-12-21' BETWEEN du AND au) and ('2018-12-24' BETWEEN du AND au)) or (('2018-12-21' BETWEEN du1 AND au1) and ('2018-12-24' BETWEEN du1 AND au1)) or (('2018-12-21' BETWEEN du2 AND au2) and ('2018-12-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,52,62,316,61,67,319,72,77,78,353,79,84,97,321,322,102,105,106,107,108,109,114,331,121,123,325,326,128,135,144,301,230,231,224,499,430,176,177,185,201,249,255,225,348,350,351,282,294,285,271,280,311,379,372,371,365,362,428,433,435,436,438,453,458,462,463,467,468,576,473,476,478,480,483,486,500,505,510,520,527,528,531,554,542,544,548,550,553,564,566,570,584,577,578,580,583,594,599,601,603,605,606,607,608,609,610 ) and o.`etat`=0 and o.`id_ville`='80' order by price ASC
