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 = 5 and a.parent_sub = 100
ORDER BY a.id DESC
