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

3 CHUPETES PERSONALIZADOS LOVI HIELO

13.45€

IVA incluido

Tetina+ Info

 

- Seleccione Tetina -Fisiologica Silicona +6MFisiologica Silicona +0M

Tipografía

 Clásica

 Amatic

 Mountains

 Olivia

 Original

 Sofía

Capucha

1 Capucha (+0.50€) 3 Capuchas (+0.99€) Sin capuchas

Personaliza tu chupete

Colores (18 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

Colores (18 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

Colores (18 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

13.45€

IVA incluido

Compra antes de 9h18m con envío Premium y recíbelo máximo el 30 de junio.

Añadir Cesta

Premium antes de 9h18m

• chupetes
• chupetes personalizados
• lovi
• chupete lovi personalizado

Personaliza los 3 chupetes escribiendo en cada uno lo que deseas!
Este pack admite solo texto, sin dibujos.

Chupetes Personalizados LOVI – succión saludable desde el primer día.

El chupete personalizado dinámico LOVI ha sido diseñado por especialistas en neurologopedia para fomentar la succión saludable.

Tetina patentada con forma dinámica y exclusiva que:

• Permite respirar y tragar saliva fácilmente.
• Evita el reflejo de morder el chupete.
• Favorece el desarrollo correcto del habla y del encaje de los maxilares (siguiendo las recomendaciones de especialistas en ortodoncia y logopedia).

Confirmado por estudios médicos: El chupete personalizado dinámico LOVI fomenta la succión saludable.

Características

• LA ANILLA DE LOS CHUPETES N/D (NOCHE/DÍA) BRILLA EN LA OSCURIDAD.
• 100% BPA FREE.
• Arandela y anilla de tritan.
• Sin capucha de protección. Si las deseas, puedes añadirlas marcando la opción que corresponde.
  
• Producto Europeo. Cumple con la normativa EN1400.
• Tutete aconseja: Las tetinas de silicona hay que revisarlas a menudo cuando los niños tienen dientes.

Medidas

• Tetina +0M: 2.6 cm x 1.7 cm.
• Tetina +6M: 3.0 cm x 2.0 cm.
• Arandela aprox.: 5.8 cm x 3.8 cm.

Grabado

Grabar el nombre del niño en este chupete facilita la identificación del mismo disminuyendo la posibilidad de su pérdida y los posibles riesgos de infecciones de tu hijo. El grabado de alta calidad de los chupetes personalizados Tutete no desaparece ni con roces ni esterilizando el chupete una y otra vez.

Recuerda: puedes grabar EN CADA chupete un texto de hasta máximo 30 caracteres distribuidos en tres líneas. ATENCIÓN! en este pack puedes escribir SOLO TEXTO: puedes usar los caracteres presentes en el teclado. Ten mucho cuidado al escribir el nombre, te recordamos que Tutete no se hace responsable de posibles faltas de mecanografía y ortografía.

MÁS INFORMACIÓN