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 = '5078'
group by i.id
Germination: surface sow and keep moist, tamp the soil, mulch the seed bed
Discover Philadelphus lewisii, a beautifully lush deciduous shrub, natively widespread across western North America. From the captivating Sierra Nevada to idyllic regions of Idaho and British Columbia, this diverse spectacle grows amongst various other species. Also known as Lewis' Mock Orange, the dwarf shrub delivers stunning clusters of long stems adorned with delicate white petals and vibrant yellow stamens - a delightful sight during its peak flowering period. The enchanting flowers ooze a sweet, orange blossom scent with a hint of pineapple. A resilient plant, thriving in most soils, including thin soils over chalk and heavy clay, it enjoys partial shade to full sun exposure. The Mock Orange is hardy, growing 6-111 ft tall, and tolerates difficult conditions up to 5°f. It develops red stems, fading to gray with age. Its leaves exhibit a pleasing light green shade and rough texture. Its eco-friendly properties include usage as an effective gentle cleaner, thanks to its saponin-rich leaves and flowers. Traditional medicinal uses include treating skin conditions and sore joints. Recognized as Idaho's state flower, this versatile, aromatic plant maintains an ornamental presence in your garden.