3 ms·Ben Nadel: Using Lateral Joins to Get “Top N” Records from Each Group in MySQL 82 points by rmason 4y ago