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 = '69430' AND PD.language_id = '3' 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
                
       "

Juguetes para Niños > Peluches > Peluche Bunny Rock-a-Bye

Peluche Bunny Rock-a-Bye

Jellycat

32.00€

32.00€

Compra antes de 2h9m con envío Premium y recíbelo máximo el 27 de septiembre.

Añadir Cesta

Premium antes de 2h9m

Este adorable conejito durmiente en su canastilla beige será el perfecto amiguito para los peques, acompañándolos en sus sueños y aventuras. El conejito se puede sacar de la canastilla.

Características

Composición: 100% poliéster
Medidas: 19 x 9 cm
A partir de 0 meses

(*) Este producto incluye marcado CE de conformidad con la legislación de la Unión Europea

MÁS INFORMACIÓN