Rails 3 -将多个计数转换为一个查询- OrderedHash

I've got an initializer method that does a silly thing. I need to optimize it down to one query, but my SQL skills are failing me at the moment. I've conceived of using GROUP BY and UNION and all sorts of things, but I just made myself more confused. I bequeath this to the community to shed some insight:I've got an initializer method that does a sill