bugfix for E+M classification import

diff --git a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
index 535511341afdb25e7c9f502b99f5742edb2f5168..bcd27eef65dbc505d62301dcc98db8a51ceb9f4b 100644 (file)
--- a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
+++ b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java
@@ -87,7 +87,7 @@ public class EuroMedActivator {
        static boolean  isSplitTdwgCodes = false;\r
        \r
        static String taxonTable = "v_cdm_exp_taxaAll";\r
-       static String classificationQuery = " SELECT DISTINCT t.PTRefFk, r.RefCache FROM _EM_CDM_exp_taxaDirect t INNER JOIN Reference r ON t.PTRefFk = r.RefId "; \r
+       static String classificationQuery = " SELECT DISTINCT t.PTRefFk, r.RefCache FROM PTaxon t INNER JOIN Reference r ON t.PTRefFk = r.RefId WHERE t.PTRefFk = " + sourceSecId; \r
        static String relPTaxonIdQuery = " SELECT r.RelPTaxonId " + \r
                                        " FROM RelPTaxon AS r INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk ";\r
        static String nameIdTable = " v_cdm_exp_namesAll ";\r