select * from products where cregion='Paarl' and cprice between 10 and 50 and cstock>1
Paarl South Africian Wine region
Browse Wines by Region
South Africa : Paarl
Fifty miles northeast of Capetown, Paarl is a justifiably world-famous
wine region, home to some of South Africa's best-known wineries. At a
latitude of some 33.5 degrees from the equator, the region is best
known for its dessert and fortified wines, similar to the sherries of
Spain. The climate is quite warm, and the vineyards often require
irrigation. New plantings of Cabernet Sauvignon, Pinotage and
Chardonnay may soon find their way into the export market.
