EDIT

import java.sql.SQLException;

	public void buttonClick(Classification classification, TermVocabulary<DefinedTermBase> term) throws SQLException {

import java.sql.SQLException;

import java.util.ArrayList;

import eu.etaxonomy.cdm.vaadin.container.CdmSQLContainer;

import eu.etaxonomy.cdm.vaadin.util.CdmQueryFactory;

	public DistributionTablePresenter(DistributionTableView dtv) throws SQLException{

	public List<String> getTermList() {

		VaadinSession session = VaadinSession.getCurrent();

		UUID termUUID = (UUID) session.getAttribute("selectedTerm");

		TermVocabulary<DefinedTermBase> term = vocabularyService.load(termUUID);

		term = CdmBase.deproxy(term, TermVocabulary.class);

		Set<DefinedTermBase> terms = term.getTerms();

		List<String> list = new ArrayList<String>();

		for(DefinedTermBase dtb: terms){

			list.add(dtb.getTitleCache());

		}

		return list;

	}

	@Override

	public CdmSQLContainer getSQLContainer() throws SQLException{

		Classification classification = getChosenClassification();

		int classificationId = classification.getId();

		List<String> termList = getTermList();

		CdmSQLContainer container = new CdmSQLContainer(new CdmQueryFactory().generateTaxonDistributionQuery("id", termList, classificationId));

		return container;

	}

import java.util.List;

    public static QueryDelegate generateTaxonDistributionQuery(String id,

            List<String> termList, int classificationID) throws SQLException {

        String FROM_QUERY = 

        		" FROM TaxonNode tn " +

        		"INNER JOIN TaxonBase tb on tn.taxon_id = tb.id " +

        		"INNER JOIN Classification cl ON tn.classification_id = cl.id " +

        		"LEFT OUTER JOIN TaxonNameBase tnb ON tnb.id=tb.id " + 

        		"LEFT OUTER JOIN DescriptionBase db ON db.taxon_id=tb.id " +

        		"LEFT OUTER JOIN (SELECT indescription_id, area_id, status_id, DTYPE, id FROM DescriptionElementBase deb WHERE deb.DTYPE LIKE 'Distribution') AS deb ON deb.indescription_id=db.id " +

        		"LEFT OUTER JOIN DefinedTermBase dtb on deb.status_id=dtb.id " +

        		"LEFT OUTER JOIN DefinedTermBase dtb1 on deb.area_id=dtb1.id " +

        		"LEFT OUTER JOIN DefinedTermBase dtb2 on tnb.rank_id = dtb2.id " +

        		"WHERE tn.classification_id = "+ classificationID +" AND tb.DTYPE = 'Taxon'" ;

        String GROUP_BY = " GROUP BY tb.id ";

        String SELECT_QUERY=

        		"SELECT tb.DTYPE," +

        		"tb.id, " +

        		"tn.classification_id, " +

        		"tb.titleCache AS Taxon, " +

        		"dtb2.titleCache AS Rank, " +

        		"deb.DTYPE," +

        		"deb.id, " +

        		"deb.area_id, "+

        		"dtb.vocabulary_id, " +

        		"dtb1.vocabulary_id, "; 

        int count = termList.size();

        for(String term : termList){

        	if(count == 1){

        		SELECT_QUERY= SELECT_QUERY + 

            			"MAX( IF(dtb1.titleCache = '"+ term +"', dtb.titleCache, NULL) ) as '"+ term +"' " ;

        	}else{

        		SELECT_QUERY= SELECT_QUERY + 

        				"MAX( IF(dtb1.titleCache = '"+ term +"', dtb.titleCache, NULL) ) as '"+ term +"'," ;

        	}

        	count--;

        }

        SELECT_QUERY= SELECT_QUERY + FROM_QUERY + GROUP_BY; 

        String COUNT_QUERY = "SELECT count(DISTINCT tb.id)" + FROM_QUERY;

        String CONTAINS_QUERY = "SELECT * FROM TaxonNode tn WHERE tn.id = ?";

    public static QueryDelegate generateSynonymofTaxonQuery(String id,

    		String name_id) throws SQLException {

    	String FROM_QUERY = " FROM TaxonBase tb " +

    			"INNER JOIN TaxonNameBase tnb on tb.name_id=tnb.id " +

    			"INNER JOIN SynonymRelationship sr on tb.id=sr.relatedfrom_id ";

    	String SELECT_QUERY="SELECT tb.id as " + id +

    			", tnb.titleCache as " + name_id +

    			FROM_QUERY;

    	String COUNT_QUERY = "SELECT count(*) " + FROM_QUERY;

    	String CONTAINS_QUERY = "SELECT * FROM SynonymRelationship sr WHERE sr.relatedfrom_id = ?";

    	return generateQueryDelegate(SELECT_QUERY, COUNT_QUERY, CONTAINS_QUERY, id);

    }

import java.sql.SQLException;

			try {

				distListener.buttonClick(classification, term);

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

import java.sql.SQLException;

import eu.etaxonomy.cdm.vaadin.container.CdmSQLContainer;

	public void dataBinding() throws SQLException{

//		final LazyLoadedContainer container = listener.getLazyLoadedContainer();

//		Set<DefinedTermBase> chosenTerms = listener.getChosenTerms();

//		generateDsitributionColumn(chosenTerms);

		CdmSQLContainer container = listener.getSQLContainer();

		table_1.setSortEnabled(true);

//		Object[] visibleColumns = columnList.toArray();

//		table_1.setVisibleColumns(visibleColumns);

//		table_1.setColumnHeaders(headerList.toArray(new String[headerList.size()]));//new String[]{"Taxon", "Rang"});// ,"Deutschland"

		table_1.setColumnFooter("Taxon", "Total amount of Taxa displayed: " + container.size());

		//FIXME with new SQL CONTAINER

//		table_1.addItemClickListener(new ItemClickListener() {

//

//			@Override

//			public void itemClick(ItemClickEvent event) {

//				Object taxonbean = ((BeanItem<?>)event.getItem()).getBean();

//				if(taxonbean instanceof CdmTaxonTableCollection){

//					CdmTaxonTableCollection red = (CdmTaxonTableCollection) taxonbean;

//					currentTaxon = red.getTaxon();

//				}

//			}

//		});

import java.sql.SQLException;

		void buttonClick(Classification classification, TermVocabulary<DefinedTermBase> term) throws SQLException;

import java.sql.SQLException;

import eu.etaxonomy.cdm.vaadin.container.CdmSQLContainer;

		CdmSQLContainer getSQLContainer() throws SQLException;