• Envío únicamente a Francia/Bélgica
  • ¡Descubre nuestro nuevo sitio web!
SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 15)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 16)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 20)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 18)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 14)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 19)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 17)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 7) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13)) ORDER BY id_feature_value SELECT distinct(fvl.VALUE) as feature_name,fvl.id_feature_value FROM `ps_feature_value_lang` fvl LEFT JOIN `ps_feature_product` `fp` ON fp.id_feature_value = fvl.id_feature_value AND id_lang=6 WHERE (fp.id_feature = 25) AND (fp.id_product IN (SELECT id_product FROM ps_category_product WHERE id_category = 13)) ORDER BY id_feature_value
Ajouter à ma wishlist

Vous devez avoir un compte pour pouvoir utiliser cette fonctionnalité.

Connexion Inscription

Caballeros & Princesas

Filtrar

Add this product to my list of favorites. Remove this product from my favorite's list.
product
Fortaleza Dragón (madera)
Magnífica fortaleza suministrada con todos los accesorios necesarios para librar grandes batallas contra el enemigo : 6 caballeros, 2 caballos, un dragón y un puzle de cartón de 30 piezas (60 x 60 cm) que sirve de campo de batalla. El fuerte está equipado con un puente levadizo que se baja y eleva gracias a un sistema de polea giratoria. La rejilla negra y el camino de ronda se pueden mover completamente. Los muros y las torres del fuerte son muy fáciles de montar gracias a su sistema de muescas para encajar las piezas.
Add this product to my list of favorites. Remove this product from my favorite's list.
product
Mini Story Caballeros (madera)
¡Parte con tus caballeros para derrotar al terrible dragón! Contiene 5 caballeros, 1 caballo y un dragón.7 piezas de macera maciza (haya).
Add this product to my list of favorites. Remove this product from my favorite's list.
product
Mini Story Princesas (madera)
Crea tu cuento de hadas mágico inventando tu propia historia. Contiene 1 príncipe, 1 princesa, 1 bruja, 1 rana, 1 unicornio, 1 caballo, 1 carroza.7 piezas de macera maciza (haya).
Add this product to my list of favorites. Remove this product from my favorite's list.
product
Cofre de Caballeros (madera)
¡Magnífico cofre con todas las herramientas necesarias para librar grandes batallas contra el enemigo! Se enfrentan 2 clanes : los caballeros rojos contra los caballeros azules. Pero ¡cuidado con el abominable dragón y su soplo de llamas devastador! ¡Rápido, usemos la catapulta para combatirlo! Cofre compuesto de 10 caballeros, 4 caballos, un dragón y una auténtica catapulta equipada con 3 balas de cañón. 19 piezas.
¡Para los amantes de las grandes historias épicas, Janod ha creado mundos de caballeros y princesas que les gustarán a los niños rebosantes de imaginación! ¡Dragones, castillos fortificados, batallas para salvar a la princesa, un gran clásico que siempre funciona! ¡Las decoraciones acompañadas de bonitas figuritas de madera permiten a los niños sumergirse en un mundo que les encanta e irse de aventuras sin límites!