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 = '699573'
group by i.id
Germination: Sow seeds in very sandy soil, barely cover, tamp well, keep warm and in strong light and water only once daily until germination.
Other: The seed usually germinates in 2 - 4 weeks.
Discover the natural beauty of Salvia apiana, also known as white sage, bee sage, or sacred sage. This evergreen perennial shrub is native to the southwestern United States and northwestern Mexico, where it thrives in well-drained dry soil and full sun. Its foliage releases a strong aroma when rubbed, making it a popular choice for smudging and purification rituals in Native American and modern spiritual practices alike. The plant blooms with attractive white to pale lavender flowers in the spring, which are pollinated by bees, bumblebees, hawk moths, and hummingbirds. Cultivate this stunning plant in your garden and attract an abundance of wildlife.