0 && $_GET['searchtype'] == 'searchcompare' && $_GET['comparisontype'] == 'head') { $varietyCList = rtrim($varietyCList, ","); $getHeadtoHeadList = "select a.field_id_4, a.entry_id, a.field_id_4 as variety, a.field_id_34 as results, a.field_id_6 as year, a.field_id_5 as town, a.field_id_30 as province from exp_channel_data a inner join (select field_id_4, field_id_34, field_id_6, field_id_5, field_id_30 from exp_channel_data where field_id_4 in (".$varietyCList.") group by field_id_30, field_id_5, field_id_6 having count(*)=".$varietyCount." ) b on (a.field_id_6 = b.field_id_6) and (a.field_id_5 = b.field_id_5) and (a.field_id_30 = b.field_id_30) order by year, province, town, variety"; $query = $this->EE->db->query($getHeadtoHeadList); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $validEntries = $validEntries . $row->entry_id . ","; } $validEntries = rtrim($validEntries,","); } } $searchIntro = "SELECT REPLACE (D.field_id_31, ' ', '-') as short_herbicide, ROUND(REPLACE(D.field_id_12,'$',''),2) as gross_revenue, D.field_id_6 as trial_year, D.field_id_32 as season_zone, D.field_id_30 as province, ROUND(D.field_id_8,1) as yield, ROUND(D.field_id_9,1) as dtm, ROUND(D.field_id_10,1) as lodging, ROUND(D.field_id_11,1) as height, D.field_id_4 as variety, D.field_id_5 as trial_location,D.field_id_30 as location_province, D.field_id_33 as trial_type FROM exp_channel_data D "; $locationList = "select distinct D.field_id_30 as province, D.field_id_5 as location from exp_channel_data D "; $searchSelectSmall = ""; $searchSelectSmall .= "WHERE D.channel_id = '3' "; //zone type if(isset($_GET['zone-type']) && $_GET['zone-type'] != '' && $_GET['zone-type'] != 'all') { $searchSelectSmall .= " AND field_id_32 = '".$_GET['zone-type']."'"; } if(isset($_GET['town']) && $_GET['town'] != '') { $searchSelectSmall .= " AND field_id_5 = '".$_GET['town']."'"; } if(isset($_GET['province']) && $_GET['province'] != '' && $_GET['province'] != 'all') { $searchSelectSmall .= " AND field_id_30 = '".$_GET['province']."'"; } //herbicides $searchHerbs = "("; $atLeast1 = 0; if(isset($_GET['herbicides-roundup-ready']) && $_GET['herbicides-roundup-ready'] != '') { $searchHerbs .= "D.field_id_31 = 'Roundup Ready' or "; $atLeast1 = 1; } if(isset($_GET['herbicides-liberty-link']) && $_GET['herbicides-liberty-link'] != '') { $searchHerbs .= "D.field_id_31 = 'Liberty Link' or "; $atLeast1 = 1; } if(isset($_GET['herbicides-clearfield']) && $_GET['herbicides-clearfield'] != '') { $searchHerbs .= "D.field_id_31 = 'Clearfield' or "; $atLeast1 = 1; } $searchHerbs = substr($searchHerbs, 0, -4); $searchHerbs .= ") "; if($atLeast1 == 1) { $searchSelectSmall .= " AND ".$searchHerbs; } //year(s) $searchYears = "("; if(isset($_GET['2018']) && $_GET['2017'] == '2018') { $searchYears .= "D.field_id_6 = '2018' or "; } if(isset($_GET['2017']) && $_GET['2017'] == '2017') { $searchYears .= "D.field_id_6 = '2017' or "; } if(isset($_GET['2016']) && $_GET['2016'] == '2016') { $searchYears .= "D.field_id_6 = '2016' or "; } if(isset($_GET['2015']) && $_GET['2015'] == '2015') { $searchYears .= "D.field_id_6 = '2015' or "; } if(isset($_GET['2014']) && $_GET['2014'] == '2014') { $searchYears .= "D.field_id_6 = '2014' or "; } if(isset($_GET['2013']) && $_GET['2013'] == '2013') { $searchYears .= "D.field_id_6 = '2013' or "; } if(isset($_GET['2012']) && $_GET['2012'] == '2012') { $searchYears .= "D.field_id_6 = '2012' or "; } if(isset($_GET['2011']) && $_GET['2011'] == '2011') { $searchYears .= "D.field_id_6 = '2011' or "; } $searchYears = substr($searchYears, 0, -4); $searchYears .= ") "; if($searchYears != "() ") { //$searchSelect .= " AND ".$searchYears; $searchSelectSmall .= " AND ".$searchYears; } if($_GET['variety2'] != "") { $searchVarieties = "("; if(isset($_GET['variety1']) && $_GET['variety1'] != '') { $searchVarieties .= "D.field_id_4 = '".$_GET['variety1']."' or "; } if(isset($_GET['variety2']) && $_GET['variety2'] != '') { $searchVarieties .= "D.field_id_4 = '".$_GET['variety2']."' or "; } if(isset($_GET['variety3']) && $_GET['variety3'] != '') { $searchVarieties .= "D.field_id_4 = '".$_GET['variety3']."' or "; } $searchVarieties = substr($searchVarieties, 0, -4); $searchVarieties .= ") "; if($searchVarieties != "() ") { //$searchSelect .= " AND ".$searchYears; $searchSelectSmall .= " AND ".$searchVarieties; } } if($validEntries != "") { $searchSelectSmall = $searchSelectSmall . " AND entry_id in (".$validEntries.") "; } if(isset($_GET['trial-type']) && $_GET['trial-type'] != '' && $_GET['trial-type'] != 'all') { $searchSelectSmall .= " AND D.field_id_33 = '".$_GET['trial-type']."'"; } $locationList = $locationList . $searchSelectSmall; $searchSelectSmall = $searchIntro . $searchSelectSmall; ?>

Canola Performance Trials

What's this?
 2011    2012    2013    2014    2015    2016    2017    2018  
Herbicides:*
Reset Custom Filters

Search Results

" data-filter="">
*SY4157, sponsored by Syngenta, was previously named 09H7757 and sponsored by Cargill in 2013.
Yield
" data-filter="">
Days to Maturity
" data-filter="">
Height
" data-filter="">
Lodging
" data-filter="">
*SY4157, sponsored by Syngenta, was previously named 09H7757 and sponsored by Cargill in 2013.

Trial Result Data

Variety Location Year Trial Type Zone Yield DTM Lodging Height Gross Revenue

Map pin placements are not exact locations. The pin placement is generated by Google Maps using the town name and province.

Map pins may take a few seconds to fully load.

Seasons