Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 05:09:42' AND e.date<='2024-12-04 21:09:42'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 05:09:42' AND e.date<='2024-12-04 21:09:42'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 03:26:40' AND e.date<='2024-12-05 21:26:40'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 03:26:40' AND e.date<='2024-12-05 21:26:40'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 05:31:12' AND e.date<='2024-12-04 20:31:12'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 05:31:12' AND e.date<='2024-12-04 20:31:12'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 05:31:41' AND e.date<='2024-12-04 18:31:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 05:31:41' AND e.date<='2024-12-04 18:31:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2594' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 10:33:55' AND e.date<='2024-12-05 00:33:55'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2594' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 10:33:55' AND e.date<='2024-12-05 00:33:55'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3045' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:02:17' AND e.date<='2024-12-02 21:02:17'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3045' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:02:17' AND e.date<='2024-12-02 21:02:17'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:29:26' AND e.date<='2024-12-02 21:29:26'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:29:26' AND e.date<='2024-12-02 21:29:26'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 22:29:26' AND e.date<='2024-12-03 21:29:26'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 22:29:26' AND e.date<='2024-12-03 21:29:26'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 22:29:26' AND e.date<='2024-12-04 21:29:26'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3076' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 22:29:26' AND e.date<='2024-12-04 21:29:26'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078116291713' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 22:00:00' AND e.date<='2024-12-05 08:10:53'
Method:GetStops; stop_time2024-12-05 07:59:11
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2783' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-22 22:58:38' AND e.date<='2024-11-24 21:58:38'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2783' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-22 22:58:38' AND e.date<='2024-11-24 21:58:38'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 00:31:18' AND e.date<='2024-12-05 09:31:18'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 00:31:18' AND e.date<='2024-12-05 09:31:18'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 22:31:34' AND e.date<='2024-12-05 09:31:34'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 22:31:34' AND e.date<='2024-12-05 09:31:34'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 15:31:45' AND e.date<='2024-12-05 09:31:45'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 15:31:45' AND e.date<='2024-12-05 09:31:45'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 02:42:55' AND e.date<='2024-12-05 09:42:55'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 02:42:55' AND e.date<='2024-12-05 09:42:55'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 22:30:02' AND e.date<='2024-12-05 11:30:02'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 22:30:02' AND e.date<='2024-12-05 11:30:02'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 22:30:02' AND e.date<='2024-12-04 21:30:02'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 22:30:02' AND e.date<='2024-12-04 21:30:02'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 22:30:02' AND e.date<='2024-12-03 21:30:02'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 22:30:02' AND e.date<='2024-12-03 21:30:02'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:30:02' AND e.date<='2024-12-02 21:30:02'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080392292' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:30:02' AND e.date<='2024-12-02 21:30:02'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-06 05:19:35' AND e.date<='2024-12-05 13:19:35'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-06 05:19:35' AND e.date<='2024-12-05 13:19:35'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-01 02:12:07' AND e.date<='2024-11-01 21:12:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-01 02:12:07' AND e.date<='2024-11-01 21:12:07'