"select distinct m." + typeID + ",m." + nomen + ",m." + typeID +
"select distinct m." + typeID + ",m." + nomen + ",m." + typeID + ", \"false\"" +
  protected String formManifestTypeSql (FilterClauses filterClauses, int recentRun) {    String manifestTable = DGPSPConstants.MANIFEST_TABLE + "_" + recentRun;    String assetInstanceTable = DGPSPConstants.ASSET_INSTANCE_TABLE + "_" + recentRun;        String typeID = DGPSPConstants.COL_ALP_TYPEID;    String nomen  = DGPSPConstants.COL_ALP_NOMENCLATURE;    String instanceOwner = DGPSPConstants.COL_OWNER;    String instanceID    = DGPSPConstants.COL_ASSETID;        String sqlQuery =       "select distinct m." + typeID + ",m." + nomen + ",m." + typeID +       "\nfrom " + manifestTable + " m, " + assetInstanceTable + " a \n" +      filterClauses.getUnitWhereSql (instanceOwner) +      "\nand a." + instanceID + "=m." +instanceID +      "\norder by " + typeID;        if (debug)       TPFDDLoggerFactory.createLogger().logMessage(Logger.NORMAL, Logger.GENERIC, "ListQuery.formManifestTypeSql - \n" + sqlQuery);        return sqlQuery;  }