SELECT `clients`.* FROM `clients`, `ville`
WHERE prix_minimum > 0 AND `clients`.pays = 'France'
AND `clients`.ville = `ville`.id_ville
AND id_ville = '3949'
AND `clients`.descriptif_it != ''
Prenota un albergo a Juan les Pins - prenotare a miglior prezzo
