static function getNotaMediaYTotalofUserinGroup($userid, $groupid) { $grade = new Grades(); $qry = 'select avg(tmp.gradeAvg) as media, sum(tmp.gradeAvg) as total ' . 'from (select avg(g.grade) as gradeAvg ' . 'from grades g, group_inbox gr, notice n ' . 'where g.noticeid = gr.notice_id ' . 'and gr.group_id = ' . $groupid . ' and g.noticeid = n.id ' . 'and n.profile_id = ' . $userid . ' group by g.noticeid) as tmp'; $grade->query($qry); $notas = array(); if ($grade->fetch()) { $notas[$grade->total] = $grade->media; } $grade->free(); return $notas; }