Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-17 02:23:56' AND e.date<='2024-05-17 06:23:56'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-17 02:23:56' AND e.date<='2024-05-17 06:23:56'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-10 21:00:28' AND e.date<='2024-05-12 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-10 21:00:28' AND e.date<='2024-05-12 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-10 21:00:28' AND e.date<='2024-05-11 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-10 21:00:28' AND e.date<='2024-05-11 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-11 21:00:28' AND e.date<='2024-05-12 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-11 21:00:28' AND e.date<='2024-05-12 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 21:00:28' AND e.date<='2024-05-17 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 21:00:28' AND e.date<='2024-05-17 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-15 21:00:28' AND e.date<='2024-05-16 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-15 21:00:28' AND e.date<='2024-05-16 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 21:00:28' AND e.date<='2024-05-15 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 21:00:28' AND e.date<='2024-05-15 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-05 21:00:28' AND e.date<='2024-05-06 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-05 21:00:28' AND e.date<='2024-05-06 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-03 21:00:28' AND e.date<='2024-05-04 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-03 21:00:28' AND e.date<='2024-05-04 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-04 21:00:28' AND e.date<='2024-05-05 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-04 21:00:28' AND e.date<='2024-05-05 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-07 21:00:28' AND e.date<='2024-05-08 20:00:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-07 21:00:28' AND e.date<='2024-05-08 20:00:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 07:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 07:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 07:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 07:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 07:04:41' AND e.date<='2024-05-17 20:04:41'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084195392' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-15 21:51:59' AND e.date<='2024-05-16 20:51:59'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084195392' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-15 21:51:59' AND e.date<='2024-05-16 20:51:59'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084195392' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 21:51:59' AND e.date<='2024-05-17 20:51:59'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084195392' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 21:51:59' AND e.date<='2024-05-17 20:51:59'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-16 21:46:46' AND e.date<='2024-05-17 13:46: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='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-16 21:46:46' AND e.date<='2024-05-17 13:46:46'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3176' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3176' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='357804048849149' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='357804048849149' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060487970' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060487970' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2585' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2585' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2496' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2496' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3115' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3115' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 20:00:00' AND e.date<='2024-05-14 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084234167' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084234167' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060487970' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060487970' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2585' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2585' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 20:00:00' AND e.date<='2024-05-15 02:00:00'