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 = '4816'
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 3/8" deep, tamp the soil, mulch the seed bed
Other: Germination tends to be slow, Germinates faster in warmer temperatures.
Introducing the Sabal minor Dwarf Palmetto, a small species of palm that can be found in the southeastern and south-central United States, as well as northeastern Mexico. This fan-shaped palm can withstand cooler temperatures and is one of the most frost tolerant palms, surviving temperatures as low as -18°C. Sabal minor is a stemless shrub, usually growing 5-10 ft tall with leaves up to 4 feet wide. It produces white blooms followed by black fruit in long clusters. This species is best suited for subtropical and warm temperate climates, but it has been successfully cultivated in areas such as central Tennessee and the greater Washington, DC Metropolitan area. Sabal minor is a recommended horticultural plant and is a popular choice for coastal resort areas from Virginia Beach to southern Texas. Get your Sabal minor Dwarf Palmetto today and bring a unique touch of nature to your landscape.