select * from traits_and_yields_view_private where cultivar = 'PI642998' and sitename like '%Season 6%' and trait = 'canopy_cover' and date = '2018 Jun 27' and checked > -1 order by id desc;
select created_at, mean, variable_id, method_id, citation_id from traits where id in (6004317107, 6004316701, 6004310913, 6004310507);
select created_at, mean, variable_id, site_id, method_id, citation_id, access_level from traits where id in (6004317256, 6004316540, 6004311062, 6004310346);
select variable_id, count(*) as n from traits where created_at between '2019-05-31 10:30' and '2019-05-31 11:00' group by variable_id order by n desc
Suggested Correction
figure out which are correct (prob. the most recent) and delete the others.
select variable_id, count(*) as n from traits where created_at between '2019-05-31 12:30' and '2019-05-31 12:50' group by variable_id order by n desc
Dataset
Suggested Correction
figure out which are correct (prob. the most recent) and delete the others.