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 = '3975'
group by i.id
Scarification: Soak in cold water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Discover the wonders of Lavandula angustifolia subsp. angustifolia, also known as Common Lavender, English Lavender, and True Lavender. This versatile garden perennial is not just limited to the herb garden but is a beautiful addition to any garden. With its stunning lavender flowers and gray-green leaves, it provides mid-summer color and contrast to any garden bed, rock garden, herb garden, or scented garden. It can even be used effectively as a low hedge or an edger.
In addition to its aesthetic value, Lavender is known for its many benefits. Its abundant nectar yields a light fragrant honey that is attractive to bees and other pollinators. The essential oil extracted from its flowers is exquisitely scented and has an array of uses ranging from soap making to high-quality perfumes, even as an insect repellent. It is also known for its therapeutic properties, being used for muscle aches, respiratory problems, as an antibacterial, analgesic, cholagogue, antidepressant, and anti-emetic. Lavender is even safe to apply directly to the skin, making it a wonderful antiseptic for wound healing.
Whether you are a gardener, an aromatherapy enthusiast, or just looking for a natural way to uplift your mood, Lavandula angustifolia subsp. angustifolia is the plant for you. So why not add some beauty, serenity, and healing properties to your life and garden?