Database
[{"type":0,"status":0},{"type":2,"status":0},{"type":3,"status":0},{"type":3,"status":0},{"type":0,"status":1},{"type":2,"status":1},]
Query
db.collection.find({$or:[{$and:[{type:{$in:[0,2]}},{status:{$ne:0}}]},{type:3}]})