select * from products where cregion='Robertson' and cprice between 10 and 50 and cstock>1
Robertson South Africian Wine region
Browse Wines by Region
South Africa : Robertson
The Robertson region initially gained fame as a source of some of the country's finer white and fortified dessert wines. The region has a warm, dry climate, and virtually all of the vineyards need some irrigation. Recently, however, new interest has been generated by the powerfully ripe Chardonnay grapes that are being grown in this area. While the Robertson region incorporates many better known areas such as Stellenbosch, wines with a Robertson Wine of Origin label will come from the larger, less restricted area.
