ActiveRecordStatement.rb

Marketer.find(Marketer.joins("LEFT JOIN users ON users.id = #{session[:user_id].to_s}", "LEFT JOIN keywords_and_users ON keywords_and_users.user_id = users.id", "LEFT JOIN matchings ON matchings.user_id = users.id AND matchings.marketer_id = marketers.id", "LEFT JOIN marketers_and_keywords ON marketers_and_keywords.marketer_id = marketers.id").where(display: [2, 3], id: MarketersAndKeyword.where(keyword_id: Keyword.find(KeywordsAndUser.where(user_id: session[:user_id]).pluck(:keyword_id))).pluck(:marketer_id)).order("CASE WHEN matchings.id is null THEN marketers.cpm * keywords_and_users.score ELSE marketers.cpm * (keywords_and_users.score / 4) END DESC").pluck(:id).uniq).first