Arrivée le 01.08.2014 , Départ le 04.08.2014 (3 nuitées)

SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2014-08-01' BETWEEN du AND au) and ('2014-08-04' BETWEEN du AND au)) or (('2014-08-01' BETWEEN du1 AND au1) and ('2014-08-04' BETWEEN du1 AND au1)) or (('2014-08-01' BETWEEN du2 AND au2) and ('2014-08-04' 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,472,46,48,49,52,63,316,59,61,64,65,67,357,70,319,71,72,77,353,79,89,84,91,92,93,94,96,97,321,322,515,98,102,103,105,106,107,108,109,110,111,114,115,116,331,335,336,337,117,118,120,121,123,340,341,342,343,346,347,125,326,127,128,130,131,132,134,368,135,136,140,144,203,301,223,230,224,172,498,499,501,502,511,176,177,179,181,190,193,196,197,201,369,204,208,249,252,254,255,333,212,225,348,349,350,351,227,282,344,290,334,294,285,271,270,277,280,311,314,379,376,273,374,373,371,367,366,365,364,362,405,409,414,428,516,513,431,432,433,434,435,436,453,452,455,456,457,458,462,463,466,468,469,470,473,474,495,477,478,479,480,483,484,485,486,487,488,497,500,489,490,491,492,494,504,505,509,508,512,510,514,517,518,520,521,523 ) and o.`etat`=0 order by price ASC

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