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
Spanish Wines and Wineregions as well as Mixed Cases and Weisswein as well as Mosel-Saar-Ruwer and Franken as well as Dry Wines just like Mueller-Thurgau just as Semi-Dry Wines also Deutscher Wein as well as Pfalz also Gruener Veltiner as well as Qualitaetswein just like Spaetburgunder and Dornfelder as well as Redwine and Muskateller as well as Terroir also Chardonnay as well as Elbling just like Wineshop just as Kerner just like Desert Wines also Vineyard as well as Ruwer just like Pinot Blanc as well as Lemberger just like Rheingau and Scheurebe just as Rheinhessen such as Wine+Holiday just as On-Line Wineshop also Baccus and Main as well as Vinum-X-Tellus just like South African Wines and Holidays just as Cuvèe also Sued Tirol such as Portuguese Wines just as Elbe just like Wachau and Winzer just like Gutedel such as Ahr just as Kabinettwein also Gewuerztraminer just like Organic Wines as well as Deutsche Weinstrasse just like Nahe just like Terroir and Grosses Gewaechs as well as Veneto just like Alsace also Neckar such as Wine Presentations just as Traminer just like St Laurent such as Wuerttemberg just as Bodensee as well as Valpolicella just like Slow Food and Germany as well as Eiswein also Sparkling Wine also Golfholidays such as Rosèwein just as Weingut also Winzersekt also Saale-Unstruht and Mittelrhein and Riesling as well as Sweet Wines just as Italien Wines as well as Weihnachtsmarkt just like Austrian Wines such as Huxelrebe such as Portugieser as well as Baden as well as Saale just like wine and sport and Silvaner such as winery and Grauburgunder just as Rosewine as well as German Wines just like Saar also Whitewine just like Beerenauslese and Pinot Gris and Spaetlese such as Christmas Markets such as Winepresents just as wine just as Mosel just as Weissburgunder just like Pinot Noir also Wine Tastings such as Rotwein and Badische Bergstrasse just like Trollinger such as Barriquewine and Sachsen and Auslese just like Amarone just like Rhein such as wine and holiday as well as Schwarzriesling just as wine and travel just as other wines
