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 = '700649'
group by i.id
Germination: sow seed, cover lightly, keep moist, Germ. within 1 to 3 mos. at 13 c.
Discover the exotic taste of Brassica juncea var. Red Giant Japanese Mustard, also known as Red Giant Mustard Greens. This annual plant grows up to 2ft 7in tall and is not frost tender, making it a perfect addition to any garden. The beautiful leaves are green with a tinge of purple, creating a stunning visual effect. The plant's horseradish-mustard flavor adds a unique and delicious taste to salads, sandwiches, and stir-fries. Brassica juncea is self-fertile and can grow in various soils, including acidic and alkaline. It prefers moist soil and can grow in semi-shade or no shade at all. Order now and experience the bold and versatile taste of Red Giant Japanese Mustard.