public function countDesc()
{
$sth = ServiceDb::getInstance()->prepare('
select `action`.*
,`user`.*
,count(*) as `nb`
from `action`
left join `user`
on `user`.`id`=`action`.`user_id`
group by `action`.`user_id`
order by `nb` desc');
$sth->execute();
$arr = array();
foreach ($sth->fetchAll() as $data) {
$a = new ModelUser();
$a->hydrate($data);
$b = new ModelAction();
$b->hydrate($data);
$b->setUser($a);
$arr[] = array($b, $data['nb']);
}
return $arr;
}
