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 = '606'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Introducing the Dianthus plumarius 'Spring Beauty' - a feathered pink Spring Beauty Carnation that is sure to add a touch of elegance to any garden. This beautiful plant prefers a neutral to slightly alkaline soil in a sunny, well-drained position, but can also thrive in dry and poor soils. Its versatility is second to none, and it can even be grown on walls for added decoration. The multiple 1 1/2" flowers that bloom in May or June are not only visually stunning, but also emit a powerful clove-like scent that is sure to be a treat for the senses. With many named forms selected for their ornamental value, this attractive garden flower is perfect for any gardener looking to add a touch of sophistication to their backyard. Visit http://plants.usda.gov for more information on this remarkable plant.