Useful queries: Difference between revisions

From Open Food Facts wiki
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