never_do_this.rb

  def self.with_info(current_user, return_only_this_user = false)
    sum = "SUM(CASE space_users.user_id WHEN #{current_user.id} THEN 1 ELSE 0 END)"
    q = left_outer_joins(:space_users).distinct.select("spaces.*, COUNT(space_users.*) AS space_users_count, #{sum} AS current_user_is_in_space, space_users.created_at AS joined_at").group('spaces.id, space_users.id')
    if return_only_this_user
      q.having("#{sum} = 1")
    else
      q
    end
  end