select m.id, m.TimePeriodCoveredEnd, v.study_id from metadata m, studyversion v where v.study_id = 121855 and m.id = v.metadata_id and TimePeriodCoveredEnd = '[17820000]';

select m.id, m.DistributionDate, v.study_id from metadata m, studyversion v where v.study_id = 117326 and m.id = v.metadata_id and DistributionDate = '2O14';

select m.id, a.date, v.study_id from metadata m, studyversion v, studyabstract a where v.study_id=47799 and m.id=v.metadata_id and m.id=a.metadata_id and a.date='201-';

select m.id, m.TimePeriodCoveredEnd, v.study_id from metadata m, studyversion v where v.study_id = 88283 and m.id = v.metadata_id and TimePeriodCoveredEnd = '198x';

select m.id, m.TimePeriodCoveredStart, v.study_id from metadata m, studyversion v where v.study_id = 215 and m.id = v.metadata_id and TimePeriodCoveredStart = '70s'; --should return 3 records

select m.id, a.date, v.study_id from metadata m, studyversion v, studyabstract a where v.study_id=91709 and m.id=v.metadata_id and m.id=a.metadata_id and a.date='2-13'; --should return 3 records

select m.id, a.date, v.study_id from metadata m, studyversion v, studyabstract a where v.study_id=114372 and m.id=v.metadata_id and m.id=a.metadata_id and a.date='2-14';

select m.id, m.DateOfCollectionStart, m.DateOfCollectionEnd, v.study_id from metadata m, studyversion v where v.study_id = 155 and m.id = v.metadata_id and DateOfCollectionStart = '2004-01-01 to 2004-12-31' and m.DateOfCollectionEnd = '' ; -- should return 10 records

update metadata set TimePeriodCoveredEnd = '1782' from studyversion v where v.study_id = 121855 and metadata.id = v.metadata_id and TimePeriodCoveredEnd = '[17820000]';

update metadata set DistributionDate = '2014' from studyversion v where v.study_id = 117326 and metadata.id = v.metadata_id and DistributionDate = '2O14';

update studyabstract set date = '2010' from metadata m, studyversion v where v.study_id=47799 and m.id=v.metadata_id and m.id=studyabstract.metadata_id and studyabstract.date='201-';

update metadata set TimePeriodCoveredEnd = '198?' from studyversion v where v.study_id = 88283 and metadata.id = v.metadata_id and TimePeriodCoveredEnd = '198x';

update metadata set TimePeriodCoveredStart = '197?' from studyversion v where v.study_id = 215 and metadata.id = v.metadata_id and TimePeriodCoveredStart = '70s'; --should update 3 records

update studyabstract set date = '2014' from metadata m, studyversion v where v.study_id=114372 and m.id=v.metadata_id and m.id=studyabstract.metadata_id and studyabstract.date='2-14';

update studyabstract set date = '2013' from metadata m, studyversion v where v.study_id=91709 and m.id=v.metadata_id and m.id=studyabstract.metadata_id and studyabstract.date='2-13'; --should update 3 records

update metadata set DateOfCollectionStart = '2004-01-01', DateOfCollectionEnd = '2004-12-31' from studyversion v where v.study_id = 155 and metadata.id = v.metadata_id and DateOfCollectionStart = '2004-01-01 to 2004-12-31' and DateOfCollectionEnd = ''; -- should update 10 records

update studyfieldvalue set strvalue='English' where metadata_id=273999 and studyfield_id=218 and strValue='English and Dutch';

insert into studyfieldvalue (strvalue, metadata_id, studyfield_id, displayorder) values ('Dutch', 273999,218,1);

--Added for datasets with multiple failues 3/30

select m.id, m.TimePeriodCoveredStart, v.study_id from metadata m, studyversion v where v.study_id = 88283 and m.id = v.metadata_id and TimePeriodCoveredStart = '198x';

select m.id, m.TimePeriodCoveredStart, v.study_id from metadata m, studyversion v where v.study_id = 121855 and m.id = v.metadata_id and TimePeriodCoveredStart = '[17820000]';

select m.id, m.ProductionDate, v.study_id from metadata m, studyversion v where v.study_id = 121855 and m.id = v.metadata_id and ProductionDate = '[17820000]';

select m.id, m.dateofdeposit, v.study_id from metadata m, studyversion v where v.study_id = 74738 and m.id = v.metadata_id and dateofdeposit = '\';

update metadata set TimePeriodCoveredStart = '198?' from studyversion v where v.study_id = 88283 and metadata.id = v.metadata_id and TimePeriodCoveredStart = '198x';

update metadata set ProductionDate = '1782' from studyversion v where v.study_id = 121855 and metadata.id = v.metadata_id and ProductionDate = '[17820000]';

update metadata set TimePeriodCoveredStart = '1782' from studyversion v where v.study_id = 121855 and metadata.id = v.metadata_id and TimePeriodCoveredStart = '[17820000]';

update metadata set dateofdeposit = '' from studyversion v where v.study_id = 74738 and metadata.id = v.metadata_id and dateofdeposit = '\';