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 = '699730'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 1/4 deep, keep moist, tamp the soil
Introducing the stunning Cistus albidus, also known as the grey-leaved cistus or white-leaved rock rose. This beautiful shrub is a member of the Cistaceae family, with showy pink to purple flowers that bloom in clusters of one to seven. The leaves are oblong and elliptical in shape, covered in short hairs that give them a distinctive greyish-white appearance. Growing up to one meter tall, this plant is native to southwestern Europe and western North Africa, where it thrives in sunny, well-drained soil. Add some color to your garden with the Cistus albidus, a real feast for the eyes!