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'