queries.js

// Get products that does not have item
db.getCollection('gplzone').find({ 'item': { $exists: false } })

// Get products that has notes associated
db.getCollection('gplzone').find({ 'note': { $exists: true } })

// Get products that was not possible to scrape zip content
db.getCollection('gplzone').find({
    'item.product_version.is_double_zipped': true
})

// Get products that has log but does not has seen_at
db.getCollection('gplzone').find({
    $and: [
        { 'log': { $exists: true } },
        { 'seen_at': { $exists: false } },
    ]
})