如何使用纯activerecord (rails)执行此sql

I can't figure out how to manage this purely with active record. I understand it doesn't handle outer joins...I can't figure out how to manage this purely wi