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

Heritage - Blaye Bourg Terres d'Estuaire
en
40 ᵒ

The Citadel of Blaye

Your stroll through the fortress is punctuated with information panels that evoke the history of the site and its development. Picnic tables are provided. For the comfort and safety of all, vehicles are not admitted to the site. Free parking is provided outside the ramparts. The old barracks are now fitted out as workshops for artists and artisans, restaurants, souvenir shops, a hotel, a museum devoted to the history of the citadel and the Gironde estuary.

Sorry, we have no results for your search.
You must modify your criteria.

This site uses cookies to improve your experience.
We will assume that it suits you, but you can unsubscribe if you wish. Know more

I accept