db.phone_registrations.aggregate([
    {
        "$match": {
            "loc": {
                "$geoWithin": {
                    "$geometry": {
                        "type": "MultiPolygon",
                        "coordinates": [
                            [
                                [
                                    [
                                        40.39851563623066,
                                        49.8102435028116
                                    ],
                                    [
                                        40.4110646686392,
                                        49.8477490347955
                                    ],
                                    [
                                        40.401544927216655,
                                        49.86991139459019
                                    ],
                                    [
                                        40.39007617829808,
                                        49.88298150421008
                                    ],
                                    [
                                        40.3753586961352,
                                        49.87871951195663
                                    ],
                                    [
                                        40.359771975143886,
                                        49.82302947962313
                                    ],
                                    [
                                        40.38379999827059,
                                        49.8096752371693
                                    ],
                                    [
                                        40.39851563623066,
                                        49.8102435028116
                                    ]
                                ]
                            ]
                        ]
                    }
                }
            }
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "mission_id": 1,
            "session_id": 1,
            "serial_id": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$lookup": {
            "let": {
                "missionObjId": {
                    "$toObjectId": "$mission_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$missionObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "missions",
            "as": "mission_obj"
        }
    },
    {
        "$unwind": {
            "path": "$mission_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$lookup": {
            "let": {
                "serialObjId": {
                    "$toObjectId": "$serial_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$serialObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "serials",
            "as": "serial_obj"
        }
    },
    {
        "$unwind": {
            "path": "$serial_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "app_name": "$serial_obj.app_name",
            "mission_name": "$mission_obj.mission_name",
            "mission_id": {
                "$toString": "$mission_obj._id"
            },
            "target_name": "",
            "type": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$sort": {
            "imei": 1
        }
    },
    {
        "$skip": 0
    },
    {
        "$limit": 500
    }
],{allowUseDisk: true})


db.phone_registrations.aggregate([
    {
        "$match": {
            "mission_id": {
                "$in": [
                    "60e42244941ebd4fcc32dbf8",
                    "60e42244d2616e50037c3c81"
                ]
            }
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "mission_id": 1,
            "session_id": 1,
            "serial_id": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$lookup": {
            "let": {
                "missionObjId": {
                    "$toObjectId": "$mission_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$missionObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "missions",
            "as": "mission_obj"
        }
    },
    {
        "$unwind": {
            "path": "$mission_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$lookup": {
            "let": {
                "serialObjId": {
                    "$toObjectId": "$serial_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$serialObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "serials",
            "as": "serial_obj"
        }
    },
    {
        "$unwind": {
            "path": "$serial_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "app_name": "$serial_obj.app_name",
            "mission_name": "$mission_obj.mission_name",
            "mission_id": {
                "$toString": "$mission_obj._id"
            },
            "target_name": "",
            "type": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$sort": {
            "imei": -1
        }
    },
    {
        "$skip": 0
    },
    {
        "$limit": 500
    }
],{allowUseDisk: true})


db.phone_registrations.aggregate([
    {
        "$match": {
            "imsi": "400017117330390",
            "imei": "359497085371875"
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "mission_id": 1,
            "session_id": 1,
            "serial_id": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$lookup": {
            "let": {
                "missionObjId": {
                    "$toObjectId": "$mission_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$missionObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "missions",
            "as": "mission_obj"
        }
    },
    {
        "$unwind": {
            "path": "$mission_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$lookup": {
            "let": {
                "serialObjId": {
                    "$toObjectId": "$serial_id"
                }
            },
            "pipeline": [
                {
                    "$match": {
                        "$expr": {
                            "$eq": [
                                "$_id",
                                "$$serialObjId"
                            ]
                        }
                    }
                }
            ],
            "from": "serials",
            "as": "serial_obj"
        }
    },
    {
        "$unwind": {
            "path": "$serial_obj",
            "preserveNullAndEmptyArrays": true
        }
    },
    {
        "$project": {
            "imei": 1,
            "imsi": 1,
            "lat": 1,
            "lon": 1,
            "standard": 1,
            "arfcn": 1,
            "band": 1,
            "ta": 1,
            "date": 1,
            "rssi": 1,
            "app_name": "$serial_obj.app_name",
            "mission_name": "$mission_obj.mission_name",
            "mission_id": {
                "$toString": "$mission_obj._id"
            },
            "target_name": "",
            "type": 1,
            "ta_raw": 1,
            "alt": 1
        }
    },
    {
        "$sort": {
            "imei": -1
        }
    },
    {
        "$skip": 0
    },
    {
        "$limit": 500
    }
],{allowUseDisk: true})