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 = '6300'
group by i.id
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Introducing the stunning Coreopsis basalis Goldenmane Tickseed! This bushy annual boasts finely cut foliage and vivid round flowers that add a pop of color to any garden. Native to the southeastern and south-central United States, this plant prefers sandy soils in open areas, often found on disturbed ground. Growing up to 60 cm tall, this plant is perfect for landscaping and adds a touch of sunshine to any space. With its bright yellow ray florets complemented by reddish markings near their attachment points to the head, this Golden-mane Coreopsis is a showstopper. Don't miss out on this beautiful addition to your garden!