Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
Line 45: Line 45:
 
* Organic foodies like beer but not too much (Tacite, BS causation by Teolemon)
 
* Organic foodies like beer but not too much (Tacite, BS causation by Teolemon)
 
**http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Bi%C3%A8res&sort_by=unique_scans_n&page_size=20&axis_x=alcohol&axis_y=products_n&series_organic=on&series_fairtrade=on&graph=1
 
**http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Bi%C3%A8res&sort_by=unique_scans_n&page_size=20&axis_x=alcohol&axis_y=products_n&series_organic=on&series_fairtrade=on&graph=1
 +
 +
==Sugar==
 +
* Products with sugar /produits avec du sucre (stephane)
 +
** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=contains&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 +
* Products without sugar /produits sans sucre (stephane)
 +
** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=does_not_contain&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display
 +
 +
== Old products ==
 +
*Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite)
 +
**- Statut = Complet
 +
**- Dernière modification = Avant le 31 juin 2012 inclus
 +
**Comme ça j'irais faire des photos des "vieux" produit pour les mettre à jour
 +
**http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=complet&sort_by=created_t&page_size=20&axis_x=energy&axis_y=products_n&page=618
 +
 
==To be sorted==
 
==To be sorted==
 
*Weird graph by Stephane
 
*Weird graph by Stephane
 
**http://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=fruits-vegetables-nuts&generate_graph_scatter_plot=1
 
**http://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=fruits-vegetables-nuts&generate_graph_scatter_plot=1

Revision as of 15:17, 8 August 2015

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


General

Cheeses

Sodas

Yogurts

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

Nutrition grades

Low hanging fruits

Organic

Sugar

Old products

To be sorted