string(0) "" string(3823) "SELECT ( SELECT customizations_code_value FROM customizations_code WHERE customizations_code_id = P.customizations_code_id ) as codigo_maquina, P.products_id, PD.products_name, PD.products_description, PD.publicar, P.products_quantity, P.products_type, P.products_cost_price, IFNULL(s.specials_new_products_price, P.products_price_text) precio_final, P.products_price_text, P.barcode, P.es_promocion, P.btn_visible_solo_comerciales, P.barcodeGenerate, P.manufacturers_id, ( SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1 ) manufacturers_name, P.products_reorder_level, P.ref_fabricante, P.customization, P.products_image, P.products_image_med, P.products_image_lrg, P.products_image_sm_1, P.products_image_xl_1, P.products_image_sm_2, P.products_image_xl_2, P.products_image_sm_3, P.products_image_xl_3, P.products_image_sm_4, P.products_image_xl_4, P.products_image_sm_5, P.products_image_xl_5, P.products_image_sm_6, P.products_image_xl_6, P.products_image_sm_7, P.products_image_xl_7, P.products_image_video, P.products_embed_video, P.showPreview, P.is_exclusive, P.products_production_days, P.dias_produccion_a_causa_de, DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available, P.products_model, P.products_status, P.products_date_added, P.customizations_code_id, P.products_color_rgb, P.products_tax_class_id, s.status as specstat, s.specials_new_products_price, P.products_tasks, P.puntos, P.sumar_personalizacion, P.ref_catalogo, ISNULL(fp.products_id) as disponibleFueraUE, P.products_image_list, P.products_image_detail, P.es_dropshipping, P.meses_min, P.meses_max, 0 discount, P.es_producto_manufacturado as PERSONALIZADO FROM products P INNER JOIN products_description PD ON P.products_id = '24136' AND PD.language_id = '9' AND PD.products_id = P.products_id LEFT JOIN filtros_products fp ON P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE' LEFT JOIN specials s ON P.products_id = s.products_id WHERE P.products_type!='4' AND P.products_type!='8' group by P.products_id "
Summer > Beach toys > Scrunch - bucket, Pastel Pink
https://www.tutete.com/tienda/en/571_summer/191_beach-toys/24136_scrunch---bucket-pastel-pink.html
24136
Scrunch - bucket, Pastel Pink
https://www.tutete.com/tienda/images/4793911651566831-LG.jpg
15.9
EUR
InStock
94_sales-section
2017-03-27
A bucket that looked good, felt good and could be taken anywhere and used for any purpose! Could we find one? No! So we decided to design one! Goodbye ugly, hard plastic buckets that break, are discarded and take up space.
Great for carrying water, picking fruit and vegetables, weeding, washing your car – and countless other tasks.
The award-winning Scrunch-bucket is designed to be taken anywhere, to be squashed into small spaces and to be used for a multitude of purposes. Made of food-grade silicone in a multitude of colours with a matching rope and solid silicone handle.
- Easy to store – take it on the road or stow at home
- Washable – easy to keep clean
- Non-toxic – it can double as a dog bowl or a plant holder
- Strong – it’s made to last
- Durable – it’ll hold its shape and look good for years
- Height 13.5cm x Diameter 16.0 cm