SELECT a.id AS id, a.name AS name, t.name AS daste, t.id AS dasteId FROM majico_kikkaboo_product AS a INNER JOIN majico_kikkaboo_product_type AS t ON t.id = a.parent WHERE a.del = 0 AND a.activation = 1 and a.parent = 3 and a.parent_sub = 10 ORDER BY a.id DESC
Carrier Hoody Beige

Carrier Hoody Beige

کالسکه کودک

Adaptor for car seat Tender

Adaptor for car seat Tender

کالسکه کودک

Baby plush blanket- Elephant

Baby plush blanket- Elephant

کالسکه کودک

Adaptor for car seat Divaina

Adaptor for car seat Divaina

کالسکه کودک

Adaptor for car seat Bali Zen

Adaptor for car seat Bali Zen

کالسکه کودک

Adaptor for car seat Dotty

Adaptor for car seat Dotty

کالسکه کودک