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 = '943'
group by i.id
Austria, Belgium, Bulgaria, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovenia, Spain, Sweden
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Introducing the beautiful and versatile Photinia villosa, also known as Christmas berry or Oriental Photinia. This deciduous shrub can grow up to 5 meters tall and is native to Japan, Korea, and China. Its dark green, shiny leaves turn yellow, bronzy, and red in the fall, making it a stunning display plant. The 1/3-inch bright red fruit is a great source of food for birds. This large shrub can also be trained and pruned to grow as a small tree. However, take note that it is susceptible to fireblight. The wood is hard and heavy, which makes it a suitable choice for making furniture and other small articles. Order your Photinia villosa now and add it to your garden for a touch of elegance and functionality.