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 = '17862' 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 CLASSIC CHICLE

12.95€

IVA incluido

Tetina+ Info

 

- Seleccione Tetina -Anatomica Silicona +6MAnatomica Latex +6MAnatomica Latex +0MAnatomica 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 (19 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

Colores (19 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

Colores (19 colores disponibles)

Colores (Primero debes seleccionar una tetina)

Linea 1

Linea 2

Linea 3

12.95€

IVA incluido

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

Añadir Cesta

Premium antes de 9h19m

• chupetes
• chupetes personalizados
• tutete classic

Personaliza los 3 chupetes escribiendo en cada uno lo que deseas.
Este pack admite SOLO TEXTO, sin dibujos.
 
¿Quieres 3 chupetes distintos con texto + dibujo? puedes crearlos pinchando AQUÍ.

Los chupetes personalizados Tutete CLASSIC están equipados con tetina patentada NGermany, sinónimo de alta calidad y de una experiencia de más de 30 años.

Todas las tetinas disponen de una válvula que les permite recuperar inmediatamente su forma original.

La arandela del chupete Tutete CLASSIC cuenta con un sistema de ventilación, que permite que el aire circule entre el chupete y la cara del bebé, evitando marcas y rozaduras.

Características

• 100% BPA FREE
• Anilla y arandela: tritán.
• Botón central: polipropileno.
• 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.
• ATENCIÓN: el color perla o metalizado, con efecto nacarado presenta estrías de color más intenso en algunas partes del chupete, en especial cerca de los aros. Esto no es un defecto del chupete sino una característica del color nacarado o metalizado.

Medidas

• Tetina +0M: 2.6 cm x 1.7 cm.
  
• Tetina +6M: 2.9 cm x 2.0 cm.
• Arandela aprox.: 3.5 cm x 5 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 máximo 30 caracteres distribuidos en tres líneas. ATENCIÓN: este pack admite 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