select * from products where cregion='AHR' and cprice between 10 and 50 and cstock>1
German wines from THe Ahr region
Browse Wines by Region
Germany:
AHR
Most wine here is light, fruity red, usually (over 40%) from
Sp�tburgunder. It is traditionally made in a late-picked, medium-sweet style, but increasingly a few producers are presenting oak-aged examples in the Burgundy style. Most wine is vinified at local cooperative cellars and sold directly, especially to visitors.
