# Pastebin LcAkatsE
#standardSQL
CREATE TEMP FUNCTION
  hasNoctal(body STRING) AS (
    REGEXP_CONTAINS(body, '\\8|\\9')
  );
WITH
  desktopNoctal AS (
    SELECT
      DISTINCT page
    FROM
      `httparchive.latest.response_bodies_desktop`
    WHERE
      hasNoctal(body)
  ),
  mobileNoctal AS (
    SELECT
      DISTINCT page
    FROM
      `httparchive.latest.response_bodies_mobile`
    WHERE
      hasNoctal(body)
  )
SELECT
  IFNULL(desktopNoctal.page, mobileNoctal.page) AS urlNoctal
FROM
  desktopNoctal
FULL JOIN
  mobileNoctal
USING
  (page)