SELECT `clients`.* FROM `clients`, `ville`
WHERE prix_minimum > 0 AND `clients`.pays = 'France'
AND `clients`.ville = `ville`.id_ville
AND id_ville = '1289'
AND `clients`.descriptif_it != ''
Prenota un albergo a Val d'Isère - prenotare a miglior prezzo
