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 = '5043'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 3/8 deep, tamp the soil, keep warm and moist
Other: Germination takes place in 30-90 days, but even under good conditions germination may be erratic and take longer.|Germination tends to be slow, Germinates faster in warmer temperatures.
Looking for a visually stunning and hardy perennial to add to your garden? Look no further than Phormium tenax var. Variegate Variegated New Zealand flax! This evergreen plant boasts beautiful, strap-like leaves that can reach up to two meters in length. In early summer, a tall flowering shoot emerges, bearing eye-catching yellow or red blooms. Native to New Zealand and Norfolk Island, Phormium tenax is also an important fiber plant. This plant prefers moist or wet soil and can tolerate maritime exposure, making it perfect for coastal gardens. Add this stunning plant to your landscape today!