EDIT

        return equals("CommonName count ", countSrc, countDest, String.valueOf(-1));

    }

    private final String countTaxon = "SELECT count(*) FROM tu WHERE id " + moneraFilter;

    private boolean testTaxaCount() {

                + " FROM tu t "

                + " LEFT JOIN tu as tu1 on t.tu_parent = tu1.id "

                + " LEFT JOIN (SELECT DISTINCT rank_id, rank_name FROM ranks WHERE NOT(rank_id = 30 AND rank_name = 'Phylum (Division)' OR rank_id = 40 AND rank_name = 'Subphylum (Subdivision)' OR rank_id = 122 AND rank_name='Subsection')) as r ON t.tu_rank = r.rank_id "

                + " LEFT JOIN status st ON st.status_id = t.tu_status "

                + " LEFT JOIN tu type ON type.id = t.tu_typetaxon "

                + " LEFT JOIN fossil fo ON t.tu_fossil = fo.fossil_id "

        ResultSet srcRS = source.getResultSet(""

                + " SELECT t.* "

                + " FROM tu t "

                + " ORDER BY CAST(t.id as nvarchar(20)) ");

        ResultSet destRS = destination.getResultSet("SELECT rel.*, t1.IdInSource t1Id, t2.IdInSource t2Id "

                + " FROM RelTaxon rel "

    private boolean testSingleTaxonRelation(ResultSet srcRS, ResultSet destRS) throws SQLException {

        String id = String.valueOf(srcRS.getInt("id"));

        boolean success = equals("Taxon relation taxon1", "tu_id: " + srcRS.getInt("id"), destRS.getString("t1Id"), id);

        success &= equals("Taxon relation qualifier fk", PesiTransformer.IS_SYNONYM_OF, destRS.getInt("RelTaxonQualifierFk"), id);

        success &= equals("Taxon relation qualifier cache", "is synonym of", destRS.getString("RelQualifierCache"), id);

        //TODO enable after next import

    private boolean testSingleSynonymRelation(ResultSet srcRS, ResultSet destRS) throws SQLException {

        String id = String.valueOf(srcRS.getInt("id"));

        boolean success = equals("Taxon relation taxon1", "NameId: " + srcRS.getInt("id"), destRS.getString("t1Id"), id);

        success &= equals("Taxon relation qualifier fk", PesiTransformer.IS_SYNONYM_OF, destRS.getInt("RelTaxonQualifierFk"), id);

        success &= equals("Taxon relation qualifier cache", "is synonym of", destRS.getString("RelQualifierCache"), id);

        //TODO enable after next import

	@Override

	protected String getRecordQuery(ErmsImportConfigurator config) {

		String strRecordQuery =

	                  " s.sessiondate lastActionDate, a.action_name lastAction, s.ExpertName " +

			" FROM dr INNER JOIN tu ON dr.tu_id = tu.id " +

            "     LEFT OUTER JOIN dr_sessions MN ON MN.dr_id = dr.id " +

		String distributionTable = "dr";

		String notesTable = "notes";

		String sql =

                + " UNION  SELECT DISTINCT %s FROM %s " //vernaculars

		        + " UNION  SELECT DISTINCT %s FROM %s "  //distributions

		        + " UNION  SELECT DISTINCT %s FROM %s ";  //notes

	@Override

	public TaxonBase<?> createObject(ResultSet rs, ErmsImportState state) throws SQLException {

		int statusId = rs.getInt("status_id");

		Integer meId = rs.getInt("id");

        TaxonName taxonName = getTaxonName(rs, state);

			    = DbImportTaxIncludedInMapper.NewInstance("id", TAXON_NAMESPACE, "accId", TAXON_NAMESPACE, "parentAccId", TAXON_NAMESPACE, null);

			mapping.addMapper(includedIn);//there is only one tree

			//synonym

			        "tu_unacceptreason", null, null, true));

			//type designations

			mapping.addMapper(DbImportNameTypeDesignationMapper.NewInstance("id", "tu_typetaxon", ErmsImportBase.NAME_NAMESPACE, "tu_typedesignationstatus"));

		//TODO get automatic by second path mappers

		String selectAttributes =

		    "   myTaxon.id, myTaxon.tu_parent, myTaxon.tu_typetaxon, myTaxon.tu_typedesignation, "

			+ " parent.tu_status AS parentStatus, parent.id AS parentId, "

		    + " parentAcc.id AS parentAccId,"

		    + " accTaxon.tu_parent accParentId, "

		String strRecordQuery =

			"   SELECT  " + selectAttributes

			+ " FROM tu AS myTaxon "

			+ "   LEFT JOIN tu AS parent ON myTaxon.tu_parent = parent.id "

			+ " WHERE ( myTaxon.id IN (" + ID_LIST_TOKEN + ") )";

		return strRecordQuery;

	}

			Set<String> nameIdSet = new HashSet<>();

			while (rs.next()){

			    handleForeignKey(rs, taxonIdSet, "accId");

				handleForeignKey(rs, taxonIdSet, "id");

				handleForeignKey(rs, nameIdSet, "tu_typetaxon");

				handleForeignKey(rs, nameIdSet, "id");

		    //here we should add the direct parent or the accepted taxon of the parent

		    return !isAccepted;

		}else if (mapper instanceof DbImportSynonymMapper){

	        // accepted taxon.

	        //So the synonym relation is clearly defined, no matter which status

	        //both related taxa have.

    private boolean isAccepted(ResultSet rs) throws SQLException {

        int id = rs.getInt("id");

        Object accParentId = rs.getObject("accParentId");

        boolean isAccepted = false;

	@Override

	protected String getRecordQuery(ErmsImportConfigurator config) {

		String strRecordQuery =

			       " s.sessiondate lastActionDate, a.action_name lastAction, s.ExpertName " +

			" FROM vernaculars v INNER JOIN tu ON v.tu_id = tu.id " +

			"     LEFT OUTER JOIN languages l ON l.LanID = v.lan_id " +

		try {

			boolean result = true;

			Source source = bmiConfig.getSource();

						" tu.tu_authority, tu.tu_displayname, status.status_name "  +

				" FROM  tu_sources " +

					" INNER JOIN sourceuses ON tu_sources.sourceuse_id = sourceuses.sourceuse_id " +

				i++;

				if (firstRow){

					System.out.println("========================================================");

					System.out.println("========================================================");

				}

				int id = rs.getInt("id");

                      " parentAcc.tu_status AS Expr1 " +

                " FROM status AS parentAccStatus INNER JOIN " +

                      " tu AS parentAcc ON parentAccStatus.status_id = parentAcc.tu_status RIGHT OUTER JOIN " +

                      " tu AS myTaxon ON parent.id = myTaxon.tu_parent LEFT OUTER JOIN " +

                      " status AS parentStatus ON parent.tu_status = parentStatus.status_id LEFT OUTER JOIN " +

                      " status AS childStatus ON myTaxon.tu_status = childStatus.status_id " +

				i++;

				if (firstRow){

					System.out.println("========================================================");

					System.out.println("========================================================");

				}

				int childId = rs.getInt("childId");

				" SELECT    myTaxon.id AS synonymId, myTaxon.tu_displayname AS synonymName, synonymStatus.status_name AS synonymStatus, " +

					" accTaxon.id AS acceptedId, accTaxon.tu_displayname AS acceptedName, acceptedStatus.status_name AS acceptedStatus " +

				" FROM tu AS myTaxon INNER JOIN " +

                    " status AS synonymStatus ON myTaxon.tu_status = synonymStatus.status_id INNER JOIN " +

                    " status AS acceptedStatus ON accTaxon.tu_status = acceptedStatus.status_id " +

                " WHERE (myTaxon.tu_status <> 1) AND (accTaxon.tu_status <> 1) " +

		try{

//			Set<String> taxonNameSet = new HashSet<>();

			while (rs.next()){

			}

			//taxon map

		try{

			Set<String> taxonNameSet = new HashSet<String>();

//			while (rs.next()){

//			}

			//taxon map