WordPress-Datenbank-Fehler: [Champ: 'type' dans field list est ambigu]
SELECT SQL_CALC_FOUND_ROWS id, ITEM.syndication_id, code, slug, name, ITEM.lang, communeinsee, photocomplet, commune, descriptif, tarifs, ouverture, lat, lon, urlresa, planning, cp, gratuitpayant, labels, nomoffre, ordre, photosbwt, tel, telmob, qualifblaye, dates, clas, chaines, logisclas, type, agribio, agribiodyn, agriraisonne, ITDATE.next_date, ITDATE.last_date, ITDATE.type AS date_type FROM wpblayedb_sirtaqui_items_flat AS ITEM LEFT JOIN wpblayedb_sirtaqui_items_dates AS ITDATE ON ITEM.code = ITDATE.item_code WHERE ITEM.lang = 'de' AND (ITDATE.lang = 'de' OR ITDATE.lang IS NULL) AND ((ITEM.syndication_id = 4 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 7 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 1 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE 'Blaye Côtes de Bordeaux#%' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux' OR `qualifblaye` LIKE '%#Blaye Côtes de Bordeaux#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 7 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 1 AND (`qualifblaye` = 'Bordeaux' OR `qualifblaye` LIKE 'Bordeaux#%' OR `qualifblaye` LIKE '%#Bordeaux' OR `qualifblaye` LIKE '%#Bordeaux#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 7 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 1 AND (`qualifblaye` = 'Côtes de Bourg' OR `qualifblaye` LIKE 'Côtes de Bourg#%' OR `qualifblaye` LIKE '%#Côtes de Bourg' OR `qualifblaye` LIKE '%#Côtes de Bourg#%')) OR (ITEM.syndication_id = 4 AND (`agribio` = '1' OR `agribio` LIKE '1#%' OR `agribio` LIKE '%#1' OR `agribio` LIKE '%#1#%') AND (`agribiodyn` = '1' OR `agribiodyn` LIKE '1#%' OR `agribiodyn` LIKE '%#1' OR `agribiodyn` LIKE '%#1#%') AND (`agriraisonne` = '1' OR `agriraisonne` LIKE '1#%' OR `agriraisonne` LIKE '%#1' OR `agriraisonne` LIKE '%#1#%'))) ORDER BY ISNULL(gratuitpayant), gratuitpayant DESC, if(ordre = '' or ordre is null,1,0), ordre ASC LIMIT 0,16

Weinberg - Blaye Bourg Terres d'Estuaire
de
40 ᵒ

Maison du Vin de Blaye

Das Maison du Vin de Blaye ist das Tor zum Weinbaugebiet von Blaye Côtes de Bordeaux.

Leider haben wir keine Ergebnisse für Ihre Suche.
Sie müssen Ihre Kriterien ändern.

Diese Seite verwendet Cookies, um Ihre Erfahrung zu verbessern.
Wir gehen davon aus, dass es zu Ihnen passt, Sie können es aber auch abbestellen. Erfahren Sie mehr

ich akzeptiere