Skip to content

Instantly share code, notes, and snippets.

@kimberlyh66
Created January 17, 2019 19:08
Show Gist options
  • Save kimberlyh66/96f0f246b8b0e0414df1a785729be351 to your computer and use it in GitHub Desktop.
Save kimberlyh66/96f0f246b8b0e0414df1a785729be351 to your computer and use it in GitHub Desktop.
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'Orita', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'Tiburon', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_181', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_106', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_103', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_145', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_259', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_058', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_153', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_144', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_156', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_174', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_055', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_204', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_243', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_212', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_250', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_119', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_072', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_191', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_101', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_152', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_004', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_192', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_047', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_109', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_215', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_022', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_122', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_113', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_228', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_130', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_166', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_037', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_244', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_185', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_139', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_154', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_076', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_254', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_136', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_169', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_233', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_270', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_248', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_196', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_264', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_081', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_043', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_075', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_188', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_173', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_135', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_146', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_040', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_086', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_178', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_184', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_203', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_006', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_240', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_202', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_015', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_117', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_216', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_112', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_266', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_048', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_115', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_104', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_062', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_100', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_147', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_125', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_197', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_242', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_066', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_224', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_001', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_168', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_071', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_219', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_260', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_177', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_038', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_110', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_107', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_057', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_126', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_132', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_065', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_045', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_010', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_124', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_039', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_082', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_030', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_011', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_225', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_267', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_221', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_129', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_231', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_133', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_027', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_020', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_102', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_171', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_261', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_253', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_160', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_207', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_089', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_046', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_163', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_157', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_218', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_029', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_151', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_232', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_175', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_087', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_255', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_061', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_019', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_052', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_070', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_230', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_167', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_008', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_256', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_025', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_213', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_116', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_056', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_121', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_246', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_263', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_028', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_186', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_014', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_190', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_105', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_063', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_084', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_182', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_023', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_176', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_118', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_237', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_074', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_077', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_150', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_078', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_123', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_249', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_201', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_009', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_229', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_068', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_206', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_200', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_024', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_111', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_220', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_134', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_013', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_268', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_005', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_026', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_162', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_195', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_142', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_205', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_155', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_227', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_114', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_222', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_208', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_210', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_073', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_012', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_079', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_080', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_187', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_239', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_170', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_247', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_127', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_131', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_054', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_269', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_064', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_036', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_069', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_158', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_217', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_051', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_183', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_032', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_034', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_090', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_108', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_140', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_209', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_085', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_257', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_149', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_258', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_159', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_033', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_049', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_235', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_148', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_172', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_189', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_194', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_251', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_143', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_041', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_137', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_226', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_265', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_138', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_042', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_007', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_234', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_165', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_053', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_223', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_245', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_016', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_128', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_031', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_199', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_059', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_238', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_035', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_018', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_164', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_083', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_021', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_060', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_180', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_262', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_161', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_002', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_252', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_017', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_088', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_179', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_120', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_050', '');
insert into cultivars (specie_id, name, ecotype) values ((select id from species where genus = 'Sorghum'), 'UNIBO Durum Panel DP_067', '');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment