[subcategories] Forum Topics

Hello every one I need help help with tihs code, it works but is there an easy way to generate articles by categories and subcategories if($result = GetList("SELECT p.*,f.*,c1.* FROM ".DB_PREFIX."mediaCategory c1 LEFT JOIN ".DB_PREFIX."mediaCategory c2 ON c2.category_id=c1.category_parent LEFT JOIN ".DB_PREFIX."mediaCategory c3 ON c3.category_id=c2.category_parent LEFT JOIN ".DB_PREFIX."mediaCategory c4 ON c4.category_id=c3.category_parent …