Rails Where子句PG :: SyntaxError：错误：子查询必须只返回一列

I want to take advantage of rails scoping with a custom sql query. You can click this post for I'm trying to do - especially in ActiveAdmin. I want to take advantage of rails scoping with