Nils Drescher

SELECT t1.name AS level1       t2.name AS level2       t3.name AS level3       t4.name AS level4FROM       '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';