Spanish
Italian
English
Portuguese
French
string(0) ""
string(3822) "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.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,
P.products_image,
P.products_image_med,
P.products_image_lrg,
P.products_image_sm_1,
P.products_image_xl_1,
P.products_image_sm_2,
P.products_image_xl_2,
P.products_image_sm_3,
P.products_image_xl_3,
P.products_image_sm_4,
P.products_image_xl_4,
P.products_image_sm_5,
P.products_image_xl_5,
P.products_image_sm_6,
P.products_image_xl_6,
P.products_image_sm_7,
P.products_image_xl_7,
P.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,
P.products_tasks,
P.puntos,
P.sumar_personalizacion,
P.ref_catalogo,
ISNULL(fp.products_id) as disponibleFueraUE,
P.products_image_list, P.products_image_detail,
P.es_dropshipping,
P.meses_min,
P.meses_max,
0 discount,
P.es_producto_manufacturado as PERSONALIZADO
FROM products P
INNER JOIN products_description PD ON P.products_id = '1096' 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
WHERE P.products_type!='4' AND P.products_type!='8'
group by P.products_id
"
The Tutete CHERRY soother has a latex teat in the shape of a 'cherry' as its name suggests, and is similar to the shape of a mother's nipple.These were the first to appear on the market and are still a firm favourite of many mothers and babies. Each teat is equipped with a valve which allows it to immediately regain its original shape.
Tutete CHERRY has a ventilation system which allows the air to circulate between the soother and the child's face, avoiding marks and abrasions.
- 100% BPA FREE
- Shield and ring made from polypropylene and tritan.
- This soother is manufactured within the European Union and complies to the safety standard EN 1400.
- Teat: 3.1 cm in length
- Shield: approx. 4.40 cm in diameter.
Engraving your child's name on the soother makes it easily identifiable, reducing the chances of losing it as well as lowering the risk of your child being exposed to infections. Our high quality engraving does not disappear through abrasion or repeated boiling.
Don't forget: you can write a maximum of 14 characters which are distributed over two lines. Be careful when writing the name. We would like to remind you that we will not be responsible for typing or spelling errors!
