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}]})

Result