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 = '700615'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Cherry Wine hemp strain is a strain is a high-CBD cross between The Wife and Charlotte’s Cherries – two influential names in the hemp industry. Recognized as an industry staple, Cherry Wine hemp immediately became synonymous with quality, reliability, and vigor since its inception in 2015, thanks to the founder Bodhi Urban. It boasts aromas of sweet cherry notes with hints of cheese and black pepper.
Standing tall at 8ft and stretching 2.5ft wide, Cherry Wine hemp is an annual plant that thrives best in zone 8 and warmer. Its terpenes invade your olfactory senses with sweet stone fruit layered with piney and peppery undertones, making it an ideal strain for relaxation and therapeutic use. Complementing its tempting aroma is its preeminent CBD richness. Not failing to deliver a balanced and smoky flavor, Cherry Wine is a powerhouse in its own league.
With a flowering period in July, Cherry Wine carries forward the legacy of parent strains – Charlotte’s Cherries with a 50:1 CBD to THC ratio, and The Wife known for heavy resin production and aesthetic flowers. As our foundational strain, Cherry Wine continues to be celebrated as a top-notch high-CBD hemp strain, encapsulating quality, reliability, and potency all at once. Start reaping the benefits of our leading strain today!