I am new in Mongodb and want to convert a complex mysql query into mongodb

[steevej (Steeve Juneau)]

Please provide sample documents in well formatted JSON so that we can cut-n-paste into our test bed.

Make sure you read Formatting code and log snippets in posts before posting.