SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC
LIMIT 36
Default Category
Charly
[ 4 more colors]
€309.00
Nessie
[ 3 more colors]
€298.00
Doudou
[ 5 more colors]
€319.00
Moni
[ 2 more colors]
€138.00
Vison
[ 2 more colors]
€182.00
Versa
[ 3 more colors]
€288.00
Brunelle
[ 4 more colors]
€306.00
Youpi
[ 3 more colors]
€214.00
Ourson
[ 5 more colors]
€175.00
La Patchouly
[ 4 more colors]
€129.00
Rapido
[ 3 more colors]
€122.00
Colette
[ 2 more colors]
€104.00
Cabano
[ 3 more colors]
€118.00
Babilone
[ 2 more colors]
€230.00
Exotic
[ 2 more colors]
€198.00
Kikou
[ 3 more colors]
€258.00
Vérone
[ 2 more colors]
€234.00
Sofa
[ 3 more colors]
€424.00
Modena
[ 3 more colors]
€98.00
Ronronne
[ 4 more colors]
€54.00
Produits pour Chiens
Grison - S
[ 3 more colors]
€40.00
Grison - M
[ 3 more colors]
€48.00
Gamelle Double pour Chien
Grison - S
[ 3 more colors]
€40.00
Grison - M
[ 3 more colors]
€48.00
Produits pour Chats
Charly
[ 4 more colors]
€309.00
Nessie
[ 3 more colors]
€298.00
Doudou
[ 5 more colors]
€319.00
Moni
[ 2 more colors]
€138.00
Vison
[ 2 more colors]
€182.00
Versa
[ 3 more colors]
€288.00
Brunelle
[ 4 more colors]
€306.00
Youpi
[ 3 more colors]
€214.00
Ourson
[ 5 more colors]
€175.00
La Patchouly
[ 4 more colors]
€129.00
Rapido
[ 3 more colors]
€122.00
Colette
[ 2 more colors]
€104.00
Cabano
[ 3 more colors]
€118.00
Babilone
[ 2 more colors]
€230.00
Exotic
[ 2 more colors]
€198.00
Kikou
[ 3 more colors]
€258.00
Vérone
[ 2 more colors]
€234.00
Sofa
[ 3 more colors]
€424.00
Modena
[ 3 more colors]
€98.00
Ronronne
[ 4 more colors]
€54.00
Roue pour chat - Tapis d'exercice
Griffoir chats en Carton Ondulé
Arbres à chat
Charly
[ 4 more colors]
€309.00
Nessie
[ 3 more colors]
€298.00
Doudou
[ 5 more colors]
€319.00
Vison
[ 2 more colors]
€182.00
Versa
[ 3 more colors]
€288.00
Brunelle
[ 4 more colors]
€306.00
Ourson
[ 5 more colors]
€175.00
La Patchouly
[ 4 more colors]
€129.00
Colette
[ 2 more colors]
€104.00
Babilone
[ 2 more colors]
€230.00
Kikou
[ 3 more colors]
€258.00
Vérone
[ 2 more colors]
€234.00
Kouka
[ 2 more colors]
€107.00
Discret
[ 3 more colors]
€198.00
Classique
[ 2 more colors]
€194.00
Boki
[ 3 more colors]
€102.00
Bokio
[ 2 more colors]
€66.00
Maisonnette pour chat avec griffoir
Arbres à chat en bois massif
Classique
[ 2 more colors]
€194.00
Produits pour Chiens et Chats
Sako
[ 2 more colors]
€40.00
Carla
[ 2 more colors]
€39.00
Trône
[ 2 more colors]
€44.00
Lava - M
[ 4 more colors]
€73.00
Lava - L
[ 4 more colors]
€83.00
Lava - XL
[ 4 more colors]
€93.00
Hamac
Sako
[ 2 more colors]
€40.00
Carla
[ 2 more colors]
€39.00
Trône
[ 2 more colors]
€44.00
Panier
Lava - M
[ 4 more colors]
€73.00
Lava - L
[ 4 more colors]
€83.00
Lava - XL
[ 4 more colors]
€93.00
Collection "Made in France" (Délai de livraison 10 jours ouvrés à compter du paiement)
Moni
[ 2 more colors]
€138.00
Youpi
[ 3 more colors]
€214.00
Rapido
[ 3 more colors]
€122.00
Cabano
[ 3 more colors]
€118.00
Exotic
[ 2 more colors]
€198.00
Sofa
[ 3 more colors]
€424.00
Modena
[ 3 more colors]
€98.00
Ronronne
[ 4 more colors]
€54.00
Floralie
[ 2 more colors]
€178.00
Colonnade 55 cm
[ 4 more colors]
€26.00
Archi
[ 3 more colors]
€180.00
Lounge
[ 3 more colors]
€78.00
Rapi
[ 4 more colors]
€98.00
Parasol
[ 4 more colors]
€40.00
