Bugzilla

```
SELECT event_object,
       event_method,
       event_string_value,
       app_version,
       normalized_channel,
       TO_JSON_STRING(event_map_values),
       event_process,
       count(*) AS count_reports,
       count(distinct client_id) as count_distinct_clients
FROM telemetry.events
WHERE event_category = 'security'
  AND event_method = 'javascriptLoad'
  AND submission_date >= '2022-01-1'
  AND (
    --(normalized_channel = 'release' and app_version > '98') or
    (normalized_channel = 'beta' and app_version = '100.0') or
    (normalized_channel = 'nightly' and app_version = '101.0a1')
    )
GROUP BY event_method,
         event_object,
         event_string_value,
         app_version,
         normalized_channel,
         TO_JSON_STRING(event_map_values),
         event_process
ORDER BY app_version desc, normalized_channel, event_string_value
```

Telemetry shows `prefcalls.js` showing up in Beta (as well as http:// and https:// schemes (and one chrome:// scheme??)

I had hoped that Bug 1759887 might have fixed this (I know it fixed one very unusual corner case) but it seems we are back at the drawing board for how in the world prefcalls.js can show up.  I'll update this bug with my understanding of why this should never happen....

```
SELECT event_object,
       event_method,
       event_string_value,
       app_version,
       normalized_channel,
       TO_JSON_STRING(event_map_values),
       event_process,
       count(*) AS count_reports,
       count(distinct client_id) as count_distinct_clients
FROM telemetry.events
WHERE event_category = 'security'
  AND event_method = 'javascriptLoad'
  AND submission_date >= '2022-01-1'
  AND (
    --(normalized_channel = 'release' and app_version > '98') or
    (normalized_channel = 'beta' and mozfun.norm.extract_version(app_version, 'major') = 100) or
    (normalized_channel = 'nightly' and app_version = '101.0a1')
    )
GROUP BY event_method,
         event_object,
         event_string_value,
         app_version,
         normalized_channel,
         TO_JSON_STRING(event_map_values),
         event_process
ORDER BY app_version desc, normalized_channel, event_string_value
```

Telemetry shows `prefcalls.js` showing up in Beta (as well as http:// and https:// schemes (and one chrome:// scheme??)

I had hoped that Bug 1759887 might have fixed this (I know it fixed one very unusual corner case) but it seems we are back at the drawing board for how in the world prefcalls.js can show up.  I'll update this bug with my understanding of why this should never happen....