SELECT COUNT(1)

 FROM

   (SELECT a.id    AS "id",

     a.district    AS "district",

     a.company     AS "company",

     a.type        AS "type",

     a.cargo       AS "cargo",

     a.goods       AS "goods",

     a.weight      AS "weight",

     a.status      AS "status",

     a.remarks     AS "remarks",

     a.create_by   AS "createBy.id",

     a.create_name AS "createBy.name",

     a.create_date AS "createDate",

     a.update_by   AS "updateBy.id",

     a.update_name AS "updateBy.name",

     a.update_date AS "updateDate",

     a.submit_by   AS "submitBy",

     a.submit_name AS "submitName",

     a.submit_date AS "submitDate",

     a.censor_by   AS "censorBy",

     a.censor_name AS "censorName",

     a.censor_date AS "censorDate",

     a.censor_note AS "censorNote",

     a.del_flag    AS "delFlag",

     b.vessel      AS "bndExportFreight.vessel",

     b.voyage      AS "bndExportFreight.voyage",

     b.sheet       AS "bndExportFreight.sheet",

     b.wharf       AS "bndExportFreight.wharf" ,

     'b.method' AS "bndExportGeneral.method"

   FROM bnd_export a

   INNER JOIN bnd_export_freight b

   ON a.id          = b.export

   WHERE a.del_flag = ?

   AND a.type       = ?

   ORDER BY a.update_date DESC

   ) tmp_count