{"body":"SELECT\n  normalized_channel AS channel,\n  DATE(submission_timestamp) AS date,\n  SUM(COALESCE(SAFE_CAST(JSON_EXTRACT_SCALAR(payload.histograms.use_counter2_deprecated_math_ml_deprecated_line_thickness_value_document, '$.sum') AS INT64), 0)) AS total_main_process_counts,\n  SUM(COALESCE(SAFE_CAST(JSON_EXTRACT_SCALAR(payload.processes.content.histograms.use_counter2_deprecated_math_ml_deprecated_line_thickness_value_document, '$.sum') AS INT64), 0)) AS total_content_process_counts,\n  SUM(payload.processes.content.scalars.mathml_doc_count) AS total_doc_count\nFROM\n  telemetry.main\nWHERE\n  DATE(submission_timestamp) >= \"2019-08-23\"\nGROUP BY\n  channel,\n  date","name":"query","extension":"txt","url":"https://www.irccloud.com/pastebin/wmqXNzdg/query","modified":1566831613,"id":"wmqXNzdg","size":659,"lines":13,"own_paste":false,"theme":"","date":1566831613}