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 = 80 ORDER BY a.id DESC
Stroller for twins Happy 2 2020 Beige

Stroller for twins Happy 2 2020 Beige

کالسکه کودک

Stroller for twins Happy 2 2020 Black

Stroller for twins Happy 2 2020 Black

کالسکه کودک

Stroller for twins Happy 2 2020 Light Grey

Stroller for twins Happy 2 2020 Light Grey

کالسکه کودک

Stroller for twins Happy 2 2020 Dark Grey

Stroller for twins Happy 2 2020 Dark Grey

کالسکه کودک