public static function getPersonsComments($id) { $data = array(); $sql = ' SELECT {{tree}}.* FROM {{tree}} INNER JOIN ({{data}} INNER JOIN {{relations}} ON {{relations}}.id1={{data}}.id ) ON {{data}}.tree={{tree}}.id WHERE {{relations}}.modul1=\'data\' AND {{relations}}.id2=' . $id . ' AND {{relations}}.modul2=\'tree\' AND {{data}}.path=\'newscom\' ORDER BY num '; $list = DB::getAll($sql); foreach ($list as $item) { $fields = Fields::getFieldsByTree($item['id']); $item['preview'] = $fields['preview']; $item['person'] = Persons::getOne($item['parent']); $data[] = $item; } return $data; }