{"body":"#standardSQL\nCREATE TEMP FUNCTION\n  searcher(body STRING, builtin STRING) AS (\n    REGEXP_CONTAINS(body, CONCAT(\n      '\\\\.__proto__\\\\s*=\\\\s*', builtin,\n      '|extends\\\\s+', builtin,\n      '|.prototype\\\\s*=\\\\s*new\\\\s+', builtin,\n      '|extends?\\\\((\\\\s*[^\\\\),]\\\\s*,\\\\s*)*\\\\s*', builtin,\n      '|\\\\.setPrototypeOf\\\\((\\\\s*[^\\\\),]\\\\s*,\\\\s*){1}\\\\s*', builtin\n    ))\n  );\nCREATE TEMP FUNCTION\n  extendsPromise(body STRING) AS (\n    searcher(body, 'Promise')\n  );\nCREATE TEMP FUNCTION\n  extendsRegExp(body STRING) AS (\n    searcher(body, 'RegExp')\n  );\nCREATE TEMP FUNCTION\n  extendsArray(body STRING) AS (\n    searcher(body, 'Array')\n  );\nCREATE TEMP FUNCTION\n  extendsTypedArray(body STRING) AS (\n    searcher(body, 'Int8Array') OR\n    searcher(body, 'Uint8Array') OR\n    searcher(body, 'Uint8ClampedArray') OR\n    searcher(body, 'Int16Array') OR\n    searcher(body, 'Uint16Array') OR\n    searcher(body, 'Int32Array') OR\n    searcher(body, 'Uint32Array') OR\n    searcher(body, 'Float32Array') OR\n    searcher(body, 'Float64Array')\n  );\nWITH\n  desktopPromise AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_desktop`\n  WHERE\n    extendsPromise(body)),\n  mobilePromise AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_mobile`\n  WHERE\n    extendsPromise(body)),\n  desktopArray AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_desktop`\n  WHERE\n    extendsArray(body)),\n  mobileArray AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_mobile`\n  WHERE\n    extendsArray(body)),\n  desktopRegExp AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_desktop`\n  WHERE\n    extendsRegEXP(body)),\n  mobileRegExp AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_mobile`\n  WHERE\n    extendsRegEXP(body)),\n  desktopTypedArray AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_desktop`\n  WHERE\n    extendsTypedArray(body)),\n  mobileTypedArray AS (\n  SELECT\n    DISTINCT page\n  FROM\n    `httparchive.latest.response_bodies_mobile`\n  WHERE\n    extendsTypedArray(body))\nSELECT\n  IFNULL(desktopArray.page,\n    mobileArray.page) AS urlArray,\n  IFNULL(desktopPromise.page,\n    mobilePromise.page) AS urlPromise,\n  IFNULL(desktopRegExp.page,\n    mobileRegExp.page) AS urlRegExp,\n  IFNULL(desktopTypedArray.page,\n    mobileTypedArray.page) AS urlTypedArray,\nFROM\n  desktopArray\nFULL JOIN\n  mobileArray\nUSING\n  (page)\nFULL JOIN\n  desktopPromise\nUSING\n  (page)\nFULL JOIN\n  mobilePromise\nUSING\n  (page)\nFULL JOIN\n  desktopRegExp\nUSING\n  (page)\nFULL JOIN\n  mobileRegExp\nUSING\n  (page)\nFULL JOIN\n  desktopTypedArray\nUSING\n  (page)\nFULL JOIN\n  mobileTypedArray\nUSING\n  (page)","name":"dont_run_this","extension":"txt","url":"https://www.irccloud.com/pastebin/Oyd05gui/dont_run_this","modified":1590105861,"id":"Oyd05gui","size":2742,"lines":131,"own_paste":false,"theme":"","date":1590105861}