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 = '699005'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Introducing the classic beauty of the Shasta Daisy! With its white petals and yellow disc, this herbaceous plant is a must-have in any garden or as groundcover. Formerly classified in the Chrysanthemum genus, the Shasta Daisy belongs to the Leucanthemum genus due to its unique traits. Developed by the famous American horticulturist Luther Burbank, the distinct odor of Shasta Daisies makes them unusual amongst flowers. Despite some members of its genus being considered noxious weeds, the Shasta Daisy remains a favorite among gardeners. Add a touch of elegance and charm to your garden with the timeless beauty of the Shasta Daisy (Leucanthemum x superbum)!