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 = '700277'
group by i.id
Scarification: Soak in cold water, let stand in water for 24 hours
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Looking for a unique and beautiful addition to your garden? Look no further than Mirbelia dilatata, commonly known as Holly-leaved Mirbelia or Wedge-leaved Mirbelia. This stunning plant is native to Australia and can be found in every mainland state except South Australia.
The Mirbelia genus belongs to the Fabaceae family and is known for its vibrant flowers and lush foliage. The Holly-leaved Mirbelia in particular boasts distinctive dark green leaves with a glossy sheen and beautiful blossoms in shades of pink and purple.
Not only is Mirbelia dilatata a gorgeous addition to any garden, but it is also easy to care for and can thrive in a variety of soil types. This versatile plant can grow in full sun or partial shade and can even tolerate dry conditions once established.
If you're looking to add a touch of Australian beauty to your garden, consider introducing Mirbelia dilatata. With its stunning foliage and vibrant blossoms, it is sure to be a showstopper in any landscape.