string(1645) "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` = 'couleur' AND `custom_fields_options`.`field_option` = 'violet') 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` = 'materiau' AND `custom_fields_options`.`field_option` = 'ceramique-porcelaine-gres-faience' OR `custom_fields_options`.`field_option` = 'verre-cristal') AND `products`.`category_id` = '37' 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" Vide-Poche, Cendrier occasion vintage violet en ceramique-porcelaine-gres-faience verre-cristal

VIDE-POCHE, CENDRIER violet ceramique-porcelaine-gres-faience,verre-cristal

Couleur violet
Matériau ceramique-porcelaine-gres-faience~verre-cristal
Annuler filtres

12 Vide-Poche, Cendrier de seconde main sur notre brocante vintage en ligne

Trier par :

Aucun produit !