Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055748228'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055744383'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055547430'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055565614'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055558247'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055747568'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055578153'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055578880'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055693747'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055576710'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055703595'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='357804048849149'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055677419'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055762302'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055686428'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-27 22:00:00' AND `time`<= '2021-12-28 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-28 22:00:00' AND `time`<= '2021-12-29 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-29 22:00:00' AND `time`<= '2021-12-30 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-30 22:00:00' AND `time`<= '2021-12-31 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2021-12-31 22:00:00' AND `time`<= '2022-01-01 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-01 22:00:00' AND `time`<= '2022-01-02 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-02 22:00:00' AND `time`<= '2022-01-03 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-03 22:00:00' AND `time`<= '2022-01-04 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-04 22:00:00' AND `time`<= '2022-01-05 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-05 22:00:00' AND `time`<= '2022-01-06 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-06 22:00:00' AND `time`<= '2022-01-07 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-07 22:00:00' AND `time`<= '2022-01-08 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-08 22:00:00' AND `time`<= '2022-01-09 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-09 22:00:00' AND `time`<= '2022-01-10 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-10 22:00:00' AND `time`<= '2022-01-11 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-11 22:00:00' AND `time`<= '2022-01-12 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-12 22:00:00' AND `time`<= '2022-01-13 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-13 22:00:00' AND `time`<= '2022-01-14 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-14 22:00:00' AND `time`<= '2022-01-15 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-15 22:00:00' AND `time`<= '2022-01-16 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-16 22:00:00' AND `time`<= '2022-01-17 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-17 22:00:00' AND `time`<= '2022-01-18 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-18 22:00:00' AND `time`<= '2022-01-19 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-19 22:00:00' AND `time`<= '2022-01-20 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-20 22:00:00' AND `time`<= '2022-01-21 21:59:59' AND `DeviceLoginName`='355234055575019'; Method:GetMileage3; Query SELECT SUM(`Distance`) FROM `tms_gpsdata_fixed` WHERE `time`>= '2022-01-21 22:00:00' AND `time`<= '2022-01-22 21:59:59' AND `DeviceLoginName`='355234055575019';