{"body":"#standardSQL\nCREATE TEMP FUNCTION\n  hasNoctal(body STRING) AS (\n    REGEXP_CONTAINS(body, '\\\\8|\\\\9')\n  );\nWITH\n  desktopNoctal AS (\n    SELECT\n      DISTINCT page\n    FROM\n      `httparchive.latest.response_bodies_desktop`\n    WHERE\n      hasNoctal(body)\n  ),\n  mobileNoctal AS (\n    SELECT\n      DISTINCT page\n    FROM\n      `httparchive.latest.response_bodies_mobile`\n    WHERE\n      hasNoctal(body)\n  )\nSELECT\n  IFNULL(desktopNoctal.page, mobileNoctal.page) AS urlNoctal\nFROM\n  desktopNoctal\nFULL JOIN\n  mobileNoctal\nUSING\n  (page)\n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/LcAkatsE","modified":1591743245,"id":"LcAkatsE","size":535,"lines":30,"own_paste":false,"theme":"","date":1591743245}