fix: use MAX() instead of group by to avoid line duplications

fix: use MAX() instead of group by to avoid line duplications #73