Spanish
Italian
English
Portuguese
French
Toys for Children > Doll Accessories > Culla Dolls with Canopy Martina
Deliveries available in the Eurozone
The store where you will wish you were a kid
string(0) ""
string(7313) "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 = '101494' 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 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
"
string(0) ""
string(7313) "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 = '101494' 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 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
"
Make bedtime for your favorite dolls even more special with this charming canopy cradle, ideal for dolls between 30 and 46 cm.
With a white metal structure, soft pink details, and a beautiful cotton canopy, this cradle invites you to dream, care, and play. The set includes a reversible duvet and a pillow. Thanks to its practical wheels, children can easily move it during playtime.
Perfect for developing caregiving skills and imaginative play, this cradle is the ideal accessory for any doll collection.
ASÍ is a Spanish brand that creates and produces dolls and accessories rich in unique details, handmade with the best materials and an exceptional quality-price ratio.