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-01-11 07:39:54' AND '2025-01-11 08:41:09' 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-01-11 07:39:54' AND '2025-01-11 08:41:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:41:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:41:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:42:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:42:24' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:42:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:42:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:43:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:43:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:43:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:43:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:44:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:44:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:44:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:44:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:45:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:45:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:45:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:45:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:46:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:46:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:46:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:46:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:47:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:47:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:47:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:47:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:48:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:48:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:48:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:48:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:49:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:49:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:49:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:49:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:50:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:50:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:50:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:50:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:51:08' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:51:23' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:51:38' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:51:53' 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','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2025-01-11 07:39:54' AND '2025-01-11 08:52:08' 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-01-11 18:07:59' AND '2025-01-11 19:09:14' 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-01-11 18:07:59' AND '2025-01-11 19:09:28' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:09:43' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:09:58' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:10:13' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:10:28' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:10:43' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:10:58' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:11:13' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:11:28' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:11:43' 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','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','3178','3043','2571','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2025-01-11 18:07:59' AND '2025-01-11 19:11:58' ORDER BY g.`time` DESC LIMIT 500