FUNCTION getRanking($rank_id, $round_id, $group_id) {
        $query = 'select a.*, d.* from #__Joomra_Team_Extended a';
        $query .= ' inner join #__Joomra_Team_Group b on b.team_id=a.id';
        $query .= ' left join #__Joomra_Team_total_data d on d.id=a.id';
        $query .= ' where a.rank_id='.$rank_id.' and b.round_id='.$round_id;
        $query .= ' and  b.group_id='.$group_id;
        $query .= ' group by a.id';
        $query .= ' order by pts desc, sets - lostsets desc, gg - gp desc';