Untitled

{
  "size": 0,
  "timeout": "60000ms",
  "query": {
    "constant_score": {
      "filter": {
        "bool": {
          "must": [
            {
              "range": {
                "t": {
                  "from": 1598886000000,
                  "to": 1693493999999,
                  "include_lower": true,
                  "include_upper": true
                }
              }
            },
            {
              "bool": {
                "must": [
                  {
                    "bool": {
                      "must_not": {
                        "bool": {
                          "should": {
                            "bool": {
                              "must_not": {
                                "exists": {
                                  "field": "n.s.pM"
                                }
                              }
                            }
                          }
                        }
                      }
                    }
                  },
                  {
                    "bool": {
                      "should": [
                        {
                          "bool": {
                            "must": {
                              "spr_query_string": {
                                "query": "\"、\"",
                                "fields": [
                                  "add.t^25.0",
                                  "add.qsM",
                                  "m"
                                ],
                                "extra_analyzer_per_field": {
                                  "add.t": "unknown",
                                  "add.qsM": "unknown",
                                  "m": "unknown"
                                }
                              }
                            }
                          }
                        },
                        {
                          "bool": {
                            "must": {
                              "spr_query_string": {
                                "query": "\"。\"",
                                "fields": [
                                  "add.t^25.0",
                                  "add.qsM",
                                  "m"
                                ],
                                "extra_analyzer_per_field": {
                                  "add.t": "unknown",
                                  "add.qsM": "unknown",
                                  "m": "unknown"
                                }
                              }
                            }
                          }
                        }
                      ],
                      "_cache_key": "1ac6f7ae9d659b0540d22ee58103b0cf"
                    }
                  },
                  {
                    "terms": {
                      "l.c": [
                        "JP"
                      ]
                    }
                  },
                  {
                    "terms": {
                      "ln": [
                        "ja"
                      ]
                    }
                  },
                  {
                    "bool": {
                      "should": {
                        "prefix": {
                          "_index": "t"
                        }
                      }
                    }
                  },
                  {
                    "bool": {
                      "must_not": {
                        "term": {
                          "n.pE.pT": 4
                        }
                      },
                      "_cache_key": "23f1b56f745345fcbed91deaf46f55b8"
                    }
                  },
                  {
                    "bool": {
                      "must_not": {
                        "term": {
                          "iPo": true
                        }
                      },
                      "_cache_key": "b56b36fb0aff446566e6a77948b7f0c0"
                    }
                  },
                  {
                    "bool": {
                      "must_not": {
                        "bool": {
                          "must": [
                            {
                              "term": {
                                "mTp": 115
                              }
                            },
                            {
                              "term": {
                                "mSTp": 257
                              }
                            }
                          ],
                          "_cache_key": "8835f2bd6a96a787b5ba0e154f27a5d6"
                        }
                      },
                      "_cache_key": "0611a0c94da1a720a5b4b8dc9ad75913"
                    }
                  },
                  {
                    "terms": {
                      "pS": [
                        "false"
                      ]
                    }
                  },
                  {
                    "bool": {
                      "must_not": {
                        "exists": {
                          "field": "add.qsId"
                        }
                      },
                      "_cache_key": "329ea12ac1e5b7c94e25d1e3cc54bd3f"
                    }
                  },
                  {
                    "bool": {
                      "should": {
                        "bool": {
                          "must": [
                            {
                              "prefix": {
                                "_index": "t"
                              }
                            },
                            {
                              "terms": {
                                "mTp": [
                                  2,
                                  4,
                                  7
                                ]
                              }
                            }
                          ]
                        }
                      }
                    }
                  }
                ]
              }
            }
          ],
          "must_not": {
            "bool": {
              "should": [
                {
                  "bool": {
                    "should": [
                      {
                        "terms": {
                          "mD.iC.ca": [
                            "1"
                          ]
                        }
                      },
                      {
                        "terms": {
                          "n.aiT.t": [
                            "5",
                            "7"
                          ]
                        }
                      },
                      {
                        "bool": {
                          "should": {
                            "terms": {
                              "n.cM.sC": [
                                "5"
                              ]
                            }
                          }
                        }
                      },
                      {
                        "terms": {
                          "pS": [
                            "true"
                          ]
                        }
                      },
                      {
                        "terms": {
                          "add.domain": [
                            "heraldsun.com.au",
                            "themercury.com.au",
                            "adelaidenow.com.au",
                            "goldcoastbulletin.com.au",
                            "dailytelegraph.com.au",
                            "ntnews.com.au",
                            "blog.naver.com",
                            "news.com.au",
                            "geelongadvertiser.com.au",
                            "theaustralian.com.au",
                            "skynews.com.au",
                            "thechronicle.com.au",
                            "cairnspost.com.au",
                            "weeklytimesnow.com.au",
                            "townsvillebulletin.com.au",
                            "cafe.naver.com",
                            "couriermail.com.au"
                          ]
                        }
                      }
                    ]
                  }
                },
                {
                  "terms": {
                    "n.aiT.t": [
                      7
                    ]
                  }
                },
                {
                  "terms": {
                    "addI.mLi.licenseNames": [
                      "NLA"
                    ]
                  }
                }
              ]
            }
          }
        }
      }
    }
  },
  "aggregations": {
    "GEO_SENTIMENT_DISTRIBUTION": {
      "filter": {
        "match_all": {}
      },
      "aggregations": {
        "COUNTRY": {
          "terms": {
            "script": {
              "inline": "spr-multi-value",
              "lang": "native",
              "params": {
                "includeValues": [
                  "JP"
                ],
                "field": "l.c"
              }
            },
            "size": 21,
            "execution_hint": "map",
            "collect_mode": "breadth_first",
            "min_doc_count": 1
          },
          "aggregations": {
            "SEM_SENTIMENT": {
              "terms": {
                "field": "n.s.pM",
                "missing": -1,
                "size": 21,
                "execution_hint": "map",
                "collect_mode": "breadth_first",
                "min_doc_count": 1
              },
              "aggregations": {
                "MENTIONS_COUNT": {
                  "sum": {
                    "script": {
                      "inline": "1"
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}