Skip to content
  • EXT Anthony Geourjon's avatar
    Merge branch... · 25a687eb
    EXT Anthony Geourjon authored
    Merge branch '473-ameliorer-l-affichage-de-l-icone-nouvelles-annotations-dans-la-page-de-choix-des-rapports-2' into 499-faire-le-calcul-du-nombre-d-annotations-lues-dans-le-tableau-de-bord-a-partir-de-la-table
    
    SELECT id_annotation, COUNT(id_user) AS nbReading
    FROM `link_annotation_learner` RIGHT JOIN annotation USING (id_annotation)
    WHERE id_report = 8
    GROUP by id_annotation
    25a687eb