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 = '5818'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Introducing the Zinnia elegans 'California Giant Mix,' also known as the California Giant Zinnia and Elegant Zinnia. This vibrant annual garden flower boasts mixed colors of red, pink, orange, purple, yellow, and white, making it a great addition to any garden or floral arrangement. These flowers face outward, rather than upward, making them ideal for complementing other flowers as a background.
Standing at a height of about three feet, these flowers offer plenty of space to grow shorter flowers in front. They are easy to grow from seed, but it's important to start them early before the last threat of frost. As they are pollinated by insects - typically bees and butterflies - these flowers can attract an array of different pollinators to your garden.
These low-maintenance flowers make a cheerful and vibrant addition to any garden and are long-lived well into the fall if you remove dead flower heads. Zinnia's are also good companion plants for vegetables as they can impede cucumber beetles and tomato worms. They are beautiful as borders and in containers, and you'll definitely want to cut some to bring inside to create beautiful bouquets.
Get your hands on this great mix of bright colors and watch your garden come to life with the Zinnia elegans 'California Giant Mix.' For more information, visit http://plants.usda.gov.