def index
    data_request = Requests::GetTabledataRequest.new(search_table_params)
    data_request.validate!

    # own events
    own_events = Event.select(:id).where('user_id = ? OR organizer_id = ?', user.id, user.id).to_sql
    # events participated by user
    participated_events = Participation.events.select(:participationable_id).where(user_id: user.id).to_sql

    relations = [own_events, participated_events]
    sql = "SELECT * FROM public.events where id IN (#{relations.join(') OR id IN (')})"

    @events = Event.paginate_by_sql(sql, page: data_request.page, per_page: data_request.per_page)
    puts @events
    puts Event.all

    respond_to do |format|
      format.json
      format.csv { send_data Event.find_by_sql(sql).to_csv, filename: "lists-#{Time.zone.today}.csv" }
    end
  end