ref #4670 fix BerlinModelTaxonImport for non-EuroMed

diff --git a/app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelTaxonImport.java b/app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelTaxonImport.java
index 8c12aeb2a34da13029758e5d87213522479ed6bd..2a072779944eab8649fe26a3826159522a578fce 100644 (file)
--- a/app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelTaxonImport.java
+++ b/app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelTaxonImport.java
@@ -109,7 +109,7 @@ public class BerlinModelTaxonImport  extends BerlinModelImportBase {
 
        @Override
        protected String getRecordQuery(BerlinModelImportConfigurator config) {
-               String sqlSelect = " SELECT pt.* , n.notes nameNotes";
+               String sqlSelect = " SELECT pt.* ";
                String sqlFrom = " FROM PTaxon pt ";
                if (config.isEuroMed()){
                        sqlFrom = " FROM PTaxon AS pt "
@@ -118,7 +118,7 @@ public class BerlinModelTaxonImport  extends BerlinModelImportBase {
                        if (!config.isUseLastScrutinyAsSec()){
                            sqlFrom += " LEFT OUTER JOIN Reference r ON pt.LastScrutinyFk = r.RefId ";
                        }
-                       sqlSelect += " , em.MA ";
+                       sqlSelect += ", n.notes nameNotes , em.MA ";
                        if (!config.isUseLastScrutinyAsSec()){
                            sqlSelect += ", r.RefCache as LastScrutiny ";
             }