Database
[{"type":"WIRE","subtype":"RETURN","amount":3500,"gid":2975075},{"type":"FEE","subtype":"INCOME","amount":1750,"gid":2975075},{"type":"FEE","subtype":"TXN","amount":1750,"gid":2975075},{"type":"WIRE","subtype":"TXN","amount":3500,"gid":2975075},{"type":"FEE","subtype":"INCOME","amount":0.08,"gid":2895112},{"type":"FEE","subtype":"TXN","amount":0.08,"gid":2895112},{"type":"WIRE","subtype":"TXN","amount":5,"gid":2895112,}]
Query
db.collection.find({$nor:[{type:"WIRE",subtype:{$in:["RETURN","TXN"]},gid:2975075}]})