string(0) ""
string(7312) "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 = '83557' AND PD.language_id = '4' 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
"
Succhietto BIBS Colour Round Pine Imbustato - Tutete
string(0) ""
string(7312) "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 = '83557' AND PD.language_id = '4' 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/it/83_novita/83557_succhietto-bibs-colour-round-pine-imbustato.html83557Succhietto BIBS Colour Round Pine ImbustatoSucchietto singolo in busta di plastica ermeticamente sigillata.
Disegno esclusivo e originale creato e fabbricado in Danimarca da BIBS. Succhietto sicuro in PP, senza BPA ne ftalati, ne PVC. Rispetta la normativa EN1400,testato in Danimarca dal Consumer Lab Denmark. Ha superato con successo gli ultimi tests eseguiti dal nostro Dipartimento di Qualità in Europa.
Questo tipo di succhietto di vende in Danimarca da molti decenni. Nel nord Europa apprezzano la tettarella a ciliegina rotonda in lattice e quella montata da BIBS è la famosa tettarella NG. Nel resto d'Europa va per la maggiore la tettarella anatomica o fisiologica, brevettata posteriormente ma, in questi ultimi anni, la capacità di questa marca di introdurre nella sua produzione i Pantone più di moda, unita all'aspetto robusto e opaco, ha fatto si che questi succhietti siano diventati particolarmente popolari nei social network e da qui il loro ritorno in auge.
Attenzione!
La differeza di misura tra le due taglie è minima, appena percettibile alla vista.
Per favore osserva le foto con le differenze.
Il fabbricante consiglia vivamente di cambiare il succhietto dopo 6 settimane di uso consecutivo. Il lattice (di qualsiasi marca) è un materiale naturale che si espande con l'uso. Se stai utilizzando il succhietto +6 non troverai un altro più grande in commercio e se tuo figlio si abitua ad un succhietto espanso (che può duplicare la sua misura iniziale) potrebbe rifiutare il succhietto nuovo, trovandolo nettamente più piccolo di quello che abbandona.
Caratteristiche
Tettarella: a ciliegia in caucciù naturale
100% senza BPA, PVC e ftalati
Fabbricato in Danimarca. Rispetta la rigida normativa EN1400.
Il fabbricante raccomanda di sotituire il succhietto ogni 6 settimane
Senza cappuccio di protezione
Non si possono personalizzare
Raccomandiamo sempre di NON sterilizzare nel microonde. In questo caso a maggior ragione essendo un succhietto in PP dove il lattice della tettarella contribuisce a formar parte dell'assemblaggio. Le alte temperature incontrollate potrebbero fare smontare il succhietto, rendendolo inservibile
Per una corretta sterilizzazione fai bollire l'acqua in un pentolino; a bollore spegni ed allontana dal fornello; metti in ammollo i succhietti per 2-5 minuti.
Per una scelta etica volta alla riduzione degli imballaggi, BIBS ha confezionato questo succhietto singolo in una bustina di plastica sigillata.
Misure
Tettarella +0M: lungh 25 mm x largh (parte stretta) 11 mm.
Tettarella +6-18M: lungh 30 mm x largh (parte stretta) 10 mm.
Carcassa: diametro 45 mm
https://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/6/0/0/9/9/5/600995-1200x1000.jpg5.45InStock5.4500/Chupetes Personalizados/Lisostettarella ciliegiabibsciliegia latexsucchietti bibssucchietto fashionsucchietto rotondobibs singolo imbustatoBIBS
https://www.tutete.com/tienda/product_info.php?products_id=83557&language=it83557Succhietto BIBS Colour Round Pine Imbustatohttps://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/6/0/0/9/9/5/600995-1200x1000.jpg5.45EURInStock83_novita2024-03-15bibsbibs singolo imbustatociliegia latex
Succhietto singolo in busta di plastica ermeticamente sigillata.
Disegno esclusivo e originale creato e fabbricado in Danimarca da BIBS.
Succhietto sicuro in PP, senza BPA ne ftalati, ne PVC. Rispetta la normativa EN1400, testato in Danimarca dal Consumer Lab Denmark. Ha superato con successo gli ultimi tests eseguiti dal nostro Dipartimento di Qualità in Europa.
Questo tipo di succhietto di vende in Danimarca da molti decenni. Nel nord Europa apprezzano la tettarella a ciliegina rotonda in lattice e quella montata da BIBS è la famosa tettarella NG. Nel resto d'Europa va per la maggiore la tettarella anatomica o fisiologica, brevettata posteriormente ma, in questi ultimi anni, la capacità di questa marca di introdurre nella sua produzione i Pantone più di moda, unita all'aspetto robusto e opaco, ha fatto si che questi succhietti siano diventati particolarmente popolari nei social network e da qui il loro ritorno in auge.
Attenzione!
La differeza di misura tra le due taglie è minima, appena percettibile alla vista.
Per favore osserva le foto con le differenze.
Il fabbricante consiglia vivamente di cambiare il succhietto dopo 6 settimane di uso consecutivo. Il lattice (di qualsiasi marca) è un materiale naturale che si espande con l'uso. Se stai utilizzando il succhietto +6 non troverai un altro più grande in commercio e se tuo figlio si abitua ad un succhietto espanso (che può duplicare la sua misura iniziale) potrebbe rifiutare il succhietto nuovo, trovandolo nettamente più piccolo di quello che abbandona.
Caratteristiche
Tettarella: a ciliegia in caucciù naturale
100% senza BPA, PVC e ftalati
Fabbricato in Danimarca. Rispetta la rigida normativa EN1400.
Il fabbricante raccomanda di sotituire il succhietto ogni 6 settimane
Senza cappuccio di protezione
Non si possono personalizzare
Raccomandiamo sempre di NON sterilizzare nel microonde. In questo caso a maggior ragione essendo un succhietto in PP dove il lattice della tettarella contribuisce a formar parte dell'assemblaggio. Le alte temperature incontrollate potrebbero fare smontare il succhietto, rendendolo inservibile
Per una corretta sterilizzazione fai bollire l'acqua in un pentolino; a bollore spegni ed allontana dal fornello; metti in ammollo i succhietti per 2-5 minuti.
Per una scelta etica volta alla riduzione degli imballaggi, BIBS ha confezionato questo succhietto singolo in una bustina di plastica sigillata.
Misure
Tettarella +0M: lungh 25 mm x largh (parte stretta) 11 mm.
Tettarella +6-18M: lungh 30 mm x largh (parte stretta) 10 mm.
Spagnolo
Italiano
Inglese
Portoghese
Francese
