NOTE: This page is experimental. Bug reports to Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT long_desc,, n.amount AS "Amount (100g serving)
(in grams or calories)"FROM food f JOIN nutrition n ON ( = n.food_id) JOIN nutrient nt ON ( = n.nutrient_id) WHERE = (SELECT id FROM food ORDER BY RANDOM() LIMIT 1) AND nutrient_id IN ( 208,204,606,601,307,205,291,269,203) ORDER BY (CASE WHEN THEN 1 WHEN THEN 2 WHEN THEN 3 WHEN THEN 4 WHEN THEN 5 WHEN THEN 6 WHEN THEN 7 WHEN THEN 8 WHEN THEN 9 END)

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query