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 = '665'
group by i.id
Germination: Broadcast, drill or hydroseed. Surface sow and keep moist, mulch the seed bed
Other: Seeding rate 30 lbs to the acre alone
Looking for a drought-resistant plant that can handle constant cutting and grows well in shallow chalky soil? Look no further than Festuca ovina var. duriuscula, also known as Hard Fescue or Sheep Fescue. This densely tufted perennial grass is wind-pollinated and flowers from May until June. It's not just a robust plant, but an important food source for caterpillars of several butterflies and moths, such as the Gatekeeper and the Meadow Brown. Sheep's fescue is commonly found on poor, well-drained mineral soil, as well as acidic bogs in Scotland's Portlethen Moss and mountain pastures throughout Europe and Asia. It's even been introduced to North America and used as a drought-tolerant lawn grass. With greyish-green, bristle-like leaves and slightly feathery one-sided panicles, Sheep Fescue is both pretty and practical. Available in colorful garden varieties with blue-grey foliage, discover the wonders of Festuca ovina var. duriuscula today with more information on http://plants.usda.gov.