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 = '697686'
group by i.id
Seeds per lb:
Oregon Clear Lake
Min. hardiness zone:
Scarification: none required
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Introducing Rudbeckia occidentalis, also known as western coneflower! This beautiful perennial herb features large oval leaves that are lightly to deeply toothed along the edges, and can grow up to 30 centimeters long. The inflorescence consists of one or more flower heads with purplish bases up to 6 centimeters wide. What makes this plant unique is that it has no ray florets, just an array of reflexed phyllaries around the purple-brown center packed with disc florets. It is native to the northwestern United States from Washington to northern California and east to Wyoming and Montana, where it grows in moist habitat types, such as meadows. Rudbeckia occidentalis is an impressive plant that can reach heights of up to two meters. It is sometimes grown as an ornamental and is perfect for adding a touch of the wild west to any garden. Order your Rudbeckia occidentalis today and enjoy its natural beauty for years to come!