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