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 = '699259'
group by i.id
[ edit ] Description The olive tree, Olea europaea , is an evergreen tree or shrub native to the Mediterranean , Asia and Africa . It is short and squat, and rarely exceeds 8–15 metres (26–49 ft) in height. The silvery green leaves are oblong in shape, measuring 4–10 centimetres (1.6–3.9 in) long and 1–3 centimetres (0.39–1.2 in) wide. The trunk is typically gnarled and twisted.The small white, feathery flowers , with ten-cleft calyx and corolla , two stamens and bifid stigma , are borne generally on the last year's wood, in racemes springing from the axils of the leaves.The fruit is a small drupe 1–2.5 centimetres (0.39–0.98 in) long, thinner-fleshed and smaller in wild plants than in orchard cultivars. Olives are harvested in the green to purple stage. Canned black olives may contain chemicals (usually ferrous sulfate ) that turn them black artificially. Olea europaea contains a seed commonly referred to as a pit or a rock.
Physical Characteristics
 Olea europaea is an evergreen Tree growing to 10 m (32ft) by 8 m (26ft) at a slow rate. It is hardy to zone 8. It is in leaf 12-Jan It is in flower from Aug to September. The flowers are hermaphrodite (have both male and female organs) and are pollinated by Wind.The plant is self-fertile. The plant prefers light (sandy), medium (loamy) and heavy (clay) soils, requires well-drained soil and can grow in nutritionally poor soil.The plant prefers acid, neutral and basic (alkaline) soils..It cannot grow in the shade.It requires dry or moist soil and can tolerate drought.
The Olive tree has traditionally been cultivated for fruit production. A common tree in the mediterranean countries for 1000's of years ,it is known as a strong tree symbolizing peace, abundance and glory. The Olive tree works well as an bonsai because of the small leaves and stature, adversity to dry conditions and gnarly bark. The Olea europoaea species is an easy to care for bonsai liking a sunny spot but protect during the winter at about the 50 degree F mark.
Olea europaea, is an ideal species for bonsai, it is hardy, resilient, responses well to bonsai techniques. The Olive tree tolerates a wide variety of climates but does best in warm areas. Its deadwood is full of character and can sometimes flower and fruit.