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