SELECT * FROM( select WML_ID, WML_MES_CREATETIME from ( select WML_ID, WML_MES_CREATETIME from wms_material_io order by WML_MES_CREATETIME ASC ) a group by DATE_FORMAT(a.WML_MES_CREATETIME,'%Y-%M-%D') )tmp1 LEFT JOIN ( select WML_ID, WML_MES_CREATETIME from ( select WML_ID, WML_MES_CREATETIME from wms_material_io order by WML_MES_CREATETIME DESC ) b group by DATE_FORMAT(b.WML_MES_CREATETIME,'%Y-%M-%D') )tmp2 ON DATE_FORMAT(tmp1.WML_MES_CREATETIME,'%Y-%M-%D') = DATE_FORMAT(tmp2.WML_MES_CREATETIME,'%Y-%M-%D') LEFT JOIN ( select COUNT(*), WML_MES_CREATETIME from wms_material_io c group by DATE_FORMAT(c.WML_MES_CREATETIME,'%Y-%M-%D') )tmp3 ON DATE_FORMAT(tmp1.WML_MES_CREATETIME,'%Y-%M-%D') = DATE_FORMAT(tmp3.WML_MES_CREATETIME,'%Y-%M-%D')