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 = 31 ORDER BY a.id DESC