Translate a SQL query to MongoDB

I need a specific SQL query to be translated into a MongoDB query. I don't need the database, I only want to see how the query would look like. There is a blog post that explains everything in more detail that I can send in DM.