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 '2024-11-30 08:55:30' AND '2024-11-30 09:56: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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:56:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:57:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:57:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:57:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:57:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:58:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:58:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:58:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:58:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:59:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:59:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:59:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 09:59:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:00: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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:00: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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:00: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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:00:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:01:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:01:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:01:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:01:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:02:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:02:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:02:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:02:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:03:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:03:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:03:32' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:03:47' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:04:02' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:04:17' 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 ('352353086155659','353173060488028','3155','2485','353173060485131','2898','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','2790','356078111347361','2883','3055','2876','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','354836080405763','354836080314031','355234055575019','3178','3043','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','3172','356078118085444','3197','3071') AND g.`time` BETWEEN '2024-11-30 08:55:30' AND '2024-11-30 10:04:32' ORDER BY g.`time` DESC LIMIT 500