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 = '58865' 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
"
Pack 2 Succhietti BIBS Boheme Dark Oak/Blush - 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 = '58865' 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/61_succhietti/102_succhietti-grandi-marche/58865_pack-2-succhietti-bibs-boheme-dark-oakblush.html58865Pack 2 Succhietti BIBS Boheme Dark Oak/BlushPack da 2 succhietti Boheme!
Con la sua silhouette romantica e artistica, BIBS Boheme si ispira al moderno stile bohémien che combina elementi naturali come legno, rattan e macramè con motivi artistici, eccentrici che rendono questo nuovo design fresco e creativo.
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.
Misure
Tettarella +0M: lungh 25 mm circa
Tettarella +6-18M: lungh 30 mm circa
Carcassa: diametro 45 mm
https://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/5/3/6/0/1/6/536016-1200x1000.jpg4InStock11.957.9567/Bañeras Bebé/Ofertas/Chupetes Personalizados/Chupetes con Diseños/Black Friday/Bañeras Bebé/Rebajastettarella ciliegiabibsciliegia latexpack 2 bibssucchietti bibssucchietto fashionsucchietto rotondobibs bohemeBIBS
https://www.tutete.com/tienda/it/61_succhietti/102_succhietti-grandi-marche/58865_pack-2-succhietti-bibs-boheme-dark-oakblush.html58865Pack 2 Succhietti BIBS Boheme Dark Oak/Blushhttps://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/5/3/6/0/1/6/536016-1200x1000.jpg4EURInStock61_succhietti61_succhietti/102_succhietti-grandi-marche2021-12-13bibsbibs bohemeciliegia latex
Pack da 2 succhietti Boheme!
Con la sua silhouette romantica e artistica, BIBS Boheme si ispira al moderno stile bohémien che combina elementi naturali come legno, rattan e macramè con motivi artistici, eccentrici che rendono questo nuovo design fresco e creativo.
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.