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) LEFT 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 (92) AND tt1.term_taxonomy_id IN (92) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (237,368) ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'etheme_portfolio' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'etheme_ocio' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','etheme_portfolio','etheme_ocio','testimonial' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','etheme_portfolio','etheme_ocio','testimonial' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 33

CONDIODO | PROMOTION

THIS 11/11 ENJOY UP TO -61% ON ALL HAIR REMOVAL! Enjoy an additional 11% discount on all our anniversary discounts.

JUGUETTOS | PROMOTION

These will be the faces of your kids when they see the new Juguettos Christmas catalog. Already available in our stores! Run to your favorite Juguettos store because this year our catalog hides many surprises, share the magic of Christmas!

HAWKERS | PROMOTION

Sunglasses: Product selection 2x50€. *Not cumulative with other current promotions in store.

HAWKERS | PROMOTION

PRESCRIPTION GLASSES from 2x99€* *Cannot be combined with other promotions in store.

¿Quieres suscribirte para recibir las últimas promociones y ofertas?

Reglamento (UE) 2016/679 RGPD y RGPDGDD 3/2018. El responsable del tratamiento de sus datos personales es TOSA S.A.R.L. y trata sus datos para gestionar la inscripción a nuestra newsletter pudiendo así enviarle información de ofertas, promociones exclusivas, noticias de interés del centro. Podrá ejercitar los derechos de acceso, rectificación y supresión de los datos, entre otros, tal y como se explica en la información adicional que está a su disposición Política de Privacidad.
Le informamos que puede retirar su consentimiento en cualquier momento, dirigiéndose por escrito a la dirección del Responsable del Tratamiento. Si usted lo retira, los tratamientos que se hayan realizado antes continuarán siendo válidos.

close