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-10-25 02:53:44' AND e.date<='2024-10-25 04:53:44' 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-10-25 02:53:44' AND e.date<='2024-10-25 04:53:44' 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-10-24 04:54:26' AND e.date<='2024-10-24 20:54:26' 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-10-24 04:54:26' AND e.date<='2024-10-24 20:54:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 03:56:46' AND e.date<='2024-10-25 04:56: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-25 03:56:46' AND e.date<='2024-10-25 04:56: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 04:57:09' AND e.date<='2024-10-24 17:57:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-24 04:57:09' AND e.date<='2024-10-24 17:57:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-24 04:57:50' AND e.date<='2024-10-24 20:57:50' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-24 04:57:50' AND e.date<='2024-10-24 20:57:50' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:15:25' AND e.date<='2024-10-25 06:15:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:15:25' AND e.date<='2024-10-25 06:15:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:16:05' AND e.date<='2024-10-25 06:16:05' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:16:05' AND e.date<='2024-10-25 06:16:05' 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-10-24 01:18:44' AND e.date<='2024-10-25 06:18:44' 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-10-24 01:18:44' AND e.date<='2024-10-25 06:18:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-21 20:00:00' AND e.date<='2024-10-22 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='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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='4959' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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='4959' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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='2590' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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='2590' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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-21 20:00:00' AND e.date<='2024-10-22 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='3068' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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='3068' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 20:00:00' AND e.date<='2024-10-22 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='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='3126' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='3126' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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='5076' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='5076' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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='2674' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='2674' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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-22 20:00:00' AND e.date<='2024-10-23 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='2736' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2736' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='9011' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='9011' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2575' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2575' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3126' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3126' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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='3188' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3188' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 02:00:00' AND e.date<='2024-10-23 20: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='3175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 02:00:00' AND e.date<='2024-10-23 20: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='3175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 02:00:00' AND e.date<='2024-10-23 20:30: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='3175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 02:00:00' AND e.date<='2024-10-23 20:30: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='3175' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 17:00:00' AND e.date<='2024-10-23 20:30: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='3175' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 17:00:00' AND e.date<='2024-10-23 20:30: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='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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='2771' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2771' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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='8983' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='8983' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2499' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2499' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2584' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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='2584' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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-23 20:00:00' AND e.date<='2024-10-24 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='2704' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2704' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078116298288' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078116298288' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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='3064' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3064' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='5080' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='5080' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3126' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3126' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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-24 20:00:00' AND e.date<='2024-10-25 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='2458' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2458' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3100' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3100' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2499' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2499' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2584' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2584' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2704' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2704' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3197' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='3197' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='2964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 20:00:00' AND e.date<='2024-10-25 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='356078111451585' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:37:32' AND e.date<='2024-10-24 20:37: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='356078111451585' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:37:32' AND e.date<='2024-10-24 20:37: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-25 03:38:26' AND e.date<='2024-10-25 08:38:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 03:38:26' AND e.date<='2024-10-25 08:38:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 21:11:32' AND e.date<='2024-10-25 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 21:11:32' AND e.date<='2024-10-25 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 21:11:32' AND e.date<='2024-10-23 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 21:11:32' AND e.date<='2024-10-23 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-13 21:11:32' AND e.date<='2024-10-14 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-13 21:11:32' AND e.date<='2024-10-14 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-14 21:11:32' AND e.date<='2024-10-15 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-14 21:11:32' AND e.date<='2024-10-15 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-15 21:11:32' AND e.date<='2024-10-16 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-15 21:11:32' AND e.date<='2024-10-16 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:11:32' AND e.date<='2024-10-21 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:11:32' AND e.date<='2024-10-21 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 21:11:32' AND e.date<='2024-10-22 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 21:11:32' AND e.date<='2024-10-22 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 21:11:32' AND e.date<='2024-10-23 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 21:11:32' AND e.date<='2024-10-23 20:11: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='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:11:32' AND e.date<='2024-10-24 20:11: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='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 21:11:32' AND e.date<='2024-10-25 20:11: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='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 21:11:32' AND e.date<='2024-10-25 20:11: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='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-15 21:20:55' AND e.date<='2024-10-16 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-15 21:20:55' AND e.date<='2024-10-16 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-13 21:20:55' AND e.date<='2024-10-16 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-13 21:20:55' AND e.date<='2024-10-16 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-13 21:20:55' AND e.date<='2024-10-17 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-13 21:20:55' AND e.date<='2024-10-17 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-17 21:20:55' AND e.date<='2024-10-18 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-17 21:20:55' AND e.date<='2024-10-18 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:20:55' AND e.date<='2024-10-21 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:20:55' AND e.date<='2024-10-21 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 21:20:55' AND e.date<='2024-10-23 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 21:20:55' AND e.date<='2024-10-23 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:20:55' AND e.date<='2024-10-21 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:20:55' AND e.date<='2024-10-21 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 21:20:55' AND e.date<='2024-10-22 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 21:20:55' AND e.date<='2024-10-23 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 21:20:55' AND e.date<='2024-10-23 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2908' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 21:20:55' AND e.date<='2024-10-24 20:20:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 02:44:36' AND e.date<='2024-10-25 09:44:36' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 02:44:36' AND e.date<='2024-10-25 09:44:36' 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-10-25 02:44:51' AND e.date<='2024-10-25 09:44:51' 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-10-25 02:44:51' AND e.date<='2024-10-25 09:44:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 03:46:24' AND e.date<='2024-10-25 09:46:24' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-25 03:46:24' AND e.date<='2024-10-25 09:46:24' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-24 22:46:39' AND e.date<='2024-10-25 09:46:39' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-24 22:46:39' AND e.date<='2024-10-25 09:46:39' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2485' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 21:29:52' AND e.date<='2024-10-25 11:29:52' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2485' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 21:29:52' AND e.date<='2024-10-25 11:29:52' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2590' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 21:56:34' AND e.date<='2024-10-25 11:56:34' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2590' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 21:56:34' AND e.date<='2024-10-25 11:56:34' 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-10-25 02:45:03' AND e.date<='2024-10-25 15:45:03' 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-10-25 02:45:03' AND e.date<='2024-10-25 15:45:03' 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-10-25 11:45:31' AND e.date<='2024-10-25 17:45:31' 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-10-25 11:45:31' AND e.date<='2024-10-25 17:45:31'