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'