Line 50:
Line 50:
=== How many obsolete products in reality? ===
=== How many obsolete products in reality? ===
−
It's hard to say. Currently, we can provide scanning stats only for the last year: in 2024 here are the stats related to scanned products, thanks to [https://mirabelle.openfoodfacts.org/products?sql=select+count%28code%29+as+nb_of_products%0D%0A++%2C+sum%28unique_scans_n%29+as+sum_unique_scans%0D%0A++%2C+count%28unique_scans_n%29+as+nb_of_scanned_products%0D%0A++%2C+%28%28100*count%28unique_scans_n%29%29%2Fcount%28code%29%29+as+pct_of_scanned_products%0D%0Afrom+%5Ball%5D%0D%0Awhere+strftime%28%27%25Y%27%2C+created_datetime%29+%3C+%222025%22 this Mirabelle request]:
+
It's hard to say. Currently, we can provide scanning stats only for the last year: in 2024, based on <code>scans_n</code>, here are the stats related to scanned products, thanks to [https://mirabelle.openfoodfacts.org/products?sql=select+count%28code%29+as+nb_of_products%0D%0A++%2C+sum%28unique_scans_n%29+as+sum_unique_scans%0D%0A++%2C+count%28unique_scans_n%29+as+nb_of_scanned_products%0D%0A++%2C+%28%28100*count%28unique_scans_n%29%29%2Fcount%28code%29%29+as+pct_of_scanned_products%0D%0Afrom+%5Ball%5D%0D%0Awhere+strftime%28%27%25Y%27%2C+created_datetime%29+%3C+%222025%22 this Mirabelle request]:
{| class="wikitable"
{| class="wikitable"
!nb_of_products
!nb_of_products