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 = '2496'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Say hello to the Florida Cranberry, or as it is commonly known, Hibiscus sabdariffa, Red Sorrel or Roselle. This annual or perennial herb hails from the Old World tropics and is highly valued for its therapeutic properties. Its deeply three to five lobed leaves and large, bright red, fleshy calyx produce a deliciously tart taste that is said to have diuretic effects, lower fevers, and be antiscorbutic. The calyx can be used fresh or dried for tea or as a flavorful addition to jellies, jams, and sauces. The flowers of the Florida Cranberry contain gossypetin, anthocyanin, and the glycoside hibiscin, which may have diuretic and choleretic effects, reducing blood pressure and stimulating intestinal peristalsis. Experimentally, an infusion decreases the viscosity of the blood, making it an ideal tonic tea for digestive and kidney functions. So go ahead, add a pop of bright red color and a zingy flavor to your next culinary creation, while boosting your health with the Florida Cranberry.