Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083463817' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 22:00:00' AND e.date<='2024-12-06 07:18:50'
Method:GetStops; stop_time2024-12-06 05:13:49
Method:GetStops; stop_time2024-12-06 05:44:22
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 22:00:00' AND e.date<='2024-12-06 07:19:25'
Method:GetStops; stop_time2024-12-05 22:38:12
Method:GetStops; stop_time2024-12-05 22:51:07
Method:GetStops; stop_time2024-12-06 02:19:02
Method:GetStops; stop_time2024-12-06 02:34:02
Method:GetStops; stop_time2024-12-06 06:23:23
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2684' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 07:51:36' AND e.date<='2024-12-06 07:51:36'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2684' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 07:51:36' AND e.date<='2024-12-06 07:51:36'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3075' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3075' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2677' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2677' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2504' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2504' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086185623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086185623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2752' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2752' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 21:00:00' AND e.date<='2024-12-03 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3108' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3108' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3064' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3064' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2535' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2535' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279820' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279820' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2948' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2948' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2707' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2707' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-03 21:00:00' AND e.date<='2024-12-04 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116287711' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116287711' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9011' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9011' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2686' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2686' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2662' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2662' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2499' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2499' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2584' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2584' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 21:00:00' AND e.date<='2024-12-05 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2513' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2513' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2665' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2665' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 21:00:00' AND e.date<='2024-12-06 03:00:00'
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 09:13:32' AND e.date<='2024-12-05 21:13:32'
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 09:13:32' AND e.date<='2024-12-05 21:13:32'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 09:14:49' AND e.date<='2024-12-05 21:14:49'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 09:14:49' AND e.date<='2024-12-05 21:14:49'
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-05 09:15:32' AND e.date<='2024-12-05 21:15:32'
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-05 09:15:32' AND e.date<='2024-12-05 21:15:32'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 09:15:55' AND e.date<='2024-12-05 21:15: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='358021081803706' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 09:15:55' AND e.date<='2024-12-05 21:15: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='3136' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:59:33' AND e.date<='2024-12-05 10:59:33'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3136' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:59:33' AND e.date<='2024-12-05 10:59:33'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 22:59:33' AND e.date<='2024-12-01 21:59:33'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 22:59:33' AND e.date<='2024-12-01 21:59:33'