2020-02-01 06:58:21

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id= ORDER BY t.imei ASC; 2020-02-01 06:58:28

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 06:58:28
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 06:58:31
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 06:58:32
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 00:58:32' and t.time < '2020-02-01 06:58:32' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 06:58:53
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:31:41

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id= ORDER BY t.imei ASC; 2020-02-01 15:31:58

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 15:31:58
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:32:00
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 15:32:01
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:32:01' and t.time < '2020-02-01 15:32:01' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:32:31
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:32:31' and t.time < '2020-02-01 15:32:31' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:33:01
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:33:01' and t.time < '2020-02-01 15:33:01' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:33:25
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:48:43
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:48:50

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 15:48:50
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:48:51
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 15:48:53
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:48:53' and t.time < '2020-02-01 15:48:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:49:23
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:49:23' and t.time < '2020-02-01 15:49:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:49:53
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:49:53' and t.time < '2020-02-01 15:49:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:50:23
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:50:23' and t.time < '2020-02-01 15:50:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:50:42
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:53:11

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id= ORDER BY t.imei ASC; 2020-02-01 15:53:19

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 15:53:19
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 15:53:20
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 15:53:23
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:53:23' and t.time < '2020-02-01 15:53:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:53:53
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 09:53:53' and t.time < '2020-02-01 15:53:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 15:54:04
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 18:12:42

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id= ORDER BY t.imei ASC; 2020-02-01 18:12:44

SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = ORDER BY ci.car_name ASC 2020-02-01 18:12:50

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 18:12:51
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 18:12:52
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 18:12:53
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 12:12:53' and t.time < '2020-02-01 18:12:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 18:13:02
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 18:15:02
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 18:15:08

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='IvanHvalinskiy' AND u.`password`='e10adc3949ba59abbe56e057f20f883e') 2020-02-01 18:15:09
57
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2020-02-01' AND t.client_id=57 ORDER BY t.imei ASC; 2020-02-01 18:15:10
57
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 57 ORDER BY ci.car_name ASC 2020-02-01 18:15:12
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 12:15:12' and t.time < '2020-02-01 18:15:12' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2020-02-01 18:15:42
57
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '4634' AND t.time >= '2020-02-01 12:15:42' and t.time < '2020-02-01 18:15:42' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC