string(0) ""
string(3823) "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 = '19265' 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
                
       "

3 CANPOL SPRING GIRL D/N
Trustpilot

11.95€

Teat+ Info

Font

Classic-style

Amatic

Mountains

Olivia

Original

Sofía

Teat Protector

Personalise your soother

Colours (Please choose a teat first)

Line 1

Line 2

Line 3

Colours (Please choose a teat first)

Line 1

Line 2

Line 3

Colours (Please choose a teat first)

Line 1

Line 2

Line 3

11.95€

Add to cart

In stock

Canpol Day/Night Soothers glow in the dark!

The centre button of the soother glows so you can find it easily in the dark without having to switch on the light.

The transparent soother does NOT glow in the dark.

The design and shape of the soother allows air to circulate which drastically reduces rashes and skin irritation. It also has small holes for ventilation, making it more comfortable for baby.

See teats available to the right of the screen.
Made in the EU from safe materials (100% BPA free).
Complies with EU safety standard EN1400.
Before using, we recommend you "charge up" your soother by placing it under a strong light (artificial or natural) so that it will glow strongly in the dark!
We advise the silicone teats should be regularly checked once the child starts teething.

Engraving

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.

Write your child's name however you like in the box above!

Don't forget: you can write a maximum of 30 characters which are distributed in 10 characters over three lines. Be careful when writing the name. We would like to remind you that we will not be responsible for typing or spelling errors!

MORE INFORMATION

3 CANPOL SPRING GIRL D/N Trustpilot

11.95€

11.95€

3 CANPOL SPRING GIRL D/N
Trustpilot