string(0) ""
string(7315) "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.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 = '97926' 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 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
                
       "

Juguetes para Niños > Juguetes Niños 3 Años > Altavoz Bluetooth y Karaoke Lemon

Altavoz Bluetooth y Karaoke Lemon

Konges Slojd

67.45€

IVA incluido

67.45€

IVA incluido

Compra antes de 1h42m con envío Premium y recíbelo máximo el 1 de julio.

Añadir Cesta

Premium antes de 1h42m

• konges slojd
• Konges Slojd Lemon
• Altavoz
• Micrófono
• Karaoke
• Karaoke Konges Slojd

Canta y diviértete con el karaoke de la colección Lemon de Konges Slojd. Se conecta por Bluetooth para reproducir tus canciones favoritas y dejar que los peques brillen como verdaderas estrellas. Ideal para momentos de diversión en familia.

Los diseños de Konges Slojd son atemporales con estampados únicos en tonos suaves, siempre pensados para la mayor comodidad y funcionalidad de los peques.

Características

• Material: ABS, PU, hierro
• Medidas Packaging: 17 x 16 x 7 cm
• Medida micrófono: 13 cm alto
• 1200mAh 5V
• Incluye ranura micro SD
• Incluye micrófono y altavoz con conexión Bluetooth
• Altavoz con asa
• A partir de 3 años

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

MÁS INFORMACIÓN