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 = '67865' 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 "
Moda infantil > Disfraces para niños > Corona de Terciopelo Blush
https://www.tutete.com/tienda/es/84_moda-infantil/136_disfraces-para-ninos/67865_corona-de-terciopelo-blush.html
67865
Corona de Terciopelo Blush
https://www.tutete.com/tienda/images/5575761669032087-LG.jpg
10
EUR
InStock
94_ofertas
2022-11-18
corona
Disfraces
Mimi&Lula
Preciosa corona de terciopelo reversible en tono rosado con brillantitos formando una estrella, se agarra con una bonita cinta de raso del mismo color. Un complemento ideal para cualquier disfraz, para un regalo ó para completar cualquier look de fantasía.
Mimi&Lula es una marca de complementos infantiles para dar un rayo de luz y alegría al estilismo diario de tu pequeño.
Características
- Medidas aprox: 9,5 cm de alto x 32 cm de ancho
- Limpiar con un paño
- A partir de 3 años