select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '700634'
group by i.id
Germination: sow seed, cover lightly, keep moist, Germ. within 1 to 3 mos. at 13 c.
In a Nutshell:
* The Borlotti bean, also known as the Roman bean or romano bean (not to be confused with the Italian flat bean, a green bean also called "romano bean"), is a variety of cranberry bean bred in Italy to have a thicker skin. It is used in Italian, Portuguese (Catarino bean), Turkish, and Greek cuisine. more...
* Tenderette produces 5 inch pods over the whole summer, and not just all at once. They are great fresh, frozen or canned. It is resistant to common bean mosaic virus and New York 15 virus.
* The green pods are commonly used as a vegetable, they have a mild flavour and should only be cooked for a short time. When growing the plant for its seedpods, be sure to pick them whilst they are still small and tender. This will ensure the continued production of more pods by the plant. Flowering is reduced once the seeds begin to form inside the pods. more...
Top Ten Dry Bean Producers
(million metric ton), 2007
Source: FAO , FAOSTAT
Top Ten Green Bean Producers
(million metric ton), 2007
Source: FAO , FAOSTAT
Black beans and Kidney beans.
The common bean is a highly variable species with a long history. Bush varieties form erect bushes 20–60 cm tall, while pole or running varieties form vines 2–3 m long. All varieties bear alternate, green or purple leaves , divided into three oval, smooth-edged leaflets, each 6–15 cm long and 3–11 cm wide. The white, pink, or purple flowers are about 1 cm long, and give way to pods 8–20 cm long, 1–1.5 cm wide, green, yellow, black or purple in color, each containing 4–6 beans. The beans are smooth, plump, kidney-shaped, up to 1.5 cm long, range widely in color, and are often mottled in two or more colors. Toxicity The toxic compound lectin phytohaemagglutinin is present in many varieties, but is especially concentrated in red kidney beans. Although in the case of dry beans the ten minutes at 100 degrees Celsius required to degrade the toxin is much shorter than the hours required to fully cook the beans themselves, outbreaks of poisoning have been associated with the use of slow cookers whose low cooking temperatures may be unable to degrade the toxin. The British public health authority, PHLS , has recommended soaking kidney beans in fresh water for 5 hours prior to cooking. [ 2 ] Sprouts of pulses high in haemaglutins (such as kidney beans) should not be eaten. [ 2 ] [ 3 ] Dry beans Similar to other beans, the common bean is high in starch , protein and dietary fiber and is an excellent source of iron , potassium , selenium , molybdenum , thiamine , vitamin B6 , and folic acid .Dry beans will keep indefinitely if stored in a cool, dry place, but as time passes, their nutritive value and flavor degrade and cooking times lengthen. Dried beans are almost always cooked by boiling , often after having been soaked for several hours. While the soaking is not strictly necessary, it shortens cooking time and results in more evenly textured beans. In addition, discarding one or more batches of soaking water leaches out hard-to-digest complex sugars that can cause flatulence , though those who eat beans regularly rarely have difficulties with flatulence as intestinal microbes adjust. There are several methods including overnight soaking, and the power soak method, which is to boil beans for three minutes, then set them aside for 2–4 hours, then drain and discard the water and proceed with cooking. Common beans take longer to cook than most pulses : cooking times vary from one to four hours but are substantially reduced with pressure cooking .In Mexico, Central America and South America, the traditional spice to use with beans is epazote , which is also said to aid digestion. In East Asia a type of seaweed, Kombu , is added to beans as they cook for the same purpose. Salt, sugar, and acidic foods like tomatoes may harden uncooked beans resulting in seasoned beans at the expense of slightly longer cooking times.Dry beans may also be bought pre-cooked and canned as refried beans , or whole with water , salt , and sometimes sugar . Green beans
Cut green beans
Main article: Green beans Green beans (snap beans)
Nutritional value per 100 g (3.5 oz)
129 kJ (31 kcal)
Vitamin A equiv.
35 μg (4%)
16 mg (27%)
37 mg (4%)
Percentages are relative to US recommendations for adults. Source: USDA Nutrient database
There are three commonly known types of green beans: string or runner beans , stringless or French beans (depending on whether the pod has a tough, fibrous "string" running along its length), and snap beans , with a thin flat pod that requires less cooking time. Compared to the dry beans, they provide less starch and protein, and more vitamin A and vitamin C . The green beans are often steamed , boiled, stir-fried , or baked in casseroles . Shelling beans Common beans can be used for shell (or shelling) beans, which have the pods removed before they are cooked or dried. The term can be used to refer to other species of beans, such as lima beans , soybeans , peas , or fava beans , that have their shell removed before it is eaten. Nutritionally, shell beans are similar to dry beans, but in the kitchen are treated as a vegetable, often steamed, fried, or made into soups. Popping beans The nuña is an Andean subspecies, Phaseolus vulgaris subsp. nunas (formerly Phaseolus vulgaris (Nuñas Group) ), with round multicolored seeds that resemble pigeon eggs. When cooked on high heat, the bean explodes, exposing the inner part, in the manner of popcorn and other puffed grains .