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 = '699530'
group by i.id
Scarification: Nick or file through seed coat. Soak in water 24 hours or until seed has expanded considerably.
Stratification: none required
Germination: sow seed 1/4 deep, keep moist, tamp the soil
Other: Alternate Treatment, Soak in sulfuric or nitric acid for 15 to 30 minutes and wash under cold water for 5-10 minutes. USE CAUTION
Genista sagittalis, also known as Arrow-jointed Broom, Broom, or Winged Broom, is a beautiful and versatile plant is sure to add a touch of elegance to any garden or landscape.
Genista sagittalis is a deciduous shrub that belongs to the Fabaceae family. It is native to Europe and can be found growing in various habitats, including dry slopes, rocky hillsides, and open woodlands. This hardy plant is well-adapted to a range of growing conditions and is known for its ability to withstand drought and poor soil.
One of the most striking features of Genista sagittalis is its unique foliage. The leaves are small and slender, and they have a distinct arrowhead shape, hence the name "Arrow-jointed Broom." The bright green color of the leaves provides an attractive backdrop for the plant's showy clusters of vibrant yellow flowers. The blooms appear in late spring to early summer and completely cover the plant, creating a stunning display of color. The flowers are fragrant and attract a variety of pollinators, such as bees and butterflies, making this plant an excellent choice for gardeners looking to attract beneficial insects. The stems of this shrub are ridged and have a winged appearance, earning it the name "Winged Broom." As the plant matures, it develops a graceful arching form, which adds a sense of movement and drama to the landscape.
With regards to maintenance, Genista sagittalis is relatively easy to care for. It prefers a well-draining soil and should be watered regularly, especially during periods of prolonged drought. This plant is also tolerant of pruning, which allows you to maintain its shape and size, making it suitable for both formal and informal gardens.
The versatility of Genista sagittalis makes it perfect for a range of landscape design projects. It can be used as a focal point in a mixed border or as a foundation planting. Its graceful arching form also makes it an excellent choice for adding structure and interest to a perennial garden. Additionally, it can be grown in containers, allowing for easy mobility and placement in the landscape.