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-12-21 06:16:34' AND '2024-12-21 07:18:10' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:18: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:18:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:18:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:19: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:19: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:19:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:19:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:20: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:20: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:20:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:20:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:21: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:21: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:21:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:21:55' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:22:10' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:22:25' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:22:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:22:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:23: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:23: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:23:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:23:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:24: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:24: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:24:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:24:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:25: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:25: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:25:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:25:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:26: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:26: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:26:39' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:26:54' 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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:27: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 ('352353086155659','353173060488028','3155','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:27: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','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','352353085039615','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904') AND g.`time` BETWEEN '2024-12-21 06:16:34' AND '2024-12-21 07:27:39' ORDER BY g.`time` DESC LIMIT 500