GitHub - bensheldon/activerecord-has_some_of_many

Optimized top-N-per-group Active Record associations using lateral joins

This is the kind of query you write inefficiently just to get it done on every app.