grup SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('') AND g.`time` BETWEEN '2025-02-02 06:17:34' AND '2025-02-02 06:18:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 06:17:34' AND '2025-02-02 06:18:48' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 06:17:34' AND '2025-02-02 06:19:03' ORDER BY g.`time` DESC LIMIT 500 grup SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:56:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:56:48' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:57:03' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:57:18' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:57:33' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:57:48' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:58:03' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:58:18' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:58:33' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:58:48' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:59:03' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','352353083473444','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-02-02 10:55:38' AND '2025-02-02 11:59:18' ORDER BY g.`time` DESC LIMIT 500 grup SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:17:35' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:17:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:18:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:18:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:18:35' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:18:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:19:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:19:20' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:19:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:19:50' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:20:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:20:20' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:20:35' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:20:50' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:21:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:21:20' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:21:35' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:21:50' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:22:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:22:20' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:22:35' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:22:50' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:23:05' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:23:20' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2: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 ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','2837','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473') AND g.`time` BETWEEN '2025-02-02 14:16:35' AND '2025-02-02 14:23:35' ORDER BY g.`time` DESC LIMIT 500