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 = '88738' 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
                
       "

Vuelta al cole > Colecciones Vuelta al Cole > Mochila Mediana Funny Letters

Mochila Mediana Funny Letters

Tutete

39.95€

IVA incluido

39.95€

IVA incluido

Compra antes de 14h0m con envío Premium y recíbelo máximo el 1 de julio.

Añadir Cesta

Premium antes de 14h0m

• mochilas
• Mochilas Tutete
• Mochilas Personalizadas
• Mochilas niños 6-9 años
• mochilas escolares
• Mochilas Medianas Tutete
• Tutete Vuelta al Cole 2025
• Colección Tutete Funny Letters
• Mochilas Tutete 2025
• Mochilas 2025
• Mochilas Medianas 2025

Mochila Escolar Mediana Personalizable de la Colección Vuelta al Cole Funny Letters de Tutete que puedes personalizar con el llavero personalizable que incluyen de regalo.

¡Diversión, comodidad y sostenibilidad en una mochila única!
Con un diseño alegre y lleno de letras de colores, la mochila mediana Tutete de la colección Funny Letters es ideal para acompañar a tu peque en su día a día escolar. Pensada para niños de primaria, combina funcionalidad, ergonomía y sostenibilidad.

Ventajas de la mochila mediana Tutete

• Las mochilas medianas de las nuevas Colecciones Vuelta al Cole 2025 ofrecen un tamaño superior a las del año pasado, ofreciendo más espacio sin perder comodidad
• Fabricada con 100% RPET, un material reciclado que ayuda a reducir residuos plásticos
• Tamaño perfecto para primaria: cabe una carpeta tamaño A4 o cuadernos grandes
• Compartimento principal espacioso con bolsillo interior abierto
• Bolsillo frontal grande con separadores, ideal para lápices, pequeños objetos o cubiertos
• Bolsillo lateral con malla reforzada para botella (compatible con botellas Tutete de plástico o acero sin funda).
• Exterior impermeable, perfecta para cualquier estación
• Lavable a máquina en frío (30ºC). No centrifugar
• Recomendada para niños y niñas entre 5 y 10 años

Completa la colección Funny Letters haciendo clic AQUÍ

Características

• Incluye llavero personalizable de la coleccion Funny Letters, para que puedas personalizar tu mochila
• Composicion: 100% RPET (plástico reciclado)
• Cabe una carpeta estándar de aproximadamente alto 30cm x ancho 25cm o libreta A4 
• Medidas: 38 cm alto x 27 cm ancho x 12.5 cm profundidad
• Bolsillo exterior frontal curvado con cierre de cremallera(29 cm alto x 23 cm ancho)
• Cierre en clip en el pecho
• Compartimento principal con cierre de cremallera bidireccional
• Bolsillo lateral de malla reforzada para colocar botella de agua
• Tiradores de silicona en las cremalleras de las colecciones Tutete Vuelta al Cole 2025
• Bolsillo interior abierto
• Respaldo acolchado con espuma, que permite llevarla durante períodos largos de tiempo sin causar molestias
• Asas especialmente reforzadas y ajustables, que proporcionan gran soporte y comodidad
• Exterior impermeable
• Para niños entre 5 y 10 años
• Apta para lavadora en frío(30ºC), no centrifugar

MÁS INFORMACIÓN