Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 06:29:43' AND e.date<='2024-10-11 06:29:43' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 06:29:43' AND e.date<='2024-10-11 06:29:43' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9003' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 21:49:53' AND e.date<='2024-10-11 08:49:53' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9003' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 21:49:53' AND e.date<='2024-10-11 08:49:53' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9003' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 21:49:53' AND e.date<='2024-10-11 20:49:53' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9003' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 21:49:53' AND e.date<='2024-10-11 20:49:53' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055170423' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 09:18:27' AND e.date<='2024-10-11 09:18:27' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055170423' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 09:18:27' AND e.date<='2024-10-11 09:18:27' 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-10-07 20:00:00' AND e.date<='2024-10-08 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-10-07 20:00:00' AND e.date<='2024-10-08 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='2913' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2913' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='3023' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='3023' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='862531041041535' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='862531041041535' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2571' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2571' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2728' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2728' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2743' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2743' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 20:00:00' AND e.date<='2024-10-08 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='2756' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2756' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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-10-08 20:00:00' AND e.date<='2024-10-09 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-10-08 20:00:00' AND e.date<='2024-10-09 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='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='3023' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='3023' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2773' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2773' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='862531041041535' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='862531041041535' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='4868' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='4868' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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-10-08 20:00:00' AND e.date<='2024-10-09 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-10-08 20:00:00' AND e.date<='2024-10-09 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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2728' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='2728' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 20:00:00' AND e.date<='2024-10-09 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='3154' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='3154' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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-10-09 20:00:00' AND e.date<='2024-10-10 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-10-09 20:00:00' AND e.date<='2024-10-10 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='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='3263' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='3263' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='5082' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='5082' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='358021081941837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='358021081941837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='2571' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='2571' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 20:00:00' AND e.date<='2024-10-10 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-10-10 20:00:00' AND e.date<='2024-10-11 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-10-10 20:00:00' AND e.date<='2024-10-11 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='9376' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='9376' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='862531041041535' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='862531041041535' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='352353083499175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='352353083499175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2728' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2728' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2667' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2667' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 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='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-10 20:00:00' AND e.date<='2024-10-11 02:00:00'