string(1936) "SELECT `products`.`id`, `products`.`product_type`, `products`.`slug`, `products`.`en_slug`, `products`.`title`, `products`.`en_title`, `products`.`description`, `products`.`en_description`, `products`.`is_promoted`, `products`.`is_sold`, `products`.`is_deleted`, `products`.`visibility`, `products`.`listing_type`, `products`.`price`, `products`.`discount_rate`, `products`.`is_crush`, `products`.`is_coup_de_coeur`, `users`.`username` as `user_username`, `users`.`shop_name` as `shop_name`, `users`.`role` as `user_role`, `users`.`slug` as `user_slug` FROM `products` JOIN `users` ON `products`.`user_id` = `users`.`id` WHERE `users`.`banned` = 0 AND `products`.`status` = 1 AND `products`.`is_draft` = 0 AND products.id IN (SELECT `product_id` FROM `custom_fields_product` JOIN `custom_fields_options` ON `custom_fields_options`.`common_id` = `custom_fields_product`.`selected_option_common_id` WHERE `custom_fields_product`.`product_filter_key` = 'style' AND `custom_fields_options`.`field_option` = 'contemporary') AND products.id IN (SELECT `product_id` FROM `custom_fields_product` JOIN `custom_fields_options` ON `custom_fields_options`.`common_id` = `custom_fields_product`.`selected_option_common_id` WHERE `custom_fields_product`.`product_filter_key` = 'couleur' AND `custom_fields_options`.`field_option` = 'blue' OR `custom_fields_options`.`field_option` = 'brown') AND ( `products`.`category_id` = '64' OR `products`.`category_id` = '73' OR `products`.`category_id` = '74' OR `products`.`category_id` = '75' OR `products`.`category_id` = '77' OR `products`.`category_id` = '78' OR `products`.`category_id` = '99' OR `products`.`category_id` = '335' OR `products`.`category_id` = '336' OR `products`.`category_id` = '337' ) ORDER BY `products`.`is_sold` ASC, `products`.`is_deleted` ASC, `products`.`is_promoted` DESC, `products`.`is_crush` DESC, `products`.`is_coup_de_coeur` DESC, `products`.`created_at` DESC LIMIT 46" Storage furniture Used vintage style contemporary blue brown

STORAGE FURNITURE contemporary blue,brown

“L'ordre : caractère créatif du rangement...” Pierre Dehaye

Style contemporary
Color blue~brown
Reset filters

2 Storage furniture second-hand on our online vintage flea market

Sort By:

No products found!