Duplicate food records with/without product type

[monsieurtanuki]

What

There are apparently duplicates in the food database, with and without product type.

Steps to reproduce the behavior

https://world.openfoodfacts.org/cgi/search.pl?lc=fr&tags_lc=fr&cc=fr&fields=code,product_name,product_type&code=8722700202387&search_terms=&json=1&api_version=3

{
    "count": 2,
    "page": 1,
    "page_count": 2,
    "page_size": 50,
    "products": [
        {
            "code": "8722700202387",
            "product_name": "Amora Moutarde Douce Flacon Souple 260g",
            "product_type": "food"
        },
        {
            "code": "8722700202387",
            "product_name": "Amora Moutarde Douce 260g"
        }
    ],
    "skip": 0
}

Expected behavior

No duplicates

[teolemon]

@stephanegigandet

[stephanegigandet]

This is due to a bug we had on the pro platform, that saved products on the public platform. I still have some cleanup to do.
#11064

The _id is different:
https://world.openfoodfacts.org/cgi/search.pl?lc=fr&tags_lc=fr&cc=fr&fields=_id,id,code,product_name,product_type&code=8722700202387&search_terms=&json=1&api_version=3

[stephanegigandet]

off> db.products.count({"$expr": { "$ne": ["$_id", "$id"]}, "data_sources_tags": "producers"})
6738