WordPress database error: [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 = 'en' AND (ITDATE.lang = 'en' OR ITDATE.lang IS NULL) AND ((ITEM.syndication_id = 12 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Rain' OR `qualifblaye` LIKE 'Rain#%' OR `qualifblaye` LIKE '%#Rain' OR `qualifblaye` LIKE '%#Rain#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Family' OR `qualifblaye` LIKE 'Family#%' OR `qualifblaye` LIKE '%#Family' OR `qualifblaye` LIKE '%#Family#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Heritage' OR `qualifblaye` LIKE 'Heritage#%' OR `qualifblaye` LIKE '%#Heritage' OR `qualifblaye` LIKE '%#Heritage#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Crafts and local products' OR `qualifblaye` LIKE 'Crafts and local products#%' OR `qualifblaye` LIKE '%#Crafts and local products' OR `qualifblaye` LIKE '%#Crafts and local products#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Crafts and local products' OR `qualifblaye` LIKE 'Crafts and local products#%' OR `qualifblaye` LIKE '%#Crafts and local products' OR `qualifblaye` LIKE '%#Crafts and local products#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Crafts and local products' OR `qualifblaye` LIKE 'Crafts and local products#%' OR `qualifblaye` LIKE '%#Crafts and local products' OR `qualifblaye` LIKE '%#Crafts and local products#%')) OR (ITEM.syndication_id = 4 AND (`qualifblaye` = 'Crafts and local products' OR `qualifblaye` LIKE 'Crafts and local products#%' OR `qualifblaye` LIKE '%#Crafts and local products' OR `qualifblaye` LIKE '%#Crafts and local products#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Crafts and local products' OR `qualifblaye` LIKE 'Crafts and local products#%' OR `qualifblaye` LIKE '%#Crafts and local products' OR `qualifblaye` LIKE '%#Crafts and local products#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 8 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 9 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Citadel of Blaye' OR `qualifblaye` LIKE 'Citadel of Blaye#%' OR `qualifblaye` LIKE '%#Citadel of Blaye' OR `qualifblaye` LIKE '%#Citadel of Blaye#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 15 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 8 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 9 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 3 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Village of Bourg' OR `qualifblaye` LIKE 'Village of Bourg#%' OR `qualifblaye` LIKE '%#Village of Bourg' OR `qualifblaye` LIKE '%#Village of Bourg#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Guided tours' OR `qualifblaye` LIKE 'Guided tours#%' OR `qualifblaye` LIKE '%#Guided tours' OR `qualifblaye` LIKE '%#Guided tours#%')) OR (ITEM.syndication_id = 12 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 13 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 11 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 2 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 10 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 5 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 14 AND (`qualifblaye` = 'Free visits' OR `qualifblaye` LIKE 'Free visits#%' OR `qualifblaye` LIKE '%#Free visits' OR `qualifblaye` LIKE '%#Free visits#%')) OR (ITEM.syndication_id = 12 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 13 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 11 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 2 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 10 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 5 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%') OR (`tarifstexte` = 'Free of charge for visitors' OR `tarifstexte` LIKE 'Free of charge for visitors#%' OR `tarifstexte` LIKE '%#Free of charge for visitors' OR `tarifstexte` LIKE '%#Free of charge for visitors#%') OR (`tarifstexte` = 'Free entrance' OR `tarifstexte` LIKE 'Free entrance#%' OR `tarifstexte` LIKE '%#Free entrance' OR `tarifstexte` LIKE '%#Free entrance#%')) OR (ITEM.syndication_id = 14 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) OR (ITEM.syndication_id = 3 AND (`tarifstexte` = 'Free of charge' OR `tarifstexte` LIKE 'Free of charge#%' OR `tarifstexte` LIKE '%#Free of charge' OR `tarifstexte` LIKE '%#Free of charge#%')) 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