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 = '700387'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: sow in the spring outdoors a week before the date of the last frost, 1/4 inch deep.
Tragopogon dubius, also known as yellow salsify, western goatsbeard or western salsify, is a species of salsify native to southern and central Europe and western Asia. It grows as an annual or biennial forb, reaching up to 2 ft in height, with a yellow flower head that blooms in late spring or early summer. The plant is commonly found in warm, sheltered places with moist soil. Yellow salsify is similar to meadow salsify, but its bracts are longer and more noticeable. It is regarded as edible, with the root and young stems being used raw or cooked. Yellow salsify is also present in both unburned and burned plots, persisting with low abundance on older, 8- to 30-year-old, burned sites. Its abundance rarely increases or decreases significantly due to fire. Yellow salsify has several alternative common names, including wild oysterplant, meadow goat's beard and common salsify.