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 = '698362'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Discover the beauty of Rhododendron macrophyllum, commonly known as Pacific Rhododendron. This evergreen shrub is native to the Pacific Coast of North America and is the state flower of Washington. It can reach up to 30 feet in height and is characterized by its large leaves that stay on the plant for 2-3 years. The flowers are usually pink in color and have five lobes on the corolla. This species is found in the Coast Mountains and Cascade Range and is abundant in disturbed habitats like roadside embankments and recently deforested wildlands. Pacific Rhododendron is also an important habitat for big game animals as it provides thermal and hiding cover. However, it is fire-sensitive and can be reduced by fire. Experience the beauty and significance of this species in your garden today.