select * from products where cregion='Colares' and cprice between 10 and 50 and cstock>1
Colares, Portugal Wine region
Browse Wines by Region
Portugal: Colares
Colares is best-known in the wine world for its sandy soil, which protected it from the nineteenth century scourge of phylloxera. It produces small quantities of an unusual red wine from the Ramisco grape.
