SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `adt_category` c
INNER JOIN `adt_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `adt_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 1889
AND c.id_category IN (
SELECT id_category
FROM `adt_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
Pour machines Stihl :
SET 100
GE 450.1
GB 460.1 C
GE 250
GE 110
GE 450
GE 103.1
GE 115
GE 105.1
GB 460 C
GHE 355.0
GHE 105.0
GE 420.1
GE 150.1
GE 120
GB 460
GE 103
GHE 150.0
GH 460.0 C
GB 460.1
GE 420
GE 101
GH 460.1 C
GH 460.0
GE 105
GE 250.1