• Livraison France & Belgique exclusivement
  • Livraison offerte dès 40€ d'achats
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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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=1 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

Croquet Champions (bois)

Jeu de croquet sur le thème du football ! Sois le premier à passer la balle dans les 6 portes en formes de joueurs de foot ! Le jeu de croquet est un jeu...
Lire la suite

Description

Jeu de croquet sur le thème du football ! Sois le premier à passer la balle dans les 6 portes en formes de joueurs de foot ! Le jeu de croquet est un jeu d'adresse simple et idéal pour s'amuser en famille ou entre amis. Il aidera les plus petits à développer leur dextérité, et ravira les plus grands ! Contient : 6 portes, 2 maillets et 2 boules (diam. 5 cm).

Infos produit

Dimensions 32 x 8 x 32 cm
Matière Bois
Genre Mixte

Découvrez aussi