Create Query of Newest Helix Pages-Powered Websites

[trieloff]

SELECT * FROM (
  SELECT 
    CONCAT('https://', req_http_X_Repo, '-', req_http_X_Owner, '.hlx.page/' ) AS url,
    req_http_X_Owner AS owner, 
    req_http_X_Repo AS repo, 
    COUNT(time_start_usec) AS requests, 
    TIMESTAMP_MICROS(CAST(MIN(time_start_usec) AS INT64)) AS start
  FROM `helix-225321.helix_logging_1McGRQOYFuABWBHyD8D4Ux.requests*`
  GROUP BY req_http_X_Repo, req_http_X_Owner 
)
WHERE 
  requests > 100 AND
  owner != '(null)'
ORDER BY start DESC
LIMIT 100

could be a start, but adding parameters for the date range and the number of sites returned would be nice.