string(0) "" string(7315) "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.ai, 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, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail, NULL as 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 specials_new_products_price, P.products_tasks, P.puntos, P.sumar_personalizacion, P.ref_catalogo, ISNULL(fp.products_id) as disponibleFueraUE, P.es_dropshipping, P.meses_min, P.meses_max, 0 discount, P.es_producto_manufacturado as PERSONALIZADO, ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento FROM products P INNER JOIN products_description PD ON P.products_id = '88813' 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 AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0 LEFT JOIN specials svip ON P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1 WHERE P.products_type!='4' AND P.products_type!='8' group by P.products_id "
Playschool > Lunch Boxes > Fruit Box Magical Forest
https://www.tutete.com/tienda/en/88_playschool/214_lunch-boxes/88813_fruit-box-magical-forest.html
88813
Fruit Box Magical Forest
https://s3.eu-west-1.amazonaws.com/dev-cdn.tutete.com/admin/assets/images/productos/6/4/4/8/4/5/644845-1200x1000.jpg
3.25
EUR
InStock
88_playschool
88_playschool/214_lunch-boxes
2024-09-05
Fruit Boxes
Fruit Boxes Tutete 2025
lunch boxes
Tutete Fruit Box with Fork, ideal for snacks and lunches.
Organize your kids' lunches easily with Tutete fruit box with fork!
Perfect to carry chopped fruit or small snacks separate from the rest of the lunch, this box is designed to be placed inside a larger lunch box, keeping each food in its place.
Also compatible with Rosti Midi Campus Lunch Box and fits in Tutete's Large Lunch Boxes, making it an ideal accessory to go back to school.
It includes a small fork just the right size so that children can eat fruit comfortably on their own.
Features
- Material: Polypropylene,
- BPA, phthalate and PVC free
- Fruit box dimensions: width 10.5cm x height 5cm x depth 7cm
- Fork length: 10cm
- Fork included
- The box is not airtight
- We recommend using it inside another box to prevent the lid from opening easily
- Dishwasher safe (wash in top rack at maximum 40ºC)
- Not suitable for microwaves