Find products that appear in more than 5 different orders

MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.

The compiled query

{
  "type": "aggregation",
  "collection": "orders",
  "pipeline": [
    {},
    {},
    {},
    {},
    {},
    {}
  ]
}

How the compiled query works

$unwind — flattens $productIds into one document per element.
$group — groups by "$productIds" and aggregates orderCount.
$match — filters on orderCount.
$lookup — joins the products collection on _id → _id.
$unwind — flattens $productInfo into one document per element.
$project — returns only _id, productId, name, priceCents, category, inStock, orderCount.

Things worth knowing

priceCents stores money as an integer number of cents — divide by 100 before displaying it.
Inside $group, orderCount counts documents in each group — one output document per distinct "$productIds".

Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.

Try it in the playground → No signup, runs in your browser.

Find products that appear in more than 5 different orders

The compiled query

How the compiled query works

Things worth knowing

Related queries