具有has_many关联的rails中的named_scope

I am trying to achieve what I think will be a fairly complex query using the magic of Rails without having lots of ugly looking SQL in the code.I am trying to achieve what I think will be a f