2021-12-16 00:20:19 <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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 17:43:43 <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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 17:43:49 <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-16 17:43:49 <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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 17:43:50 <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-16 17:43:53 <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-16 11:43:53' and t.time < '2021-12-16 17:43:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:02:54 <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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 18:02:56 <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-16 18:03:02 <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-16 18:03:02 <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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 18:03:03 <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-16 18:03:06 <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-16 12:03:06' and t.time < '2021-12-16 18:03:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:03:36 <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-16 12:03:36' and t.time < '2021-12-16 18:03:36' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:04:07 <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-16 12:04:07' and t.time < '2021-12-16 18:04:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:04:37 <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-16 12:04:37' and t.time < '2021-12-16 18:04:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:05:07 <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-16 12:05:07' and t.time < '2021-12-16 18:05:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:05:38 <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-16 12:05:38' and t.time < '2021-12-16 18:05:38' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:06:08 <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-16 12:06:08' and t.time < '2021-12-16 18:06:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:20: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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 18:20:04 <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-16 18:20: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-16 18:20: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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 18:20:11 <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-16 18:20: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-16 12:20:13' and t.time < '2021-12-16 18:20:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:26: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-16 12:26:58' and t.time < '2021-12-16 18:26:58' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:27:40 <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-16 12:27:40' and t.time < '2021-12-16 18:27:40' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:34:10 <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-16 12:34:10' and t.time < '2021-12-16 18:34:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:34:40 <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-16 12:34:40' and t.time < '2021-12-16 18:34:40' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:37: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-16 12:37:14' and t.time < '2021-12-16 18:37:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:37: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-16 12:37:14' and t.time < '2021-12-16 18:37:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:38: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-16 12:38:00' and t.time < '2021-12-16 18:38:00' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:38:02 <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-16 18:38: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-16 12:38:04' and t.time < '2021-12-16 18:38:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:38: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-16 12:38:04' and t.time < '2021-12-16 18:38:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:39: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-16 12:39:23' and t.time < '2021-12-16 18:39:23' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 18:39:53 <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-16 12:39:53' and t.time < '2021-12-16 18:39:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 19:02: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-16 13:02:35' and t.time < '2021-12-16 19:02:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 19:29:36 <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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 19:29:38 <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-16 19:29:45 <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-16 19:29:45 <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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 19:29:47 <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-16 19:29:49 <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-16 13:29:49' and t.time < '2021-12-16 19:29:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 19:48:39 <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-16 13:48:39' and t.time < '2021-12-16 19:48:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 19:49: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-16 13:49:59' and t.time < '2021-12-16 19:49:59' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 19:59: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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 19:59:06 <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-16 19:59:13 <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-16 19:59:13 <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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 19:59: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-16 19:59: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-16 13:59:17' and t.time < '2021-12-16 19:59:17' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 20:06:55 <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-16 14:06:55' and t.time < '2021-12-16 20:06:55' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 22:51:50 <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-16' AND t.client_id= ORDER BY t.imei ASC;
2021-12-16 22:51:54 <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-16 22:52:01 <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-16 22:52:01 <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-16' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-16 22:52:02 <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-16 22:52: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-16 16:52:04' and t.time < '2021-12-16 22:52:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 22:52: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-16 16:52:35' and t.time < '2021-12-16 22:52:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 22:53:05 <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-16 16:53:05' and t.time < '2021-12-16 22:53:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:12:11 <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-16 17:12:11' and t.time < '2021-12-16 23:12:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:12:41 <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-16 17:12:41' and t.time < '2021-12-16 23:12:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:13:11 <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-16 17:13:11' and t.time < '2021-12-16 23:13:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:13: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-16 17:13:42' and t.time < '2021-12-16 23:13:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:14: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-16 17:14:13' and t.time < '2021-12-16 23:14:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:14: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-16 17:14:44' and t.time < '2021-12-16 23:14:44' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:15:15 <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-16 17:15:15' and t.time < '2021-12-16 23:15:15' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:15:46 <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-16 17:15:46' and t.time < '2021-12-16 23:15:46' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:16: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-16 17:16:17' and t.time < '2021-12-16 23:16:17' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:16:48 <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-16 17:16:48' and t.time < '2021-12-16 23:16:48' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:17: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-16 17:17:19' and t.time < '2021-12-16 23:17:19' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:17:50 <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-16 17:17:50' and t.time < '2021-12-16 23:17:50' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:18: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-16 17:18:21' and t.time < '2021-12-16 23:18:21' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:18:52 <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-16 17:18:52' and t.time < '2021-12-16 23:18:52' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:19: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-16 17:19:35' and t.time < '2021-12-16 23:19:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:20:06 <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-16 17:20:06' and t.time < '2021-12-16 23:20:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:20:37 <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-16 17:20:37' and t.time < '2021-12-16 23:20:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:21:08 <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-16 17:21:08' and t.time < '2021-12-16 23:21:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:21:39 <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-16 17:21:39' and t.time < '2021-12-16 23:21:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:22:10 <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-16 17:22:10' and t.time < '2021-12-16 23:22:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:22:41 <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-16 17:22:41' and t.time < '2021-12-16 23:22:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:23:12 <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-16 17:23:12' and t.time < '2021-12-16 23:23:12' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:23: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-16 17:23:43' and t.time < '2021-12-16 23:23:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:24: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-16 17:24:14' and t.time < '2021-12-16 23:24:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:24:45 <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-16 17:24:45' and t.time < '2021-12-16 23:24:45' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:38:05 <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-16 17:38:05' and t.time < '2021-12-16 23:38:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:38: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-16 17:38:35' and t.time < '2021-12-16 23:38:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:39:06 <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-16 17:39:06' and t.time < '2021-12-16 23:39:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:39:37 <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-16 17:39:37' and t.time < '2021-12-16 23:39:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:40:08 <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-16 17:40:08' and t.time < '2021-12-16 23:40:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:40:39 <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-16 17:40:39' and t.time < '2021-12-16 23:40:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:41:10 <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-16 17:41:10' and t.time < '2021-12-16 23:41:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:41:41 <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-16 17:41:41' and t.time < '2021-12-16 23:41:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:42:12 <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-16 17:42:12' and t.time < '2021-12-16 23:42:12' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:42: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-16 17:42:43' and t.time < '2021-12-16 23:42:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:43: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-16 17:43:14' and t.time < '2021-12-16 23:43:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:43:45 <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-16 17:43:45' and t.time < '2021-12-16 23:43:45' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:44:16 <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-16 17:44:16' and t.time < '2021-12-16 23:44:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:44:47 <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-16 17:44:47' and t.time < '2021-12-16 23:44:47' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:45:18 <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-16 17:45:18' and t.time < '2021-12-16 23:45:18' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:45:49 <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-16 17:45:49' and t.time < '2021-12-16 23:45:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:46:20 <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-16 17:46:20' and t.time < '2021-12-16 23:46:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:46: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-16 17:46:51' and t.time < '2021-12-16 23:46:51' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:47:22 <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-16 17:47:22' and t.time < '2021-12-16 23:47:22' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:47:53 <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-16 17:47:53' and t.time < '2021-12-16 23:47:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:48: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-16 17:48:24' and t.time < '2021-12-16 23:48:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:48:55 <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-16 17:48:55' and t.time < '2021-12-16 23:48:55' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:49: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-16 17:49:26' and t.time < '2021-12-16 23:49:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:49: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-16 17:49:57' and t.time < '2021-12-16 23:49:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:50: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-16 17:50:28' and t.time < '2021-12-16 23:50:28' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:50: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-16 17:50:59' and t.time < '2021-12-16 23:50:59' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:51:30 <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-16 17:51:30' and t.time < '2021-12-16 23:51:30' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:52: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-16 17:52:01' and t.time < '2021-12-16 23:52:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:52:32 <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-16 17:52:32' and t.time < '2021-12-16 23:52:32' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:53:03 <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-16 17:53:03' and t.time < '2021-12-16 23:53:03' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:53: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-16 17:53:34' and t.time < '2021-12-16 23:53:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:54:05 <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-16 17:54:05' and t.time < '2021-12-16 23:54:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:54:36 <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-16 17:54:36' and t.time < '2021-12-16 23:54:36' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:55:07 <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-16 17:55:07' and t.time < '2021-12-16 23:55:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:55:38 <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-16 17:55:38' and t.time < '2021-12-16 23:55:38' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:56:09 <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-16 17:56:09' and t.time < '2021-12-16 23:56:09' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:56:40 <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-16 17:56:40' and t.time < '2021-12-16 23:56:40' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:57:11 <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-16 17:57:11' and t.time < '2021-12-16 23:57:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:57: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-16 17:57:42' and t.time < '2021-12-16 23:57:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:58: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-16 17:58:13' and t.time < '2021-12-16 23:58:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:58: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-16 17:58:44' and t.time < '2021-12-16 23:58:44' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:59:15 <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-16 17:59:15' and t.time < '2021-12-16 23:59:15' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-16 23:59:46 <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-16 17:59:46' and t.time < '2021-12-16 23:59:46' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC