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 = '699314'
group by i.id
Germination: Sow on milled peat moss, do not cover, place under mist or in high humidity environment. Germination takes place in 3 to 5 weeks.
Looking for an evergreen shrub that will add some color to your garden? Look no further than Callistemon citrinus Crimson Bottlebrush! This hardy shrub can grow up to 4.5m and produces beautiful hermaphrodite flowers from July to August, making it a great addition to any landscape. It prefers well-drained soil and can tolerate drought, making it a low-maintenance plant to care for. Native to Australia, this Crimson Bottlebrush thrives in the vicinity of rocky streams and near-coastal swamps. Add some vibrant color to your garden with Callistemon citrinus Crimson Bottlebrush! More information can be found on http://plants.usda.gov.