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 = '6025'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 14 days
Germination: surface sow on peat or sphagnum moss and keep moist by misting.
In a Nutshell:
* Sarracenia leucophylla , also known as the white pitcher plant , is a carnivorous plant in the genus Sarracenia . Like all the Sarracenia , it is native to the New World and inhabits moist and low-nutrient longleaf pine ( Pinus palustris ) savannas along the United States Gulf Coast , generally west of the Apalachicola River on the Florida Panhandle . The species is highly variable with respect to its pitchers, with plants in some localities reaching almost 1 metre in height, while in others, plants can be diminutive (such as the seldom seen 30 cm high dwarf form encountered at Garcon Point in Santa Rosa County , FL). S. leucophylla produces crimson flowers in the spring before its characteristically small spring pitchers. more...