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 = '700207'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a showstopper in your garden? Look no further than the Zinnia elegans 'Pumila Mix' Elegant Zinnia, Pumila Sprite Zinnia. These annual garden flowers have flowers that face outward, making them ideal for flower arrangements. The mixed colors of red, pink, orange, purple, yellow, and white will bring a pop of color to any garden or container.
Not only are they beautiful, but Zinnia's are also pollinated by insects, such as bees and butterflies, making them an excellent choice for attracting pollinators to your garden. This variety will flower all summer long if you deadhead the old flowers. And, they are easy to grow from seed. Just start them early before the last threat of frost and give them warm temperatures to germinate.
These low maintenance flowers are tolerant of heat and dry soils, making them perfect for those who don't have a green thumb. Plus, they are long-lived well into the fall if you remove the dead flower heads. Zinnia's are also good companion plants for vegetables, and they can even impede cucumber beetles and tomato worms.
Add a touch of cheer to your garden with the Zinnia elegans 'Pumila Mix'. Learn more about these beautiful flowers at http://plants.usda.gov.