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 = '699739'
group by i.id
Germination: sow seed 1/16" deep , tamp the soil, keep moist
In a Nutshell:
* Requires a rich, well-drained moisture retentive soil and a very warm, sunny and sheltered position. Prefers a pH of 5.5 to 5.9, but tolerates up to 6.8. Moderate rainfall favours growth, but the roots of most cultivars are sensitive to high soil-water levels. The squash is a frost-tender annual plant that is widely cultivated, especially in warm temperate and tropical areas, for its edible fruit.
* Sow seed early to mid spring in a greenhouse in a rich soil. Germination should take place within 2 weeks. Sow 2 or 3 seeds per pot and thin out to the best plant. Grow them on fast and plant out after the last expected frosts. more...
* Cucurbita moschata is a species originating in either Central America or northern South America. It includes cultivars of squash and pumpkin. C. moschata cultivars are generally more tolerant of hot, humid weather than cultivars of C. maxima or C. pepo. They also generally display a greater resistance to disease and insects, especially to the squash vine borer.
* The ancestral species of the genus Cucurbita were present in the Americas before the arrival of humans. Evolutionarily speaking the genus is relatively recent in origin as no species within the genus is genetically isolated from all the other species. C. moschata acts as the genetic bridge within the genus and is closest to the genus' progenitor. more...