select wein.*, region.name, weingut.id_region, weingut.name, rebsorte.name, qualitaet.name from wein left join weingut on wein.id_weingut=weingut.id left join region on weingut.id_region=region.id left join rebsorte on wein.grape=rebsorte.id left join qualitaet on wein.quality=qualitaet.id where wein.id=155;
2002 Spaetburgunder Rotwein 'Alte Reben' vinum-x-tellus
The following text is optimized for Searchengines.
Please goto http://www.vinum-x-tellus.ie/ for further information.
Fine Wines from the regions - wine and Travel
This Site contain Information about
Sweet Wines also Eiswein such as Deutscher Wein as well as Baden also Weissburgunder such as Whitewine also Portugieser such as Gruener Veltiner just like St Laurent such as Neckar also Muskateller such as Semi-Dry Wines just as Barriquewine also Wachau such as Rosèwein just like Terroir such as Wineregions also Wuerttemberg and Kabinettwein just like wine and holiday such as Italien Wines as well as Gewuerztraminer also winery such as wine and travel just as Rhein such as Redwine just as Rotwein just like Pinot Noir as well as Chardonnay also Saar and Elbe just as Trollinger just like Wine Presentations such as Ahr as well as Alsace just like Mittelrhein just as Pfalz also Vinum-X-Tellus such as Nahe as well as Cuvèe also Sachsen as well as Grauburgunder also wine and sport such as Sued Tirol just as Baccus just like On-Line Wineshop such as Weihnachtsmarkt such as Mueller-Thurgau just as Desert Wines also Mosel-Saar-Ruwer such as Franken just as Winzersekt also Amarone as well as wine also Spaetburgunder such as Winepresents as well as Veneto just as Golfholidays also Wine Tastings such as Schwarzriesling and Badische Bergstrasse as well as Mixed Cases just like Spanish Wines also Mosel such as Spaetlese as well as Ruwer just as Terroir just like Qualitaetswein and Bodensee and Scheurebe as well as Austrian Wines as well as Huxelrebe also Weisswein such as Wineshop and Holidays and Vineyard just as Deutsche Weinstrasse as well as German Wines as well as Lemberger just like Kerner and Saale just like Saale-Unstruht and Dornfelder also Riesling also Traminer just like Elbling and Dry Wines and Slow Food and Grosses Gewaechs just as Pinot Gris as well as Main as well as Pinot Blanc just as Silvaner just like Portuguese Wines also Wine+Holiday just like Beerenauslese such as Sparkling Wine and Rheingau and Winzer such as South African Wines such as Organic Wines also Gutedel and Auslese such as Germany such as Rosewine and Christmas Markets such as Weingut also Valpolicella also Rheinhessen also other wines
