SELECT domaines_forfaits.duree, domaines_forfaits.prix
FROM domaines_forfaits INNER JOIN station ON domaines_forfaits.IDdomaine=station.IDdomaine

WHERE domaines_forfaits.IDdomaine= and IDtypeForfait=1 and IDtypeClient=1 and (duree='1 jour' or duree='2 jours' or duree='6 jours')
GROUP BY duree
ORDER BY duree asc