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 = '700023'
group by i.id
Scarification: Germination can be difficult due to the hard seed coat, and is improved by scarification with a knife or sandpaper.
Stratification: none required, hard seed coat must be reduced by scarification~
Germination: Surface sow, cover lightly with medium or vermiculite.
Discover the exotic and aromatic Lavandula latifolia, also known as Broadleaved Lavender, Spike Lavender or Portuguese Lavender. This evergreen shrub boasts beautiful pale lilac flowers that bloom on slender, leafless stems from June to September. The scent of Lavandula latifolia is stronger, with more camphor and pungency, compared to Lavandula angustifolia, making it a great choice for aromatherapy. It can grow from 0 to 1,700 meters amsl and prefers well-drained soil, which makes it perfect for the western Mediterranean region. Order the Broadleaved Lavender today and reap its aromatic benefits!