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 = '5933'
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.
Introducing the stunning Phormium tenax var. Purpureum, also known as Purple Flax or New Zealand Flax. This evergreen perennial plant is native to New Zealand and Norfolk Island and is a popular choice for both ornamental and fiber purposes. With a height of up to 3 meters and strap-like leaves that grow up to 2 meters long, this plant is sure to make a statement in any garden or landscape design. In the summer months, a tall flowering shoot adorned with dramatic yellow or red flowers emerges from the clump of leaves, adding interest and color to the plant. This hardy plant can grow in a variety of soils, from light and sandy to heavy clay, and can even tolerate coastal exposure. Moist or wet soil is preferred, and while it can grow in semi-shade or no shade, it thrives in well-lit areas. Don't miss out on the beauty and versatility of Phormium tenax var. Purpureum - order yours today!