grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:53:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:53:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:53:36' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:53:51' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:54:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:54:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:54:36' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:54:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:55:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:55:21' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 00:51:44' AND '2024-11-10 01:55:36' 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 '2024-11-10 17:37:45' AND '2024-11-10 18:39: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 ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:39:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:39:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:39:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:40:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:40:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:40:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:40:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:41:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:41:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:41:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:41:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:42:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:42: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 ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:42:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:42:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:43:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:43:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:43:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:43:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:44:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:44:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:44:37' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:44:52' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:45:07' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:45:22' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','2485','353173060485131','2756','356078111430936','356078116305406','3123','3135','356078111473761','3057','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','352353084146916','9378','3126','2677','2783','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','3178','2619','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2024-11-10 17:37:45' AND '2024-11-10 18:45:37' ORDER BY g.`time` DESC LIMIT 500