SELECT `clients`.* FROM `clients`, `ville`
WHERE prix_minimum > 0 AND `clients`.pays = 'France'
AND `clients`.ville = `ville`.id_ville
AND id_ville = '3794'
AND `clients`.descriptif_it != ''
Prenota un albergo a L'Alpe d'Huez - prenotare a miglior prezzo
