Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084655866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:08:32' AND e.date<='2024-07-14 20:08:32'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084655866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:08:32' AND e.date<='2024-07-14 20:08:32'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-07-15 21:07:18' AND e.date<='2024-07-16 07:07:18'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-07-15 21:07:18' AND e.date<='2024-07-16 07:07:18'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-15 07:34:37' AND e.date<='2024-07-16 07:34:37'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-15 07:34:37' AND e.date<='2024-07-16 07:34:37'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:34:37' AND e.date<='2024-07-09 20:34:37'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:34:37' AND e.date<='2024-07-09 20:34:37'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-09 21:34:37' AND e.date<='2024-07-10 20:34:37'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-09 21:34:37' AND e.date<='2024-07-10 20:34:37'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 21:34:37' AND e.date<='2024-07-11 20:34:37'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 21:34:37' AND e.date<='2024-07-11 20:34:37'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-11 21:34:37' AND e.date<='2024-07-12 20:34:37'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-11 21:34:37' AND e.date<='2024-07-12 20:34:37'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-14 21:38:46' AND e.date<='2024-07-15 20:38:46'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-14 21:38:46' AND e.date<='2024-07-15 20:38:46'