string(0) "" string(7365) "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.doc_1, PD.doc_2, PD.doc_3, PD.publicar, P.products_quantity, P.check_ultimas_unidades_stock, 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 = '107740' AND PD.language_id = '3' 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 "

Babi Lola con Bolsillo Central Vichy Blossom Birds Personalizable

Tutete Textil

25.50€

IVA incluido

Babi Lola con Bolsillo Central Vichy Blossom Birds Personalizable

25.50€

IVA incluido

Talla:

Línea 1:

Línea 1 obligatoria

Línea 2: * Opcional

Línea 2 obligatoria

Seleccione:

Color Bordado:

Compra antes de 14h34m con envío Premium y recíbelo máximo el 25 de junio.

Añadir Cesta

Premium antes de 14h34m

¡Tenemos los babis más cómodos y sin botones para tu peque en Tutete.com!

Fabricados especialmente para Tutete por fabricantes especializados en grandes marcas, cuentan con un bolsillito en la parte delantera con los personajes de las colecciones de Tutete Vuelta al Cole 2026 bordados.

Además puedes personalizado convirtiéndolo en un complemento único y fácilmente identificable.

Talla 1

A: Largo de cuello a puño: 35.5 cm
B: Largo total desde el cuello: 45 cm
C: Contorno de pecho: 42 cm

Talla 2

A: Largo de cuello a puño: 37 cm
B: Largo total desde el cuello: 45.5 cm
C: Contorno de pecho: 43 cm

Talla 3

A: Largo de cuello a puño: 40 cm
B: Largo total desde el cuello: 48 cm
C: Contorno de pecho: 45 cm

Talla 4

A: Largo de cuello a puño: 42 cm
B: Largo total desde el cuello: 49.5 cm
C: Contorno de pecho: 47 cm

Características

Puedes ver el esquema de medidas en la imagen simulada
Composición: 65% algodón y 35% poliéster
Se pueden lavar a máquina
Con amplio bolsillo central (19cm x 14cm)
Se borda en la parte lateral superior
Si no puedes elegir una talla, está agotada
ID: 107740

MÁS INFORMACIÓN

Ver información GPSR

Información sobre el fabricante y/o importador/distribuidor dentro de la UE, que garantiza que el producto cumple con los requisitos y regulaciones de acuerdo con la legislación sobre Seguridad General de Productos (GPSR).

Productos Infantiles Tutete S.L.
Dirección: C/ Yecla 10, Polígono industrial La Polvorista, 30500, Molina de Segura, Murcia
[email protected]