combine subquery and join
return arel from the methods
convert to arel
fix indent