• Delivery only in France & Belgium
  • Discover our brand new website !
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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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=3 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
Add to my wishlist

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

Connexion Inscription

Tactile Puzzles

The sense of touch is very important to babies. It is their first contact with the world around them. To introduce them to various textures, Janod has created tactile puzzles that match animals with their fur, skin or plumage. It is up to children to reassemble the puzzle while having fun and using their senses.