sql = "…"

Kaminari.paginate_array(Product.find_by_sql(sql)).page(params[:page]).per(20)