## Correcting (mostly deleting) synonyms listed by Rolando in tree checklist
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen,' ',SINONIMOsp)='Ilex valerioi');
UPDATE stagePanamaTree.complete SET SINONIMOgen='Ilex', SINONIMOsp='valerii' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2,' ',SINONIMOsp2)='Ilex valerioi');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='Ilex', SINONIMOsp2='valerii' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen,' ',SINONIMOsp)='Tabernaemontana gentriana');
UPDATE stagePanamaTree.complete SET SINONIMOgen='Tabernaemontana', SINONIMOsp='gentryana' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2,' ',SINONIMOsp2)='Tabernaemontana gentriana');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='Tabernaemontana', SINONIMOsp2='gentryana' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen,' ',SINONIMOsp)='Guatteriopsis sessiliflora');
UPDATE stagePanamaTree.complete SET SINONIMOgen='Guatteria', SINONIMOsp='blepharophylla' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2,' ',SINONIMOsp2)='Guatteriopsis sessiliflora');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='Guatteria', SINONIMOsp2='blepharophylla' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen,' ',SINONIMOsp)='Rollina membranacea');
UPDATE stagePanamaTree.complete SET SINONIMOgen='Rollinia', SINONIMOsp='membranacea' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2,' ',SINONIMOsp2)='Rollina membranacea');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='Rollinia', SINONIMOsp2='membranacea' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen,' ',SINONIMOsp)='Hamelia storkii Standl.');
UPDATE stagePanamaTree.complete SET SINONIMOgen='Hamelia', SINONIMOsp='storkii' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2,' ',SINONIMOsp2)='Hamelia storkii Standl.');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='Hamelia', SINONIMOsp2='storkii' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Ilex discolor');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Ilex discolor');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Sambucus nigra');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Sambucus nigra');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Tovomita krukovii');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Tovomita krukovii');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Tovomita macrophylla');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Tovomita macrophylla');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Ocotea glomerata');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Ocotea glomerata');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Bactris baileyana');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Bactris baileyana');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Chamaedorea humilis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Chamaedorea humilis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Chamaedorea zamorae');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Chamaedorea zamorae');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Geonoma calyptrogynoidea');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Geonoma calyptrogynoidea');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Geonoma orbignyana');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Geonoma orbignyana');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Geonoma lehmannii');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Geonoma lehmannii');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Miconia hyperprasina');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Miconia hyperprasina');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Trichilia cipo');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Trichilia cipo');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Eugenia chrysophyllum');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Eugenia chrysophyllum');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Acacia micrantha');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Acacia micrantha');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Inga cordistipula');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Inga cordistipula');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Ardisia longicaudata');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Ardisia longicaudata');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Clavija jelskii');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Clavija jelskii');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Malvaviscus longifolius');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Malvaviscus longifolius');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Neea elegans');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Neea elegans');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Neea psychotrioides');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Neea psychotrioides');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Guapira myrtifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Guapira myrtifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Chromolucuma congestifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Chromolucuma congestifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Richeria obovata');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Richeria obovata');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Cestrum standleyi');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Cestrum standleyi');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Sapium jamaicense');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Sapium jamaicense');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Piper cumanense');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Piper cumanense');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Piper fimbriulatum');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Piper fimbriulatum');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Piper peracuminatum');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Piper peracuminatum');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Piper amalgo');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Piper amalgo');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Quercus copeyensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Quercus copeyensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Quercus bumelioides');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Quercus bumelioides');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Ardisia opaca');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Ardisia opaca');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Ardisia perinsignis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Ardisia perinsignis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Parathesis montana');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Parathesis montana');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Chamaedorea matae');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Chamaedorea matae');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Clusia cooperi');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Clusia cooperi');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Guarea tonduzii');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Guarea tonduzii');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Byrsonima nemoralis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Byrsonima nemoralis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Carapa nicaraguensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Carapa nicaraguensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Myrcia coumete');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Myrcia coumete');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Simarouba glauca');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Simarouba glauca');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Piper culebranum');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Piper culebranum');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Casearia stjohnii');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Casearia stjohnii');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Xylosma cinerea');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Xylosma cinerea');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Coussarea veraguensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Coussarea veraguensis');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Posoqueria grandiflora');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Posoqueria grandiflora');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Leandra melanodesma');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Leandra melanodesma');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen, ' ', SINONIMOsp)='Heisteria latifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen='', SINONIMOsp='' WHERE id=@badrow;
SET @badrow=(SELECT id FROM stagePanamaTree.complete WHERE CONCAT(SINONIMOgen2, ' ', SINONIMOsp2)='Heisteria latifolia');
UPDATE stagePanamaTree.complete SET SINONIMOgen2='', SINONIMOsp2='' WHERE id=@badrow;

