select * from products where cregion='Dao' and cprice between 10 and 50 and cstock>1
Dao, Portugal Wine region
Browse Wines by Region
Portugal: Dao
The Dao wine region, centered
around the old cathedral city of Viseu in north central
Portugal, has the reputation for producing some of the country's
best red wines. Its name comes from a river in the high country
not far south of the Douro and well inland from the sea. Its
beautiful countryside resembles that of Provence, France, with
pine woods alternating with sprawling vineyards over monster,
steep-sided sand-dunes, eventually rolling down into the rocky
bed of the river.
More than two-thirds of the wines produced in Dao's are red,
made from any one, or a combination of, nine different grape
varietals. Touriga national, one of the principle Port wine
grapes, is regarded as the best in the region and must account
for at least twenty percent of any red wine. Encruzado is the
dominant white grape varietal, which is usually blended with
others from the region.