Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='354836080173346' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 22:00:00' AND e.date<='2024-03-08 06:28:07' Method:GetStops; stop_time2024-03-08 04:43:15 Method:GetStops; stop_time2024-03-08 05:35:48 Method:GetStops; stop_time2024-03-08 06:09:58 Method:GetStops; stop_time2024-03-08 06:19: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='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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-03-04 21:00:00' AND e.date<='2024-03-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='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='2456' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='2456' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='4883' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='4883' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='353173060487970' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='353173060487970' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='8993' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='8993' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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-03-04 21:00:00' AND e.date<='2024-03-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-03-04 21:00:00' AND e.date<='2024-03-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='3162' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='3162' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='3167' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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='3167' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-04 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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='2913' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2913' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='9009' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='9009' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='5080' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='5080' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='353173060487970' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='353173060487970' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2633' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2633' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2846' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2846' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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-03-05 21:00:00' AND e.date<='2024-03-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='2878' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2878' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2809' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='2809' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-05 21:00:00' AND e.date<='2024-03-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='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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-03-06 21:00:00' AND e.date<='2024-03-07 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='4962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='4962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='356078111301566' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='356078111301566' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='353173060487970' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='353173060487970' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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-03-06 21:00:00' AND e.date<='2024-03-07 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-03-06 21:00:00' AND e.date<='2024-03-07 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='4868' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='4868' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='2728' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='2728' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='8983' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='8983' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-06 21:00:00' AND e.date<='2024-03-07 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='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='353173066816669' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='353173066816669' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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='5078' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='5078' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2974' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2974' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3126' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3126' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='352353084234167' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='352353084234167' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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='352353086184659' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='352353086184659' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3029' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3029' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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-03-07 21:00:00' AND e.date<='2024-03-08 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='2743' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2743' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2610' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='2610' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-07 21:00:00' AND e.date<='2024-03-08 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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 22:43:54' AND e.date<='2024-03-08 11:43:54' 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-03-07 22:43:54' AND e.date<='2024-03-08 11:43:54' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-08 02:49:40' AND e.date<='2024-03-08 11:49: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='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-08 02:49:40' AND e.date<='2024-03-08 11:49: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='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-08 05:53:43' AND e.date<='2024-03-08 11:53:43' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-08 05:53:43' AND e.date<='2024-03-08 11:53:43' 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-03-08 00:06:18' AND e.date<='2024-03-08 12:06: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-03-08 00:06:18' AND e.date<='2024-03-08 12:06: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-03-08 04:28:37' AND e.date<='2024-03-08 12:28:37' 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-03-08 04:28:37' AND e.date<='2024-03-08 12:28:37'