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 = '484'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Coreopsis lanceolata 'Sunburst', also known as Lance Coreopsis or Lanceleaf Tickseed, is a stunning perennial plant that produces yellow, double flowerheads up to 2.5 inches across. This showy, clump-forming plant grows to a height of 1.5-3 feet and spreads up to 1.5 feet wide. It is a native plant found throughout the eastern part of the United States, in many parts of the western U.S., Canada, and Mexico. 'Sunburst' is easily established by seed and will even reseed itself if flowerheads are not removed before they mature. This plant is tolerant of heat, humidity, and drought, making it an ideal addition to gardens in dry to medium moisture, well-drained soil in full sun. It is attractive to bees and makes an excellent cut flower. With proper care, this plant will naturalize to form large colonies. Division may be needed every 2-3 years to maintain robustness if grown in borders. So, cultivate this Lance Coreopsis for a stunning addition to your garden.