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')