SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:18:56' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:19:11' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:19:27' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:19:42' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:19:57' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:20:13' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:20:29' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:20:55' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:21:11' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:21:26' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 18:21:58' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','2913','354836080121006','356078111469876','355234055232561','5078','2966','2650','5080','2535','2557','352353083507456','9378','354836080168387','352353084234167','3263','5082','2510','356078116281466','352353085645312','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','2773','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','2649','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','352353084150330','2950','352353084652467','352353084291100','2888','2597','354836080627978') AND g.`time` BETWEEN '2025-03-21 14:40:49' AND '2025-03-23 23:22:04' ORDER BY g.`time` DESC LIMIT 500