SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (907)
AND
tt1.term_taxonomy_id IN (2290,2292,2294,2296,2298,2300,2302,2304,2306)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '' )
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'es'
AND wp_posts.post_type IN ( 'acf-field-group' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
The best of Culture in Medina Sidonia
Your guide to the cultural events and entertainment in Medina Sidonia, Cádiz. Cultural tours, tourist guides, shows, etc. Explore the culture of Medina Sidonia.
The best cultural tours in Medina Sidonia
Medina Sidonia is a beautiful white town in the interior of the Province of Cádiz that is a must-see for all culture lovers. Medina Sidonia is an ideal place for you to discover the different cultural elements that can be found here and learn all about them.
Medina Sidonia boasts a wealth of items of great cultural value:several churches, religious imagery and sculptures, museums, music, cuisine and history. An enriching experience for all.
All this will undoubtly make you enjoy your visit to the town of Medina Sidonia, especially if you are a culture lover. The history of Medina Sidonia is stricly related to its culture as the influence of the legacy of Al-Andalus has left its mark on the town.
What is more, the local cuisine is undoubtedly part of its culture. When you visit Ubrique, trying the typical coastal food is something that you must try.
Medina Sidonia is not only renowned for its beautiful architecture, but also for the less “tangible” culture: for example, flamenco. If you visit Medina Sidonia, you should see a live flamenco show. Surely, it will not leave you indifferent!
So if you are a real culture aficionado, Medina Sidonia is an ideal town to spend unforgettable holidays. Do not hesitate to check out our website TUDESTINO to find all useful info about Medina Sidonia.
Discover The best of Culture in Medina Sidonia
