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