ES query

gistfile1.txt

{
    "from": 0,
    "size": 23,
    "_source": false,
    "query": {
        "bool": {
            "must": {
                "match_all": []
            },
            "filter": {
                "bool": {
                    "must": [
                        {
                            "term": {
                                "gender": "female"
                            }
                        },
                        {
                            "term": {
                                "accountstatus": "active"
                            }
                        },
                        {
                            "terms": {
                                "country": [
                                    "nl"
                                ]
                            }
                        },
                        {
                            "range": {
                                "birthdate": {
                                    "gte": "1979-11-18",
                                    "lte": "1993-11-18"
                                }
                            }
                        }
                    ],
                    "should": [
                        {
                            "range": {
                                "lastlogindate": {
                                    "gte": "2015-10-18 00:00",
                                    "lte": "2015-11-18 16:00"
                                },
                                "_cache": true
                            }
                        },
                        {
                            "range": {
                                "lastlogindate": {
                                    "gte": "2015-11-18 16:00",
                                    "lte": "2015-11-18 16:40"
                                },
                                "_cache": true
                            }
                        }
                    ]
                }
            }
        }
    },
    "sort": [
        {
            "hasavatar": "desc"
        }
    ]
}