Vermischtes

SELECT t1.name As lev1, t2.name AS lev2, t3.name AS lev3, t4.name AS lev4FROM parentmodell AS t1LEFT JOIN parentmodell AS t2 ON t2.ParentID = t1.KindIDLEFT JOIN parentmodell AS t3 ON t3.ParentID = t2.KindIDLEFT JOIN parentmodell AS t4 ON t4.ParentID = t3.KindIDWHERE t1.name = 'Magazin'