# Pastebin huI3EcJU
SELECT rank, cumulative_views, page_title, views
FROM (
  SELECT ROW_NUMBER() OVER(ORDER BY views DESC) AS rank,
  page_title, views,
  SUM(views) OVER(ORDER BY views DESC) AS cumulative_views
  FROM (
    SELECT page_title, SUM(view_count) AS views
    FROM wmf.pageview_hourly
    WHERE year = 2017 AND month = 1 AND day = 31 AND hour = 0
       AND project = 'es.wikipedia'
       AND agent_type = 'user'
    GROUP BY page_title
    ORDER BY views DESC
    LIMIT 100000000) AS pagelist
    ) AS pagelist_with_cumulative_views
WHERE PMOD (rank, 10000) = 0