string(0) ""
string(7313) "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.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 = '97475' AND PD.language_id = '10' 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
"
2 chupetas BIBS Studio Colour Fusion Round Sage Hunter Green mix - Tutete
string(0) ""
string(7313) "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.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 = '97475' AND PD.language_id = '10' 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
"
https://www.tutete.com/tienda/pt/61_chupetas/102_chupetas-de-designers/97475_2-chupetas-bibs-studio-colour-fusion-round-sage-hunter-green-mix.html974752 chupetas BIBS Studio Colour Fusion Round Sage Hunter Green mix Pacote de 2 chupetas!
Design exclusivo e original criado e fabricado na Dinamarca pela BIBS. São chupetas feitas de PP, sem BPA, ftalatos ou PVC. Eles estão em conformidade com o padrão EN1400+A2 e são testados regularmente na Dinamarca pelo Consumer Lab Denmark. Além disso, eles passaram com sucesso nos últimos testes realizados pelo nosso Departamento de Qualidade na Europa.
Nos últimos anos, a capacidade da marca de fabricar essas chupetas em pantones modernos e seu plástico fosco e resistente as tornou muito populares nas redes sociais.
Atenção!
A diferença entre o tamanho 0-6M e o tamanho 6-18M é quase imperceptível aos olhos. Nos tamanhos de 0 a 6 meses, é um pouco mais curto e mais largo na parte inferior (a parte mais estreita).
A marca recomenda trocar a chupeta a cada 6 semanas, pois a borracha natural (seja qual for a marca) quando muito usada, infla e aumenta. E isso pode fazer com que a criança rejeite o mesmo tamanho ao comprar uma chupeta nova do mesmo tamanho, apesar de ser igual à que foi comprada.
Como diferenciar as diferentes tetinas BIBS?
Redondo: mamilo redondo e macio que imita o mamilo macio da mãe e promove o posicionamento da língua e uma técnica de sucção semelhante à amamentação
Simétrico: Também chamado de fisiológico. Promove uma técnica de sucção em que a língua fica plana e pressiona a chupeta contra o palato, para que o bebê não precise sugar com tanta força.
Anatômico: mamilo curvo na parte superior para um ajuste natural ao palato do bebê com uma ponta angular para facilitar a colocação da língua
Características
Eles não podem ser personalizados.
Tetina: bico redondo de borracha natural
100% livre de BPA, PVC e ftalatos
Feito na Dinamarca. Está em conformidade com a rigorosa norma EN1400+A2
O fabricante recomenda trocar a chupeta a cada 6 semanas
Não inclui capuz protetor.
Nunca recomendamos a esterilização por micro-ondas. E nesse caso, por se tratar de uma chupeta de PP e cuja montagem é feita com a mesma borracha do mamilo, altas temperaturas descontroladas podem fazer com que a chupeta se desmonte. Nossa recomendação é aquecer uma panela com água fervente, retirar do fogo e colocar na chupeta por 2 a 5 minutos.
Se você não conseguir escolher um tamanho, ele está esgotado
Medidas
Tetina 0-6M: comprimento 25mm x largura (na parte estreita) 11mm
Mamilo 6-18M: comprimento 30mm x largura (na parte estreita) 10mm
Arruela: 45 mm de diâmetro https://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/6/4/5/9/4/2/645942-1200x1000.jpg11.95InStock11.9500/Chupetes Personalizados/Chupetes con Diseñoschupetasbabadoreschupetas +0 meseschupetas redondasBibs Colourpacote BIBS com 2Bibs Hunter GreenBibs SageBibs Colour Roundchupetas +18 mesesBibs Studio Colour FusionBIBS
Envios grátis a partir de 60€ em Portugal (Continental)
Ampliamos o prazo de devoluções e incidências até o dia 12 de Janeiro de 2026.
https://www.tutete.com/tienda/pt/61_chupetas/102_chupetas-de-designers/97475_2-chupetas-bibs-studio-colour-fusion-round-sage-hunter-green-mix.html974752 chupetas BIBS Studio Colour Fusion Round Sage Hunter Green mix https://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/6/4/5/9/4/2/645942-1200x1000.jpg11.95EURInStock61_chupetas61_chupetas/102_chupetas-de-designers2025-06-04babadoresBibs ColourBibs Colour Round
Pacote de 2 chupetas!
Design exclusivo e original criado e fabricado na Dinamarca pela BIBS. São chupetas feitas de PP, sem BPA, ftalatos ou PVC. Eles estão em conformidade com o padrão EN1400+A2 e são testados regularmente na Dinamarca pelo Consumer Lab Denmark. Além disso, eles passaram com sucesso nos últimos testes realizados pelo nosso Departamento de Qualidade na Europa
.
Nos últimos anos, a capacidade da marca de fabricar essas chupetas em pantones modernos e seu plástico fosco e resistente as tornou muito populares nas redes sociais.
Atenção!
A diferença entre o tamanho 0-6M e o tamanho 6-18M é quase imperceptível aos olhos. Nos tamanhos de 0 a 6 meses, é um pouco mais curto e mais largo na parte inferior (a parte mais estreita
).
A marca recomenda trocar a chupeta a cada 6 semanas, pois a borracha natural (seja qual for a marca) quando muito usada, infla e aumenta. E isso pode fazer com que a criança rejeite o mesmo tamanho ao comprar uma chupeta nova do mesmo tamanho, apesar de ser igual à que foi
comprada
.
Como diferenciar as diferentes tetinas BIBS?
Redondo: mamilo redondo e macio que imita o mamilo macio da mãe e promove o posicionamento da língua e uma técnica de sucção semelhante à amamentação
Simétrico: Também chamado de fisiológico. Promove uma técnica de sucção em que a língua fica plana e pressiona a chupeta contra o palato, para que o bebê não precise sugar com tanta
força.
Anatômico: mamilo curvo na parte superior para um ajuste natural ao palato do bebê com uma ponta angular para facilitar a colocação da língua
Características
Eles não podem ser personalizados.
Tetina: bico redondo de borracha natural
100% livre de BPA, PVC e ftalatos
Feito na Dinamarca. Está em conformidade com a rigorosa norma EN1400+A2
O fabricante recomenda trocar a chupeta a cada 6 semanas
Não inclui capuz protetor.
Nunca recomendamos a esterilização por micro-ondas. E nesse caso, por se tratar de uma chupeta de PP e cuja montagem é feita com a mesma borracha do mamilo, altas temperaturas descontroladas podem fazer com que a chupeta se desmonte. Nossa recomendação é aquecer uma panela com água fervente, retirar do fogo e colocar na chupeta por 2 a 5 minutos
.
Se você não conseguir escolher um tamanho, ele está esgotado
Medidas
Tetina 0-6M: comprimento 25mm x largura (na parte estreita) 11mm
Mamilo 6-18M: comprimento 30mm x largura (na parte estreita) 10mm
Espanhol
Italiano
Inglês
Português
Francês
