Untitled

{
    "size": 0,
    "timeout": "300000ms",
    "query": {
        "constant_score": {
            "filter": {
                "bool": {
                    "must": {
                        "bool": {
                            "must": [
                                {
                                    "range": {
                                        "snCTm": {
                                            "from": 1104537600000,
                                            "to": 1698465599000,
                                            "include_lower": true,
                                            "include_upper": true
                                        }
                                    }
                                },
                                {
                                    "terms": {
                                        "iD": [
                                            false
                                        ]
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": {
                                            "terms": {
                                                "add.prS": [
                                                    "tve",
                                                    "eClips",
                                                    "fac"
                                                ]
                                            }
                                        }
                                    }
                                }
                            ]
                        }
                    },
                    "must_not": [
                        {
                            "bool": {
                                "must_not": {
                                    "terms": {
                                        "snT": [
                                            "DATA_INGESTION"
                                        ]
                                    }
                                },
                                "should": [
                                    {
                                        "bool": {
                                            "must": [
                                                {
                                                    "terms": {
                                                        "fU.sN": [
                                                            "lets_dex",
                                                            "cdnleon",
                                                            "galaxy_boy28"
                                                        ]
                                                    }
                                                },
                                                {
                                                    "term": {
                                                        "add.m_t": "TWITTER"
                                                    }
                                                }
                                            ]
                                        }
                                    },
                                    {
                                        "term": {
                                            "addI.lstTopic.ord": -2
                                        }
                                    }
                                ],
                                "_cache_key": "9d9347375877083bd3bed5f5d0d6ed99"
                            }
                        },
                        {
                            "bool": {
                                "should": [
                                    {
                                        "terms": {
                                            "mVadd.aiT": [
                                                "hulk_replay"
                                            ]
                                        }
                                    },
                                    {
                                        "terms": {
                                            "mVadd.aiT": [
                                                "mo_sd"
                                            ]
                                        }
                                    },
                                    {
                                        "terms": {
                                            "add.d_s": [
                                                "tw_sl"
                                            ]
                                        }
                                    },
                                    {
                                        "bool": {
                                            "must": [
                                                {
                                                    "bool": {
                                                        "should": [
                                                            {
                                                                "terms": {
                                                                    "add.domain": [
                                                                        "heraldsun.com.au",
                                                                        "themercury.com.au",
                                                                        "adelaidenow.com.au",
                                                                        "goldcoastbulletin.com.au",
                                                                        "dailytelegraph.com.au",
                                                                        "ntnews.com.au",
                                                                        "news.com.au",
                                                                        "geelongadvertiser.com.au",
                                                                        "theaustralian.com.au",
                                                                        "skynews.com.au",
                                                                        "thechronicle.com.au",
                                                                        "cairnspost.com.au",
                                                                        "weeklytimesnow.com.au",
                                                                        "townsvillebulletin.com.au",
                                                                        "couriermail.com.au"
                                                                    ]
                                                                }
                                                            },
                                                            {
                                                                "terms": {
                                                                    "add.td": [
                                                                        "heraldsun.com.au",
                                                                        "themercury.com.au",
                                                                        "adelaidenow.com.au",
                                                                        "goldcoastbulletin.com.au",
                                                                        "dailytelegraph.com.au",
                                                                        "ntnews.com.au",
                                                                        "news.com.au",
                                                                        "geelongadvertiser.com.au",
                                                                        "theaustralian.com.au",
                                                                        "skynews.com.au",
                                                                        "thechronicle.com.au",
                                                                        "cairnspost.com.au",
                                                                        "weeklytimesnow.com.au",
                                                                        "townsvillebulletin.com.au",
                                                                        "couriermail.com.au"
                                                                    ]
                                                                }
                                                            }
                                                        ]
                                                    }
                                                },
                                                {
                                                    "bool": {
                                                        "must_not": {
                                                            "terms": {
                                                                "add.iUDA": [
                                                                    "true"
                                                                ]
                                                            }
                                                        },
                                                        "_cache_key": "e029ebc70021d9b4c58c7085cf9afe17"
                                                    }
                                                }
                                            ]
                                        }
                                    }
                                ],
                                "_cache_key": "b81597a890f4c7734535de244a6eaa59"
                            }
                        }
                    ]
                }
            }
        }
    },
    "aggregations": {
        "DEFAULT": {
            "filter": {
                "match_all": {}
            },
            "aggregations": {
                "webhose_duplicate_reviews": {
                    "terms": {
                        "field": "addI.mW.pCP.webhose_duplicate_reviews",
                        "size": 51,
                        "shard_size": 100001
                    }
                }
            }
        }
    }
}