grup SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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-05-26 02:26:55' AND '2024-05-26 02:26:50' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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-05-26 02:26:55' AND '2024-05-26 02:27:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:27:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:27:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:27:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:28:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:28:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:28:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:28:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:29:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:29:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:29:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:29:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:30:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:30:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:30:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:30:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:31:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:31:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:31:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:31:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:32:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:32:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:32:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:32:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:33:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:33:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:33:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:33:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:34:04' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:34:19' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:34:34' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:34:49' ORDER BY g.`time` DESC LIMIT 500 SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei` WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2756','3203','352353086157176','3123','3135','356078111473761','3057','862531041080715','3025','352353083439767','356078111347361','2883','3055','356078111430936','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2665','354836080392292','3162','354836080405763','2871','352353084144218','2574','354836080314031','3178','2743','358021081839668','3167','355234055744904','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','4865') AND g.`time` BETWEEN '2024-05-26 02:26:55' AND '2024-05-26 02:35:04' ORDER BY g.`time` DESC LIMIT 500