$stmt = $this->connexion->query('select pseudo, message from pseudonyme p, salon s where p.id = idpseudo order by s.id desc limit 10');
    return $stmt->fetchAll();