"d2."+ciBumper + ", " + "d2."+assetInstanceOwner + ", " + "d2."+aggNumber +
"d2."+ciBumper + ", " + "d2."+assetInstanceOwner + ", " + "d2."+aggNumber +", d2."+isLowFi+
  protected String formManifestLegSql (FilterClauses filterClauses, int recentRun) {    String derivedTable = PrepareDerivedTables.getDerivedTableName(PrepareDerivedTables.CARGO_LEG,recentRun);    String manifestTable = DGPSPConstants.MANIFEST_TABLE + "_" + recentRun;    String assetInstanceOwner = DGPSPConstants.COL_OWNER;    String assetInstanceID    = DGPSPConstants.COL_ASSETID;    String cLegID      = DGPSPConstants.COL_LEGID;    String cLegStart   = DGPSPConstants.COL_STARTTIME;    String cLegEnd     = DGPSPConstants.COL_ENDTIME;    String cLegType    = DGPSPConstants.COL_LEGTYPE;    String cLegReadyAt = DGPSPConstants.COL_READYAT;    String l1geoloc = PrepareDerivedTables.COL_START_GEOLOC;    String l1name   = PrepareDerivedTables.COL_START_PRETTYNAME;    String l2geoloc = PrepareDerivedTables.COL_END_GEOLOC;    String l2name   = PrepareDerivedTables.COL_END_PRETTYNAME;    String ciConvID      = DGPSPConstants.COL_CONVEYANCEID;    String ciBumper      = DGPSPConstants.COL_BUMPERNO;    String cpPrototypeID = PrepareDerivedTables.COL_CONV_PROTOTYPEID;    String cpConvType    = DGPSPConstants.COL_CONVEYANCE_TYPE;    String cpNomen       = DGPSPConstants.COL_ALP_NOMENCLATURE;    String aggNumber     = DGPSPConstants.COL_AGGREGATE;    String manifestProto = manifestTable + "." + DGPSPConstants.COL_ALP_TYPEID;    String manifestInstanceID = manifestTable + "." + DGPSPConstants.COL_MANIFEST_ITEM_ID;    String manifestAssetID = manifestTable + "." + DGPSPConstants.COL_ASSETID;        String sqlQuery =       "select " + "d2."+cLegID + ", " + "d2."+cLegStart + ", " + "d2."+cLegEnd + ", " + "d2."+cLegReadyAt + ", " +       "d2."+l1geoloc + ", " + "d2."+l1name + ",\n" +       "d2."+l2geoloc + ", " + "d2."+l2name + ", " +       "d2."+cpConvType + ", " + "d2."+cLegType + ", " + manifestInstanceID + ",\n"+      "d2."+ciConvID + ", " + manifestProto + ", " + "d2."+cpNomen + ", " +       "d2."+ciBumper + ", " + "d2."+assetInstanceOwner + ", " + "d2."+aggNumber +      "\nfrom " + derivedTable + " d2, " + manifestTable + "\n" +      filterClauses.getWhereSql ("d2."+assetInstanceOwner, "d2."+cpPrototypeID, "d2."+ciConvID, 				 manifestProto, manifestInstanceID) +      "\nand " + "d2."+assetInstanceID + " = " + manifestAssetID +       "\norder by " + "d2." + assetInstanceID + ", " + cLegStart;    if (debug)       TPFDDLoggerFactory.createLogger().logMessage(Logger.NORMAL, Logger.GENERIC, "FilterQuery.formManifestLegSql - \n" + sqlQuery);        return sqlQuery;  }