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, nomoffre, ordre, photosbwt, tel, telmob, qualifblaye, labels, dates, type, chaines, logisclas, clas, tarifstexte, animaux, acceshandi, 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 = 12 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 13 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 = 2 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (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 = 14 AND (`qualifblaye` = 'Regen' OR `qualifblaye` LIKE 'Regen#%' OR `qualifblaye` LIKE '%#Regen' OR `qualifblaye` LIKE '%#Regen#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Familie' OR `qualifblaye` LIKE 'Familie#%' OR `qualifblaye` LIKE '%#Familie' OR `qualifblaye` LIKE '%#Familie#%')) OR (ITEM.syndication_id = 2 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 = 12 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Erbe' OR `qualifblaye` LIKE 'Erbe#%' OR `qualifblaye` LIKE '%#Erbe' OR `qualifblaye` LIKE '%#Erbe#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Handwerk und lokale Produkte' OR `qualifblaye` LIKE 'Handwerk und lokale Produkte#%' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Handwerk und lokale Produkte' OR `qualifblaye` LIKE 'Handwerk und lokale Produkte#%' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Handwerk und lokale Produkte' OR `qualifblaye` LIKE 'Handwerk und lokale Produkte#%' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Handwerk und lokale Produkte' OR `qualifblaye` LIKE 'Handwerk und lokale Produkte#%' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Handwerk und lokale Produkte' OR `qualifblaye` LIKE 'Handwerk und lokale Produkte#%' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte' OR `qualifblaye` LIKE '%#Handwerk und lokale Produkte#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 8 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 9 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Zitadelle von Blaye' OR `qualifblaye` LIKE 'Zitadelle von Blaye#%' OR `qualifblaye` LIKE '%#Zitadelle von Blaye' OR `qualifblaye` LIKE '%#Zitadelle von Blaye#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 8 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 9 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Dorf von Bourg' OR `qualifblaye` LIKE 'Dorf von Bourg#%' OR `qualifblaye` LIKE '%#Dorf von Bourg' OR `qualifblaye` LIKE '%#Dorf von Bourg#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Führungen' OR `qualifblaye` LIKE 'Führungen#%' OR `qualifblaye` LIKE '%#Führungen' OR `qualifblaye` LIKE '%#Führungen#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Kostenlose Besuche' OR `qualifblaye` LIKE 'Kostenlose Besuche#%' OR `qualifblaye` LIKE '%#Kostenlose Besuche' OR `qualifblaye` LIKE '%#Kostenlose Besuche#%')) OR (ITEM.syndication_id = 12 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 13 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 11 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 2 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 10 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 5 AND (`tarifstexte` = 'Eintritt frei' OR `tarifstexte` LIKE 'Eintritt frei#%' OR `tarifstexte` LIKE '%#Eintritt frei' OR `tarifstexte` LIKE '%#Eintritt frei#%') OR (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 14 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 3 AND (`tarifstexte` = 'Kostenlos' OR `tarifstexte` LIKE 'Kostenlos#%' OR `tarifstexte` LIKE '%#Kostenlos' OR `tarifstexte` LIKE '%#Kostenlos#%')) OR (ITEM.syndication_id = 12 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 13 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 2 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 11 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 10 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 5 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 14 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 3 AND (`animaux` = '1' OR `animaux` LIKE '1#%' OR `animaux` LIKE '%#1' OR `animaux` LIKE '%#1#%')) OR (ITEM.syndication_id = 12 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 13 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 2 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 11 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 10 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 5 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 14 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%')) OR (ITEM.syndication_id = 3 AND (`acceshandi` = '1' OR `acceshandi` LIKE '1#%' OR `acceshandi` LIKE '%#1' OR `acceshandi` LIKE '%#1#%'))) ORDER BY ISNULL(gratuitpayant), gratuitpayant DESC, if(ordre = '' or ordre is null,1,0), ordre ASC LIMIT 0,16