select * from products where cregion='Douro' and cprice between 10 and 50 and cstock>1
Douro, Portugal Wines
Browse Wines by Region
Portugal: Douro
Since all areas of the country are suited to grape cultivation,
Portugal encompasses a lot of diversity. The Douro, which alone
cultivates more than eighty grape varieties, uses half its grapes to
produce port. The rest of the harvest is vinified into fine table wines
in styles ranging from light and fresh to deep, smoky and tannic. Like
port, the finest are cultivated on ancient schistous shale terraces
lining the river valley, and come from red varietals Touriga Nacional,
Tinta Roriz (Tempranillo), Tinta Barroca, Touriga Francesa and Tinto
C��o. White varieties, also used for white port, include Malvasia Fina, Viosinho, and Gouveio.
