test

Royal Botania, Fauteuils

Le coin du fauteuil de Royal Botania

Royal Botania vous propose des fauteuils pour tous les genres.

Des fauteuils en coin NINIX pour habiller au mieux votre pièce. Des fauteuils pour extérieures DEL-REY afin d’être confortable même dans votre jardin. Des fauteuils moelleux ZIDIZ pour tous ceux qui privilégient le confort.

Pour tout renseignement, appelez Charlotte au 01 75 43 09 51

Voir tous les produits Royal Botania
Filtrer
SELECT DISTINCT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`description`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image`, `e`.`image_label`, `e`.`is_imported`, `e`.`is_recurring`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`name`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`recurring_profile`, `e`.`required_options`, `e`.`shipment_type`, `e`.`short_description`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`weight_type`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`meta_title`, `e`.`meta_keyword`, `e`.`meta_description`, `e`.`media_gallery`, `e`.`old_id`, `e`.`color`, `e`.`color_value`, `e`.`gallery`, `e`.`minimal_price`, `e`.`custom_design_from`, `e`.`custom_design_to`, `e`.`custom_layout_update`, `e`.`samples_title`, `e`.`matiere`, `e`.`matiere_value`, `e`.`taille`, `e`.`taille_value`, `e`.`designer`, `e`.`designer_value`, `e`.`commandable`, `e`.`dimensions`, `e`.`delai_livraison_normal`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`ugiftcert_amount_config`, `e`.`gamme_collection`, `e`.`gamme_collection_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`reference_fournisseur`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`transporteur`, `e`.`transporteur_value`, `e`.`forme`, `e`.`forme_value`, `e`.`status`, `e`.`ean`, `e`.`popularity`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`central_id`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`reference_fournisseur`, `e`.`options_obligatoires`, `e`.`options_obligatoires_value`, `e`.`type_objet`, `e`.`type_objet_value`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`ugiftcert_amount_config`, `e`.`delai_en_stock`, `e`.`delai_en_stock_value`, `e`.`delai_sur_commande`, `e`.`delai_sur_commande_value`, `e`.`stock_location`, `e`.`stock_location_value`, `e`.`forme`, `e`.`forme_value`, `e`.`ean`, `e`.`popularity`, `e`.`central_id`, `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`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_super_link` AS `confs` ON e.entity_id=confs.parent_id INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' 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 e.status=1 and confs.product_id in(6805,6808,6810,6811,6812,7050,7051,7070,7095,7454,7455,7456,7457,7460,7461,7462,7464,13711,13748,13750,13751,13752,13753,13754,13755,13756,13757,13769,13771,13772,13773,23410,24679,24706,24707,24709,24710,24711,24712,24713,24715,24716,24717,24718,24719,24734,24748,24749,24750,24751,24756,24757,24758,24759,24806,24807,24808,24809,27478,27479,29482,29483,29484,40540) ORDER BY `e`.`popularity` DESC, `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 200