db.user.aggregate([
    { "$match" : {
        "$and" : [
            { "account.subscriptions.subscriptionControl.lastRenewAttempt" : { "$exists" : true}},
            { "account.subscriptions.subscriptionControl.lastRenewAttempt" : { "$lt" : ISODate("2018-01-23T02:00:00.000Z")}}
        ],
        "account.subscriptions.subscriptionStatus" : "IN_RENEW_PROCESS"}
    },
    { "$unwind" : "$account.subscriptions"},
    { "$match" : {
        "$and" : [
            { "account.subscriptions.subscriptionControl.lastRenewAttempt" : { "$exists" : true}},
            { "account.subscriptions.subscriptionControl.lastRenewAttempt" : { "$lt" : ISODate("2018-01-23T02:00:00.000Z")}}
        ],
        "account.subscriptions.subscriptionStatus" : "IN_RENEW_PROCESS"}
    },
    { "$group" : {
        "_id" : "$_id" ,
        "msisdn" : { "$first" : "$msisdn"} ,
        "vendor" : { "$first" : "$vendor"} ,
        "subs" : { "$push" : "$account.subscriptions"}}
    },
    { "$project" : {
        "msisdn" : "$msisdn" ,
        "vendor" : "$vendor" ,
        "account.subscriptions" : "$subs" ,
        "account.createDate" : "$createDate"}
    }
])