2021-12-22 08:42:02 <BR>  <BR> 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='2021-12-22' AND t.client_id= ORDER BY t.imei ASC;
2021-12-22 08:42:03 <BR>  <BR> 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
2021-12-22 08:42:10 <BR>  <BR> 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`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-22 08:42:10 <BR> 53 <BR> 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='2021-12-22' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-22 08:42:12 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 08:42:14 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 02:42:14' and t.time < '2021-12-22 08:42:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 08:42:44 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 02:42:44' and t.time < '2021-12-22 08:42:44' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 08:48:21 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 02:48:21' and t.time < '2021-12-22 08:48:21' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 08:48:21 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 02:48:21' and t.time < '2021-12-22 08:48:21' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:01:57 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:01:57' and t.time < '2021-12-22 09:01:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:02:27 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:02:27' and t.time < '2021-12-22 09:02:27' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:05:58 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 09:05:59 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:05:59' and t.time < '2021-12-22 09:05:59' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:06:00 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:06:00' and t.time < '2021-12-22 09:06:00' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:06:01 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:06:01' and t.time < '2021-12-22 09:06:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:06:31 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:06:31' and t.time < '2021-12-22 09:06:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:07:01 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:07:01' and t.time < '2021-12-22 09:07:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:07:31 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:07:31' and t.time < '2021-12-22 09:07:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:08:01 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:08:01' and t.time < '2021-12-22 09:08:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:08:18 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 09:08:19 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:08:19' and t.time < '2021-12-22 09:08:19' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:09:13 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:09:13' and t.time < '2021-12-22 09:09:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:09:42 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 03:09:42' and t.time < '2021-12-22 09:09:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:40:16 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-22 03:40:16' and t.time < '2021-12-22 09:40:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 09:42:24 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-22 03:42:24' and t.time < '2021-12-22 09:42:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 10:11:14 <BR>  <BR> 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='2021-12-22' AND t.client_id= ORDER BY t.imei ASC;
2021-12-22 10:11:19 <BR>  <BR> 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`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-22 10:11:19 <BR> 53 <BR> 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='2021-12-22' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-22 10:11:20 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 10:11:23 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 04:11:23' and t.time < '2021-12-22 10:11:23' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:19:14 <BR>  <BR> 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='2021-12-22' AND t.client_id= ORDER BY t.imei ASC;
2021-12-22 16:19:16 <BR>  <BR> 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
2021-12-22 16:19:23 <BR>  <BR> 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`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-22 16:19:23 <BR> 53 <BR> 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='2021-12-22' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-22 16:19:24 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 16:19:26 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:19:26' and t.time < '2021-12-22 16:19:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:19:56 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:19:56' and t.time < '2021-12-22 16:19:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:20:26 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:20:26' and t.time < '2021-12-22 16:20:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:20:56 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:20:56' and t.time < '2021-12-22 16:20:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:21:26 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:21:26' and t.time < '2021-12-22 16:21:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:21:56 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:21:56' and t.time < '2021-12-22 16:21:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:22:31 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:22:31' and t.time < '2021-12-22 16:22:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:23:01 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:23:01' and t.time < '2021-12-22 16:23:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:23:31 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:23:31' and t.time < '2021-12-22 16:23:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:27:51 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:27:51' and t.time < '2021-12-22 16:27:51' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:27:56 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 16:27:58 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:27:58' and t.time < '2021-12-22 16:27:58' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:28:28 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:28:28' and t.time < '2021-12-22 16:28:28' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:29:02 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:29:02' and t.time < '2021-12-22 16:29:02' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:32:24 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:32:24' and t.time < '2021-12-22 16:32:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:32:24 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:32:24' and t.time < '2021-12-22 16:32:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:32:32 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 16:32:34 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:32:34' and t.time < '2021-12-22 16:32:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:33:04 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:33:04' and t.time < '2021-12-22 16:33:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:36:43 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:36:43' and t.time < '2021-12-22 16:36:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 16:37:33 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 10:37:33' and t.time < '2021-12-22 16:37:33' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 17:07:34 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 11:07:34' and t.time < '2021-12-22 17:07:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 17:07:34 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 17:07:35 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 11:07:35' and t.time < '2021-12-22 17:07:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 17:12:03 <BR>  <BR> 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='2021-12-22' AND t.client_id= ORDER BY t.imei ASC;
2021-12-22 17:12:05 <BR>  <BR> 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
2021-12-22 17:12:12 <BR>  <BR> 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`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-22 17:12:12 <BR> 53 <BR> 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='2021-12-22' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-22 17:12:15 <BR> 53 <BR> 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 = 53 ORDER BY ci.car_name ASC
2021-12-22 17:12:17 <BR> 53 <BR> 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 = '861359037404611' AND t.time >= '2021-12-22 11:12:17' and t.time < '2021-12-22 17:12:17' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 17:43:54 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-22 11:43:54' and t.time < '2021-12-22 17:43:54' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-22 22:12:01 <BR>  <BR> 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='2021-12-22' AND t.client_id= ORDER BY t.imei ASC;