: SELECT m.id,
m.level,
CASE
WHEN m.level=1 THEN m.id
WHEN m2.level=1 THEN m2.id
WHEN m3.level=1 THEN m3.id
WHEN m4.level=1 THEN m4.id
WHEN m5.level=1 THEN m5.id
END as racine
FROM zkold_menu m
LEFT JOIN zkold_menu m2 ON m.parent_id=m2.id AND m2.id!=1
LEFT JOIN zkold_menu m3 ON m2.parent_id=m3.id AND m3.id!=1
LEFT JOIN zkold_menu m4 ON m3.parent_id=m4.id AND m4.id!=1
LEFT JOIN zkold_menu m5 ON m4.parent_id=m5.id AND m5.id!=1
WHERe m.path LIKE 'agenda-du-jardin/19-visite-guidee-histoires-de-plantes-menacees?date=2017-08-16-11-00&iccaldate=1913-03-1'