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
Produits pour Chiens
Grison - S
[ 2 more colors]
€40.00
Grison - M
[ 3 more colors]
€48.00
Gamelle Double pour Chien
Grison - S
[ 2 more colors]
€40.00
Grison - M
[ 3 more colors]
€48.00
Produits pour Chats
Sirius
[ 2 more colors]
€356.00
Charly
[ 3 more colors]
€309.00
Pagode
[ 2 more colors]
€400.00
Nessie
[ 3 more colors]
€298.00
Doudou
[ 4 more colors]
€319.00
Léa
[ 2 more colors]
€134.00
Monique
[ 2 more colors]
€172.00
Vison
[ 2 more colors]
€182.00
Eden
[ 4 more colors]
€252.00
Bureau Ovale
[ 3 more colors]
€62.00
Versa
[ 4 more colors]
€288.00
Brunelle
[ 2 more colors]
€306.00
Ourson
[ 5 more colors]
€175.00
Rapido
[ 3 more colors]
€106.00
Colette
[ 5 more colors]
€104.00
Babilone
[ 3 more colors]
€230.00
Curl
[ 2 more colors]
€250.00
Exotic
[ 3 more colors]
€168.00
Kikou
[ 3 more colors]
€258.00
Vérone
[ 6 more colors]
€234.00
Mur escalade pour chat
Griffoir mural pour chat "Mogli" - L
[ 2 more colors]
€204.00
Griffoir mural pour chat "Mogli" - M
[ 2 more colors]
€94.00
Griffoir mural pour chat "Mogli" - S
[ 2 more colors]
€35.00
Colection Mogli
Griffoir mural pour chat "Mogli" - L
[ 2 more colors]
€204.00
Griffoir mural pour chat "Mogli" - M
[ 2 more colors]
€94.00
Griffoir mural pour chat "Mogli" - S
[ 2 more colors]
€35.00
Roue pour chat - Tapis d'exercice
Roue de 110Ø et Tapis d'exercice pour Chat
[ 2 more colors]
€490.00
Griffoir chats en Carton Ondulé
Convexe
[ 3 more colors]
€46.00
Switch
[ 3 more colors]
€43.00
Stick
[ 3 more colors]
€31.00
Over
[ 3 more colors]
€46.00
Malibou
[ 2 more colors]
€38.00
Arbres à chat
Sirius
[ 2 more colors]
€356.00
Charly
[ 3 more colors]
€309.00
Pagode
[ 2 more colors]
€400.00
Nessie
[ 3 more colors]
€298.00
Doudou
[ 4 more colors]
€319.00
Léa
[ 2 more colors]
€134.00
Monique
[ 2 more colors]
€172.00
Vison
[ 2 more colors]
€182.00
Eden
[ 4 more colors]
€252.00
Versa
[ 4 more colors]
€288.00
Brunelle
[ 2 more colors]
€306.00
Ourson
[ 5 more colors]
€175.00
Babilone
[ 3 more colors]
€230.00
Curl
[ 2 more colors]
€250.00
Exotic
[ 3 more colors]
€168.00
Kikou
[ 3 more colors]
€258.00
Vérone
[ 6 more colors]
€234.00
Sofa
[ 2 more colors]
€330.00
Kouka
[ 2 more colors]
€107.00
Fidou
[ 2 more colors]
€244.00
Griffoirs chats
La Patchouly
[ 5 more colors]
€129.00
Rapido
[ 3 more colors]
€106.00
Colette
[ 5 more colors]
€104.00
Colonnade 50 cm
[ 3 more colors]
€18.00
Maisonnette pour chat avec griffoir
Bureau Ovale
[ 3 more colors]
€62.00
Ronronne
[ 2 more colors]
€53.00
Arbres à chat en bois massif
Classique
[ 3 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
Elite - M
[ 3 more colors]
€59.00
Elite - L
[ 3 more colors]
€69.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
Maisonnette transformer
Elite - M
[ 3 more colors]
€59.00
Elite - L
[ 3 more colors]
€69.00
