Skip to content

Instantly share code, notes, and snippets.

@kimberlyh66
Created January 16, 2019 21:25
Show Gist options
  • Save kimberlyh66/77bb1aa35b534229dfa8c845db21d1bd to your computer and use it in GitHub Desktop.
Save kimberlyh66/77bb1aa35b534229dfa8c845db21d1bd to your computer and use it in GitHub Desktop.
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 8'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 9'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 10'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 11'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 1 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 8'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 9'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 10'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 11'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 2 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 8'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 9'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 10'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 11'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 3 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 2'), (select id from cultivars where name = 'PI563020'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 3'), (select id from cultivars where name = 'PI570031'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 4'), (select id from cultivars where name = 'PI330182'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 5'), (select id from cultivars where name = 'PI570110'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 6'), (select id from cultivars where name = 'PI585452'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 7'), (select id from cultivars where name = 'PI570400'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 8'), (select id from cultivars where name = 'PI329711'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 9'), (select id from cultivars where name = 'PI570091'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 10'), (select id from cultivars where name = 'PI653617'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 11'), (select id from cultivars where name = 'PI521152'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 12'), (select id from cultivars where name = 'PI153877'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 13'), (select id from cultivars where name = 'PI145626'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 14'), (select id from cultivars where name = 'PI329673'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 15'), (select id from cultivars where name = 'PI329394'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 4 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 2'), (select id from cultivars where name = 'PI569455'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 3'), (select id from cultivars where name = 'PI563355'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 4'), (select id from cultivars where name = 'PI646242'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 5'), (select id from cultivars where name = 'PI152816'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 6'), (select id from cultivars where name = 'PI152961'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 7'), (select id from cultivars where name = 'PI569264'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 8'), (select id from cultivars where name = 'PI569420'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 9'), (select id from cultivars where name = 'PI651497'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 10'), (select id from cultivars where name = 'PI641824'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 11'), (select id from cultivars where name = 'PI329546'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 12'), (select id from cultivars where name = 'PI221548'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 13'), (select id from cultivars where name = 'PI453696'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 14'), (select id from cultivars where name = 'PI152694'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 15'), (select id from cultivars where name = 'PI329256'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 5 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 2'), (select id from cultivars where name = 'PI329570'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 3'), (select id from cultivars where name = 'PI221651'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 4'), (select id from cultivars where name = 'PI156326'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 5'), (select id from cultivars where name = 'PI585577'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 6'), (select id from cultivars where name = 'PI570388'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 7'), (select id from cultivars where name = 'PI330858'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 8'), (select id from cultivars where name = 'PI619807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 9'), (select id from cultivars where name = 'PI641815'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 10'), (select id from cultivars where name = 'PI156217'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 11'), (select id from cultivars where name = 'PI155760'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 12'), (select id from cultivars where name = 'PI213900'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 13'), (select id from cultivars where name = 'PI585608'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 14'), (select id from cultivars where name = 'PI562994'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 15'), (select id from cultivars where name = 'PI157804'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 6 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 2'), (select id from cultivars where name = 'PI330195'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 3'), (select id from cultivars where name = 'PI330184'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 4'), (select id from cultivars where name = 'PI329466'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 5'), (select id from cultivars where name = 'PI569244'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 6'), (select id from cultivars where name = 'PI452692'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 7'), (select id from cultivars where name = 'PI329550'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 8'), (select id from cultivars where name = 'PI569427'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 9'), (select id from cultivars where name = 'PI329471'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 10'), (select id from cultivars where name = 'PI570373'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 11'), (select id from cultivars where name = 'PI452619'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 12'), (select id from cultivars where name = 'PI563006'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 13'), (select id from cultivars where name = 'PI154750'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 14'), (select id from cultivars where name = 'PI506030'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 15'), (select id from cultivars where name = 'PI570076'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 7 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 2'), (select id from cultivars where name = 'PI527045'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 3'), (select id from cultivars where name = 'PI655978'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 4'), (select id from cultivars where name = 'PI540518'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 5'), (select id from cultivars where name = 'PI585467'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 6'), (select id from cultivars where name = 'PI154988'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 7'), (select id from cultivars where name = 'PI524475'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 8'), (select id from cultivars where name = 'PI179749'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 9'), (select id from cultivars where name = 'PI329518'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 10'), (select id from cultivars where name = 'PI564163'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 11'), (select id from cultivars where name = 'PI570042'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 12'), (select id from cultivars where name = 'PI646266'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 13'), (select id from cultivars where name = 'PI329632'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 14'), (select id from cultivars where name = 'PI570071'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 15'), (select id from cultivars where name = 'PI329518'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 8 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 2'), (select id from cultivars where name = 'PI506069'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 3'), (select id from cultivars where name = 'PI641850'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 4'), (select id from cultivars where name = 'PI273969'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 5'), (select id from cultivars where name = 'PI156393'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 6'), (select id from cultivars where name = 'PI257600'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 7'), (select id from cultivars where name = 'PI152730'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 8'), (select id from cultivars where name = 'PI569418'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 9'), (select id from cultivars where name = 'PI455301'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 10'), (select id from cultivars where name = 'PI329645'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 11'), (select id from cultivars where name = 'PI570114'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 12'), (select id from cultivars where name = 'PI196598'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 13'), (select id from cultivars where name = 'PI455217'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 14'), (select id from cultivars where name = 'PI152923'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 15'), (select id from cultivars where name = 'PI329618'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 9 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 2'), (select id from cultivars where name = 'PI152967'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 3'), (select id from cultivars where name = 'PI505722'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 4'), (select id from cultivars where name = 'PI152966'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 5'), (select id from cultivars where name = 'PI562985'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 6'), (select id from cultivars where name = 'PI653616'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 7'), (select id from cultivars where name = 'PI145633'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 8'), (select id from cultivars where name = 'PI22913'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 9'), (select id from cultivars where name = 'PI19770'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 10'), (select id from cultivars where name = 'PI563329'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 11'), (select id from cultivars where name = 'PI569419'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 12'), (select id from cultivars where name = 'PI156330'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 13'), (select id from cultivars where name = 'PI562998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 14'), (select id from cultivars where name = 'PI330199'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 15'), (select id from cultivars where name = 'PI154844'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 10 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 2'), (select id from cultivars where name = 'PI563196'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 3'), (select id from cultivars where name = 'PI170787'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 4'), (select id from cultivars where name = 'PI257599'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 5'), (select id from cultivars where name = 'PI156268'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 6'), (select id from cultivars where name = 'PI562897'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 7'), (select id from cultivars where name = 'PI510757'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 8'), (select id from cultivars where name = 'PI643008'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 9'), (select id from cultivars where name = 'PI273465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 10'), (select id from cultivars where name = 'PI329519'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 11'), (select id from cultivars where name = 'PI455307'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 12'), (select id from cultivars where name = 'PI229841'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 13'), (select id from cultivars where name = 'PI651491'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 14'), (select id from cultivars where name = 'PI569462'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 15'), (select id from cultivars where name = 'PI563350'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 11 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 2'), (select id from cultivars where name = 'PI563002'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 3'), (select id from cultivars where name = 'PI641817'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 4'), (select id from cultivars where name = 'PI576401'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 5'), (select id from cultivars where name = 'PI655972'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 6'), (select id from cultivars where name = 'PI329435'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 7'), (select id from cultivars where name = 'PI576399'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 8'), (select id from cultivars where name = 'PI593916'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 9'), (select id from cultivars where name = 'PI35038'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 10'), (select id from cultivars where name = 'PI533902'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 11'), (select id from cultivars where name = 'PI513898'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 12'), (select id from cultivars where name = 'PI656065'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 13'), (select id from cultivars where name = 'PI569422'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 14'), (select id from cultivars where name = 'PI651496'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 15'), (select id from cultivars where name = 'PI329614'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 12 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 2'), (select id from cultivars where name = 'PI297171'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 3'), (select id from cultivars where name = 'PI562732'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 4'), (select id from cultivars where name = 'PI656035'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 5'), (select id from cultivars where name = 'PI620072'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 6'), (select id from cultivars where name = 'PI562982'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 7'), (select id from cultivars where name = 'PI156487'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 8'), (select id from cultivars where name = 'PI157035'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 9'), (select id from cultivars where name = 'PI585454'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 10'), (select id from cultivars where name = 'PI641810'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 11'), (select id from cultivars where name = 'PI569452'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 12'), (select id from cultivars where name = 'PI144134'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 13'), (select id from cultivars where name = 'PI329286'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 14'), (select id from cultivars where name = 'PI276837'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 15'), (select id from cultivars where name = 'PI570087'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 13 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 2'), (select id from cultivars where name = 'PI218112'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 3'), (select id from cultivars where name = 'PI329478'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 4'), (select id from cultivars where name = 'PI533998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 5'), (select id from cultivars where name = 'PI570106'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 6'), (select id from cultivars where name = 'PI570109'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 7'), (select id from cultivars where name = 'PI641830'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 8'), (select id from cultivars where name = 'PI152965'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 9'), (select id from cultivars where name = 'PI180348'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 10'), (select id from cultivars where name = 'PI535796'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 11'), (select id from cultivars where name = 'PI329326'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 12'), (select id from cultivars where name = 'PI641821'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 13'), (select id from cultivars where name = 'PI526905'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 14'), (select id from cultivars where name = 'PI641807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 15'), (select id from cultivars where name = 'PI562971'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 14 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 2'), (select id from cultivars where name = 'PI267573'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 3'), (select id from cultivars where name = 'PI570085'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 4'), (select id from cultivars where name = 'PI330803'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 5'), (select id from cultivars where name = 'PI337680'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 6'), (select id from cultivars where name = 'PI563032'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 7'), (select id from cultivars where name = 'PI646251'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 8'), (select id from cultivars where name = 'PI569886'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 9'), (select id from cultivars where name = 'PI569460'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 10'), (select id from cultivars where name = 'PI562991'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 11'), (select id from cultivars where name = 'PI146890'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 12'), (select id from cultivars where name = 'PI152591'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 13'), (select id from cultivars where name = 'PI155885'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 14'), (select id from cultivars where name = 'PI506114'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 15'), (select id from cultivars where name = 'PI330181'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 15 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 2'), (select id from cultivars where name = 'PI145619'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 3'), (select id from cultivars where name = 'PI155516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 4'), (select id from cultivars where name = 'PI563330'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 5'), (select id from cultivars where name = 'PI329584'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 6'), (select id from cultivars where name = 'PI152862'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 7'), (select id from cultivars where name = 'PI563331'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 8'), (select id from cultivars where name = 'PI330169'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 9'), (select id from cultivars where name = 'PI330196'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 10'), (select id from cultivars where name = 'PI641829'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 11'), (select id from cultivars where name = 'PI505717'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 12'), (select id from cultivars where name = 'PI521280'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 13'), (select id from cultivars where name = 'PI570074'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 14'), (select id from cultivars where name = 'PI563022'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 15'), (select id from cultivars where name = 'PI642998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 16 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 2'), (select id from cultivars where name = 'PI534165'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 3'), (select id from cultivars where name = 'PI569264'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 4'), (select id from cultivars where name = 'PI52606'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 5'), (select id from cultivars where name = 'PI641825'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 6'), (select id from cultivars where name = 'PI569445'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 7'), (select id from cultivars where name = 'PI641836'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 8'), (select id from cultivars where name = 'PI656015'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 9'), (select id from cultivars where name = 'PI535794'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 10'), (select id from cultivars where name = 'PI217691'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 11'), (select id from cultivars where name = 'PI330807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 12'), (select id from cultivars where name = 'PI152651'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 13'), (select id from cultivars where name = 'PI561840'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 14'), (select id from cultivars where name = 'PI534120'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 15'), (select id from cultivars where name = 'PI152828'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 17 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 2'), (select id from cultivars where name = 'PI514456'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 3'), (select id from cultivars where name = 'PI297155'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 4'), (select id from cultivars where name = 'PI563338'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 5'), (select id from cultivars where name = 'PI569453'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 6'), (select id from cultivars where name = 'PI570254'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 7'), (select id from cultivars where name = 'PI329864'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 8'), (select id from cultivars where name = 'PI643016'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 9'), (select id from cultivars where name = 'PI586435'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 10'), (select id from cultivars where name = 'PI570096'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 11'), (select id from cultivars where name = 'PI573193'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 12'), (select id from cultivars where name = 'PI156871'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 13'), (select id from cultivars where name = 'PI195754'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 14'), (select id from cultivars where name = 'PI152730'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 15'), (select id from cultivars where name = 'PI585961'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 18 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 2'), (select id from cultivars where name = 'PI655983'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 3'), (select id from cultivars where name = 'PI329511'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 4'), (select id from cultivars where name = 'PI297155'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 5'), (select id from cultivars where name = 'PI455221'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 6'), (select id from cultivars where name = 'PI329545'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 7'), (select id from cultivars where name = 'PI213900'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 8'), (select id from cultivars where name = 'PI154944'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 9'), (select id from cultivars where name = 'PI329510'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 10'), (select id from cultivars where name = 'PI455280'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 11'), (select id from cultivars where name = 'PI651495'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 12'), (select id from cultivars where name = 'PI329333'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 13'), (select id from cultivars where name = 'PI157030'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 14'), (select id from cultivars where name = 'PI570431'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 15'), (select id from cultivars where name = 'PI154844'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 19 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 2'), (select id from cultivars where name = 'PI329501'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 3'), (select id from cultivars where name = 'PI535792'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 4'), (select id from cultivars where name = 'PI535795'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 5'), (select id from cultivars where name = 'PI569443'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 6'), (select id from cultivars where name = 'PI562981'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 7'), (select id from cultivars where name = 'PI641909'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 8'), (select id from cultivars where name = 'PI197542'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 9'), (select id from cultivars where name = 'PI566819'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 10'), (select id from cultivars where name = 'PI570073'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 11'), (select id from cultivars where name = 'PI569421'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 12'), (select id from cultivars where name = 'PI585966'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 13'), (select id from cultivars where name = 'PI656026'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 14'), (select id from cultivars where name = 'PI329506'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 15'), (select id from cultivars where name = 'PI569422'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 20 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 2'), (select id from cultivars where name = 'PI569457'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 3'), (select id from cultivars where name = 'PI154987'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 4'), (select id from cultivars where name = 'PI535785'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 5'), (select id from cultivars where name = 'PI620157'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 6'), (select id from cultivars where name = 'PI452542'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 7'), (select id from cultivars where name = 'PI506122'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 8'), (select id from cultivars where name = 'PI329605'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 9'), (select id from cultivars where name = 'PI641835'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 10'), (select id from cultivars where name = 'PI569447'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 11'), (select id from cultivars where name = 'PI92270'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 12'), (select id from cultivars where name = 'PI651496'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 13'), (select id from cultivars where name = 'PI641862'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 14'), (select id from cultivars where name = 'PI152733'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 15'), (select id from cultivars where name = 'PI641860'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 21 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 2'), (select id from cultivars where name = 'PI569148'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 3'), (select id from cultivars where name = 'PI511355'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 4'), (select id from cultivars where name = 'PI337689'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 5'), (select id from cultivars where name = 'PI329351'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 6'), (select id from cultivars where name = 'PI152860'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 7'), (select id from cultivars where name = 'PI251672'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 8'), (select id from cultivars where name = 'PI563021'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 9'), (select id from cultivars where name = 'PI156178'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 10'), (select id from cultivars where name = 'PI329301'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 11'), (select id from cultivars where name = 'PI329843'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 12'), (select id from cultivars where name = 'PI152771'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 13'), (select id from cultivars where name = 'PI329310'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 14'), (select id from cultivars where name = 'PI562781'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 15'), (select id from cultivars where name = 'PI562970'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 22 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 2'), (select id from cultivars where name = 'PI329338'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 3'), (select id from cultivars where name = 'PI156463'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 4'), (select id from cultivars where name = 'PI569423'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 5'), (select id from cultivars where name = 'PI329585'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 6'), (select id from cultivars where name = 'PI570038'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 7'), (select id from cultivars where name = 'PI329480'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 8'), (select id from cultivars where name = 'PI156890'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 9'), (select id from cultivars where name = 'PI569465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 10'), (select id from cultivars where name = 'PI619838'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 11'), (select id from cultivars where name = 'PI63715'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 12'), (select id from cultivars where name = 'PI641807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 13'), (select id from cultivars where name = 'PI303658'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 14'), (select id from cultivars where name = 'PI330833'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 15'), (select id from cultivars where name = 'PI176766'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 23 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 2'), (select id from cultivars where name = 'PI641892'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 3'), (select id from cultivars where name = 'PI329665'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 4'), (select id from cultivars where name = 'PI566819'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 5'), (select id from cultivars where name = 'PI152971'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 6'), (select id from cultivars where name = 'PI569097'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 7'), (select id from cultivars where name = 'PI562997'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 8'), (select id from cultivars where name = 'PI329699'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 9'), (select id from cultivars where name = 'PI255239'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 10'), (select id from cultivars where name = 'PI266927'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 11'), (select id from cultivars where name = 'PI329702'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 12'), (select id from cultivars where name = 'PI297130'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 13'), (select id from cultivars where name = 'PI330796'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 14'), (select id from cultivars where name = 'PI562990'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 15'), (select id from cultivars where name = 'PI196586'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 24 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 2'), (select id from cultivars where name = 'PI563332'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 3'), (select id from cultivars where name = 'PI167093'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 4'), (select id from cultivars where name = 'PI329517'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 5'), (select id from cultivars where name = 'PI329319'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 6'), (select id from cultivars where name = 'PI329841'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 7'), (select id from cultivars where name = 'PI175919'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 8'), (select id from cultivars where name = 'PI330185'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 9'), (select id from cultivars where name = 'PI586541'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 10'), (select id from cultivars where name = 'PI562730'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 11'), (select id from cultivars where name = 'PI154846'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 12'), (select id from cultivars where name = 'PI563295'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 13'), (select id from cultivars where name = 'PI329632'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 14'), (select id from cultivars where name = 'PI329473'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 15'), (select id from cultivars where name = 'PI570075'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 25 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 2'), (select id from cultivars where name = 'PI196583'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 3'), (select id from cultivars where name = 'PI570145'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 4'), (select id from cultivars where name = 'PI329644'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 5'), (select id from cultivars where name = 'PI641807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 6'), (select id from cultivars where name = 'PI329465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 7'), (select id from cultivars where name = 'PI563009'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 8'), (select id from cultivars where name = 'PI569444'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 9'), (select id from cultivars where name = 'PI570090'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 10'), (select id from cultivars where name = 'PI585406'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 11'), (select id from cultivars where name = 'PI302252'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 12'), (select id from cultivars where name = 'PI569458'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 13'), (select id from cultivars where name = 'PI329300'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 14'), (select id from cultivars where name = 'PI525049'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 15'), (select id from cultivars where name = 'PI563222'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 26 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 2'), (select id from cultivars where name = 'PI329646'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 3'), (select id from cultivars where name = 'PI585954'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 4'), (select id from cultivars where name = 'PI329710'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 5'), (select id from cultivars where name = 'PI329541'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 6'), (select id from cultivars where name = 'PI583832'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 7'), (select id from cultivars where name = 'PI505735'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 8'), (select id from cultivars where name = 'PI329865'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 9'), (select id from cultivars where name = 'PI196049'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 10'), (select id from cultivars where name = 'PI521019'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 11'), (select id from cultivars where name = 'PI152727'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 12'), (select id from cultivars where name = 'PI585461'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 13'), (select id from cultivars where name = 'PI329403'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 14'), (select id from cultivars where name = 'PI521290'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 15'), (select id from cultivars where name = 'PI329570'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 27 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 2'), (select id from cultivars where name = 'PI329645'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 3'), (select id from cultivars where name = 'PI152771'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 4'), (select id from cultivars where name = 'PI563196'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 5'), (select id from cultivars where name = 'PI155885'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 6'), (select id from cultivars where name = 'PI563009'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 7'), (select id from cultivars where name = 'PI521152'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 8'), (select id from cultivars where name = 'PI585961'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 9'), (select id from cultivars where name = 'PI646242'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 10'), (select id from cultivars where name = 'PI569427'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 11'), (select id from cultivars where name = 'PI455221'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 12'), (select id from cultivars where name = 'PI276837'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 13'), (select id from cultivars where name = 'PI329841'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 14'), (select id from cultivars where name = 'PI156463'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 15'), (select id from cultivars where name = 'PI641835'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 28 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 2'), (select id from cultivars where name = 'PI330803'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 3'), (select id from cultivars where name = 'PI152971'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 4'), (select id from cultivars where name = 'PI303658'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 5'), (select id from cultivars where name = 'PI511355'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 6'), (select id from cultivars where name = 'PI521019'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 7'), (select id from cultivars where name = 'PI152816'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 8'), (select id from cultivars where name = 'PI257600'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 9'), (select id from cultivars where name = 'PI145619'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 10'), (select id from cultivars where name = 'PI156871'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 11'), (select id from cultivars where name = 'PI643008'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 12'), (select id from cultivars where name = 'PI154846'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 13'), (select id from cultivars where name = 'PI570091'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 14'), (select id from cultivars where name = 'PI563006'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 15'), (select id from cultivars where name = 'PI525049'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 29 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 2'), (select id from cultivars where name = 'PI154988'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 3'), (select id from cultivars where name = 'PI197542'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 4'), (select id from cultivars where name = 'PI570106'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 5'), (select id from cultivars where name = 'PI656065'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 6'), (select id from cultivars where name = 'PI513898'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 7'), (select id from cultivars where name = 'PI217691'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 8'), (select id from cultivars where name = 'PI534165'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 9'), (select id from cultivars where name = 'PI562971'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 10'), (select id from cultivars where name = 'PI35038'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 11'), (select id from cultivars where name = 'PI534120'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 12'), (select id from cultivars where name = 'PI655972'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 13'), (select id from cultivars where name = 'PI535792'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 14'), (select id from cultivars where name = 'PI576401'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 15'), (select id from cultivars where name = 'PI641830'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 30 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 2'), (select id from cultivars where name = 'PI329843'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 3'), (select id from cultivars where name = 'PI653617'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 4'), (select id from cultivars where name = 'PI156487'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 5'), (select id from cultivars where name = 'PI514456'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 6'), (select id from cultivars where name = 'PI506069'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 7'), (select id from cultivars where name = 'PI152816'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 8'), (select id from cultivars where name = 'PI521280'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 9'), (select id from cultivars where name = 'PI329699'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 10'), (select id from cultivars where name = 'PI330181'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 11'), (select id from cultivars where name = 'PI329710'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 12'), (select id from cultivars where name = 'PI330184'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 13'), (select id from cultivars where name = 'PI562994'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 14'), (select id from cultivars where name = 'PI586541'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 15'), (select id from cultivars where name = 'PI562897'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 31 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 2'), (select id from cultivars where name = 'PI329632'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 3'), (select id from cultivars where name = 'PI329550'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 4'), (select id from cultivars where name = 'PI330196'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 5'), (select id from cultivars where name = 'PI641892'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 6'), (select id from cultivars where name = 'PI157035'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 7'), (select id from cultivars where name = 'PI196598'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 8'), (select id from cultivars where name = 'PI329310'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 9'), (select id from cultivars where name = 'PI92270'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 10'), (select id from cultivars where name = 'PI152961'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 11'), (select id from cultivars where name = 'PI329673'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 12'), (select id from cultivars where name = 'PI570096'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 13'), (select id from cultivars where name = 'PI257599'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 14'), (select id from cultivars where name = 'PI563222'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 15'), (select id from cultivars where name = 'PI337680'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 32 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 2'), (select id from cultivars where name = 'PI221651'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 3'), (select id from cultivars where name = 'PI329256'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 4'), (select id from cultivars where name = 'PI152923'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 5'), (select id from cultivars where name = 'PI570090'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 6'), (select id from cultivars where name = 'PI570110'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 7'), (select id from cultivars where name = 'PI583832'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 8'), (select id from cultivars where name = 'PI329480'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 9'), (select id from cultivars where name = 'PI455307'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 10'), (select id from cultivars where name = 'PI563332'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 11'), (select id from cultivars where name = 'PI569886'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 12'), (select id from cultivars where name = 'PI157030'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 13'), (select id from cultivars where name = 'PI641829'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 14'), (select id from cultivars where name = 'PI337689'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 15'), (select id from cultivars where name = 'PI156330'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 33 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 2'), (select id from cultivars where name = 'PI506030'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 3'), (select id from cultivars where name = 'PI641862'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 4'), (select id from cultivars where name = 'PI329570'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 5'), (select id from cultivars where name = 'PI562982'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 6'), (select id from cultivars where name = 'PI586435'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 7'), (select id from cultivars where name = 'PI297155'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 8'), (select id from cultivars where name = 'PI156217'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 9'), (select id from cultivars where name = 'PI569444'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 10'), (select id from cultivars where name = 'PI569419'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 11'), (select id from cultivars where name = 'PI329351'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 12'), (select id from cultivars where name = 'PI563020'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 13'), (select id from cultivars where name = 'PI297130'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 14'), (select id from cultivars where name = 'PI646251'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 15'), (select id from cultivars where name = 'PI641850'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 34 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 2'), (select id from cultivars where name = 'PI535785'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 3'), (select id from cultivars where name = 'PI329465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 4'), (select id from cultivars where name = 'PI221548'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 5'), (select id from cultivars where name = 'PI651495'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 6'), (select id from cultivars where name = 'PI22913'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 7'), (select id from cultivars where name = 'PI297171'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 8'), (select id from cultivars where name = 'PI521290'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 9'), (select id from cultivars where name = 'PI570085'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 10'), (select id from cultivars where name = 'PI570074'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 11'), (select id from cultivars where name = 'PI176766'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 12'), (select id from cultivars where name = 'PI562997'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 13'), (select id from cultivars where name = 'PI156178'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 14'), (select id from cultivars where name = 'PI156393'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 15'), (select id from cultivars where name = 'PI570373'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 35 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 2'), (select id from cultivars where name = 'PI641807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 3'), (select id from cultivars where name = 'PI152966'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 4'), (select id from cultivars where name = 'PI329665'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 5'), (select id from cultivars where name = 'PI570114'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 6'), (select id from cultivars where name = 'PI251672'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 7'), (select id from cultivars where name = 'PI22913'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 8'), (select id from cultivars where name = 'PI455280'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 9'), (select id from cultivars where name = 'PI452692'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 10'), (select id from cultivars where name = 'PI641815'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 11'), (select id from cultivars where name = 'PI154987'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 12'), (select id from cultivars where name = 'PI329584'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 13'), (select id from cultivars where name = 'PI570087'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 14'), (select id from cultivars where name = 'PI329711'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 15'), (select id from cultivars where name = 'PI453696'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 36 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 2'), (select id from cultivars where name = 'PI643016'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 3'), (select id from cultivars where name = 'PI152591'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 4'), (select id from cultivars where name = 'PI585577'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 5'), (select id from cultivars where name = 'PI569423'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 6'), (select id from cultivars where name = 'PI329510'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 7'), (select id from cultivars where name = 'PI562730'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 8'), (select id from cultivars where name = 'PI569264'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 9'), (select id from cultivars where name = 'PI455217'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 10'), (select id from cultivars where name = 'PI562732'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 11'), (select id from cultivars where name = 'PI196583'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 12'), (select id from cultivars where name = 'PI563350'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 13'), (select id from cultivars where name = 'PI653616'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 14'), (select id from cultivars where name = 'PI152727'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 15'), (select id from cultivars where name = 'PI562990'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 37 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 2'), (select id from cultivars where name = 'PI329541'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 3'), (select id from cultivars where name = 'PI329473'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 4'), (select id from cultivars where name = 'PI146890'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 5'), (select id from cultivars where name = 'PI570076'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 6'), (select id from cultivars where name = 'PI641824'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 7'), (select id from cultivars where name = 'PI651491'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 8'), (select id from cultivars where name = 'PI570145'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 9'), (select id from cultivars where name = 'PI213900'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 10'), (select id from cultivars where name = 'PI255239'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 11'), (select id from cultivars where name = 'PI152967'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 12'), (select id from cultivars where name = 'PI570038'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 13'), (select id from cultivars where name = 'PI506122'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 14'), (select id from cultivars where name = 'PI154944'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 15'), (select id from cultivars where name = 'PI656035'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 38 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 2'), (select id from cultivars where name = 'PI563331'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 3'), (select id from cultivars where name = 'PI156268'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 4'), (select id from cultivars where name = 'PI330195'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 5'), (select id from cultivars where name = 'PI153877'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 6'), (select id from cultivars where name = 'PI167093'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 7'), (select id from cultivars where name = 'PI329300'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 8'), (select id from cultivars where name = 'PI569460'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 9'), (select id from cultivars where name = 'PI154844'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 10'), (select id from cultivars where name = 'PI330833'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 11'), (select id from cultivars where name = 'PI570388'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 12'), (select id from cultivars where name = 'PI569447'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 13'), (select id from cultivars where name = 'PI329865'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 14'), (select id from cultivars where name = 'PI566819'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 15'), (select id from cultivars where name = 'PI573193'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 39 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 2'), (select id from cultivars where name = 'PI196586'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 3'), (select id from cultivars where name = 'PI455301'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 4'), (select id from cultivars where name = 'PI585406'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 5'), (select id from cultivars where name = 'PI452542'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 6'), (select id from cultivars where name = 'PI63715'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 7'), (select id from cultivars where name = 'PI155516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 8'), (select id from cultivars where name = 'PI620072'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 9'), (select id from cultivars where name = 'PI330199'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 10'), (select id from cultivars where name = 'PI330182'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 11'), (select id from cultivars where name = 'PI175919'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 12'), (select id from cultivars where name = 'PI569420'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 13'), (select id from cultivars where name = 'PI156871'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 14'), (select id from cultivars where name = 'PI585608'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 15'), (select id from cultivars where name = 'PI655983'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 40 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 2'), (select id from cultivars where name = 'PI329545'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 3'), (select id from cultivars where name = 'PI505717'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 4'), (select id from cultivars where name = 'PI562985'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 5'), (select id from cultivars where name = 'PI329519'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 6'), (select id from cultivars where name = 'PI330796'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 7'), (select id from cultivars where name = 'PI329471'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 8'), (select id from cultivars where name = 'PI329517'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 9'), (select id from cultivars where name = 'PI329864'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 10'), (select id from cultivars where name = 'PI563021'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 11'), (select id from cultivars where name = 'PI144134'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 12'), (select id from cultivars where name = 'PI329517'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 13'), (select id from cultivars where name = 'PI152694'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 14'), (select id from cultivars where name = 'PI641860'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 15'), (select id from cultivars where name = 'PI585954'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 41 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 2'), (select id from cultivars where name = 'PI641825'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 3'), (select id from cultivars where name = 'PI330807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 4'), (select id from cultivars where name = 'PI329614'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 5'), (select id from cultivars where name = 'PI535794'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 6'), (select id from cultivars where name = 'PI527045'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 7'), (select id from cultivars where name = 'PI562981'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 8'), (select id from cultivars where name = 'PI576399'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 9'), (select id from cultivars where name = 'PI329506'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 10'), (select id from cultivars where name = 'PI533998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 11'), (select id from cultivars where name = 'PI655978'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 12'), (select id from cultivars where name = 'PI570073'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 13'), (select id from cultivars where name = 'PI152965'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 14'), (select id from cultivars where name = 'PI585966'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 15'), (select id from cultivars where name = 'PI569422'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 42 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 2'), (select id from cultivars where name = 'PI510757'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 3'), (select id from cultivars where name = 'PI563338'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 4'), (select id from cultivars where name = 'PI329333'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 5'), (select id from cultivars where name = 'PI563355'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 6'), (select id from cultivars where name = 'PI155760'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 7'), (select id from cultivars where name = 'PI563032'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 8'), (select id from cultivars where name = 'PI329394'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 9'), (select id from cultivars where name = 'PI329319'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 10'), (select id from cultivars where name = 'PI152733'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 11'), (select id from cultivars where name = 'PI154750'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 12'), (select id from cultivars where name = 'PI196049'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 13'), (select id from cultivars where name = 'PI329338'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 14'), (select id from cultivars where name = 'PI563329'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 15'), (select id from cultivars where name = 'PI330169'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 43 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 2'), (select id from cultivars where name = 'PI641817'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 3'), (select id from cultivars where name = 'PI533902'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 4'), (select id from cultivars where name = 'PI656015'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 5'), (select id from cultivars where name = 'PI535796'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 6'), (select id from cultivars where name = 'PI620157'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 7'), (select id from cultivars where name = 'PI646266'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 8'), (select id from cultivars where name = 'PI585467'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 9'), (select id from cultivars where name = 'PI52606'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 10'), (select id from cultivars where name = 'PI329501'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 11'), (select id from cultivars where name = 'PI35038'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 12'), (select id from cultivars where name = 'PI329326'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 13'), (select id from cultivars where name = 'PI524475'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 14'), (select id from cultivars where name = 'PI526905'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 15'), (select id from cultivars where name = 'PI569445'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 44 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 2'), (select id from cultivars where name = 'PI329546'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 3'), (select id from cultivars where name = 'PI329646'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 4'), (select id from cultivars where name = 'PI229841'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 5'), (select id from cultivars where name = 'PI330185'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 6'), (select id from cultivars where name = 'PI569462'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 7'), (select id from cultivars where name = 'PI569465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 8'), (select id from cultivars where name = 'PI562998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 9'), (select id from cultivars where name = 'PI585452'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 10'), (select id from cultivars where name = 'PI569458'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 11'), (select id from cultivars where name = 'PI563330'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 12'), (select id from cultivars where name = 'PI562970'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 13'), (select id from cultivars where name = 'PI569244'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 14'), (select id from cultivars where name = 'PI641810'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 15'), (select id from cultivars where name = 'PI330858'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 45 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 2'), (select id from cultivars where name = 'PI535795'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 3'), (select id from cultivars where name = 'PI180348'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 4'), (select id from cultivars where name = 'PI570071'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 5'), (select id from cultivars where name = 'PI329478'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 6'), (select id from cultivars where name = 'PI152651'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 7'), (select id from cultivars where name = 'PI593916'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 8'), (select id from cultivars where name = 'PI570109'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 9'), (select id from cultivars where name = 'PI564163'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 10'), (select id from cultivars where name = 'PI561840'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 11'), (select id from cultivars where name = 'PI641909'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 12'), (select id from cultivars where name = 'PI655972'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 13'), (select id from cultivars where name = 'PI563002'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 14'), (select id from cultivars where name = 'PI329518'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 15'), (select id from cultivars where name = 'PI569421'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 46 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 2'), (select id from cultivars where name = 'PI585454'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 3'), (select id from cultivars where name = 'PI570431'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 4'), (select id from cultivars where name = 'PI329605'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 5'), (select id from cultivars where name = 'PI156326'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 6'), (select id from cultivars where name = 'PI642998'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 7'), (select id from cultivars where name = 'PI569148'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 8'), (select id from cultivars where name = 'PI569097'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 9'), (select id from cultivars where name = 'PI619838'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 10'), (select id from cultivars where name = 'PI569453'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 11'), (select id from cultivars where name = 'PI152730'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 12'), (select id from cultivars where name = 'PI505722'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 13'), (select id from cultivars where name = 'PI302252'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 14'), (select id from cultivars where name = 'PI229841'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 15'), (select id from cultivars where name = 'PI145626'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 47 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 2'), (select id from cultivars where name = 'PI570031'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 3'), (select id from cultivars where name = 'PI569452'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 4'), (select id from cultivars where name = 'PI570075'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 5'), (select id from cultivars where name = 'PI145633'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 6'), (select id from cultivars where name = 'PI651496'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 7'), (select id from cultivars where name = 'PI619807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 8'), (select id from cultivars where name = 'PI273465'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 9'), (select id from cultivars where name = 'PI562781'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 10'), (select id from cultivars where name = 'PI329403'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 11'), (select id from cultivars where name = 'PI570254'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 12'), (select id from cultivars where name = 'PI273969'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 13'), (select id from cultivars where name = 'PI562991'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 14'), (select id from cultivars where name = 'PI569455'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 15'), (select id from cultivars where name = 'PI329585'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 48 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 2'), (select id from cultivars where name = 'PI641807'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 3'), (select id from cultivars where name = 'PI156890'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 4'), (select id from cultivars where name = 'PI570400'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 5'), (select id from cultivars where name = 'PI585461'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 6'), (select id from cultivars where name = 'PI329466'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 7'), (select id from cultivars where name = 'PI329702'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 8'), (select id from cultivars where name = 'PI569457'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 9'), (select id from cultivars where name = 'PI329286'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 10'), (select id from cultivars where name = 'PI329618'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 11'), (select id from cultivars where name = 'PI651497'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 12'), (select id from cultivars where name = 'PI506114'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 13'), (select id from cultivars where name = 'PI329511'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 14'), (select id from cultivars where name = 'PI152862'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 15'), (select id from cultivars where name = 'PI329301'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 49 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 2'), (select id from cultivars where name = 'PI641821'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 3'), (select id from cultivars where name = 'PI540518'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 4'), (select id from cultivars where name = 'PI656026'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 5'), (select id from cultivars where name = 'PI570042'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 6'), (select id from cultivars where name = 'PI569443'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 7'), (select id from cultivars where name = 'PI218112'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 8'), (select id from cultivars where name = 'PI330196'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 9'), (select id from cultivars where name = 'PI329435'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 10'), (select id from cultivars where name = 'PI651491'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 11'), (select id from cultivars where name = 'PI535796'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 12'), (select id from cultivars where name = 'PI569090'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 13'), (select id from cultivars where name = 'PI152828'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 14'), (select id from cultivars where name = 'PI641836'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 15'), (select id from cultivars where name = 'PI179749'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 50 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 2'), (select id from cultivars where name = 'PI19770'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 3'), (select id from cultivars where name = 'PI157804'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 4'), (select id from cultivars where name = 'PI152860'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 5'), (select id from cultivars where name = 'PI563022'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 6'), (select id from cultivars where name = 'PI267573'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 7'), (select id from cultivars where name = 'PI620157'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 8'), (select id from cultivars where name = 'PI452619'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 9'), (select id from cultivars where name = 'PI505735'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 10'), (select id from cultivars where name = 'PI170787'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 11'), (select id from cultivars where name = 'PI266927'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 12'), (select id from cultivars where name = 'PI329644'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 13'), (select id from cultivars where name = 'PI569418'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 14'), (select id from cultivars where name = 'PI195754'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 15'), (select id from cultivars where name = 'PI563295'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 51 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 8'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 9'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 10'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 11'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 52 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 8'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 9'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 10'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 11'), (select id from cultivars where name = 'PI329440'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 53 Column 16'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 1'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 2'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 3'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 4'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 5'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 6'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 7'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 8'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 9'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 10'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 11'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 12'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 13'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 14'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 15'), (select id from cultivars where name = 'SP1516'));
insert into sites_cultivars (site_id, cultivar_id) values ((select id from sites where sitename = 'MAC Field Scanner Season 6 Range 54 Column 16'), (select id from cultivars where name = 'SP1516'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment