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 = '699738'
group by i.id
Introducing the Golden Summer Crookneck Squash, a winter squash with a unique curved neck and distinctive longitudinal ridges. This bush type plant produces an abundance of delicious buttery-yellow squash that are easy to grow and harvest when they reach 8 inches long. Golden Summer Crookneck is one of the earliest producing crookneck squashes on the market, ensuring that you will have a bountiful harvest all summer long! As it matures, the squash turns deeper yellow and develops a sweet, yellow-orange flesh that is tender and full of flavor.
Did you know that although considered a "winter" squash, the acorn squash belongs to the same species as all "summer" squashes including zucchini and yellow crookneck squash? Acorn squash is known for its dark green color, but newer varieties like Golden Acorn with its glowing yellow color, and some that are white or variegated have arisen. This squash is perfect for winter storage, keeping for several months in a cool, dry location such as a cellar.
Acorn squash is also incredibly easy to grow. Seeds should be started after all danger of frost has passed, and the soil is warm, within 3-4 weeks before the predicted last frost date in the area. After germinating, they are ready to harvest roughly 85 days later. Additionally, the seeds of the squash are edible and can be toasted for a delicious snack. Acorn squash is perfect for baking, microwaving, sautéing, and steaming, and is a great source of dietary fiber, potassium, and vitamins C and B, magnesium, and manganese.
Experience the unique flavor and versatility of these delicious squashes by growing your own Golden Summer Crookneck or Acorn squash today!