Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
Line 146: Line 146:
  
 
== Low-hanging fruits ==
 
== Low-hanging fruits ==
 +
=== Alcohol ===
 
*Products that are named wines but don’t have a wine category
 
*Products that are named wines but don’t have a wine category
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
Line 154: Line 155:
 
*Products that have a year but don’t have a wine category
 
*Products that have a year but don’t have a wine category
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=2012&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=2012&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 +
* Wine products needing a category for Open Wine Facts
 +
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 +
 +
=== M&S ===
 
*M&S Products that can be labelled as sold in the UK
 
*M&S Products that can be labelled as sold in the UK
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1
 +
 +
=== Barcodes ===
 
*Products with a specific barcode prefix with no brand
 
*Products with a specific barcode prefix with no brand
 
**http://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed
 
**http://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed
Line 161: Line 168:
 
*Products with a wrong barcode
 
*Products with a wrong barcode
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
* Wine products needing a category for Open Wine Facts
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 
  
 
== Old products ==
 
== Old products ==

Revision as of 15:01, 15 August 2016

This is a list of useful searches, for future reference.

General

Thematic lists

Cheeses

Sodas

Nutella

Yogurts

Produits allégés

Breakfast Cereals - Les Céréales du Petit Déjeuner

Nutrition grades

Organic

Sugar

Christmas puddings

Meat

Beers

Ready-made meals

Lists for contributors

Contributions

Special Contributors


Errors

Product attributes

Brands

Brand Deep Dive

Packaging

Origins

Additives

Ingredients

Categories

Entry Dates

Status / States

Nutriments

Low-hanging fruits

Alcohol

M&S

Barcodes

Old products

To be sorted