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 = '5628'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Discover the fragrant and flavorful Rosmarinus officinalis, commonly known as Rosemary. This woody, perennial herb has fragrant, evergreen, needle-like leaves and beautiful flowers that can be white, pink, purple, or blue. Rosemary can grow up to 1.5m tall and flowers in summer, making it a popular decorative plant in Mediterranean gardens. Its leaves have a bitter, resinous flavor that complements meat dishes, vegetables, biscuits, cakes, jams, and jellies. It can be used fresh or dried and, when made into a fragrant tea, it is said to be especially nice when mixed with tansy. Rosemary is easy to grow, pest-resistant, and can be pruned into various shapes, including topiary. In addition to its culinary uses, rosemary essential oil is used to emit an aroma into a room and burnt as incense. For a touch of Mediterranean flavor in your home or garden, add Rosmarinus officinalis to your collection today!