按关联顺序排列另一个模型的数量，限制为1

I want to display a gallery of magazines that shows the newest issue for each magazine title, but ordered by the number of subscriptions on that magazine. I came up with this queryI want to display a gallery of magazines that s