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 = '1337'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
The Rudbeckia fulgida Orange Coneflower, also known as Showy Coneflower, is a North American native perennial that grows up to 120 cm tall. It features bright yellow daisy-like composite flower heads borne singly or in corymbiform arrays. The stems are hairy, ridged, and dark green, while the leaves have blades that are lanceolate to broadly ovate or elliptic in shape and basal leaves are petiolate. This herbaceous plant spreads by stoloniferous stems and seed, with its ripe seeds attracting winter finches. Recommended for vernalization, it has seven varieties, with Goldsturm and Little Goldstar receiving the Royal Horticultural Society's Award of Garden Merit. This brightly colored plant with beautifully shaped flower heads is perfect for garden borders or as cut flowers.