select * from products where cregion='Swartland' and cprice between 10 and 50 and cstock>1
Swartland South Africian Wine region
Browse Wines byRegion
South Africa : Swartland
Swartland lies to the northwest of Capetown, a region of warmer
temperatures and rich wines. These can range from powerful and
flavorful red wines to quite well-made fortified dessert wines.
Neighboring Piketberg to the north shares similar growing conditions
and produces a similar range of wines. Recently, both areas have seen
an increase in interest in lighter white wines for current consumption.
