Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-08 21:46:07' AND e.date<='2024-07-09 20:46:07' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-08 21:46:07' AND e.date<='2024-07-09 20:46:07' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3176' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3176' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='3203' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='3203' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='352353084209250' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='352353084209250' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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='2953' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='2953' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='5126' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='5126' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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='352353084344826' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='352353084344826' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='3172' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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='3172' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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-07-05 20:00:00' AND e.date<='2024-07-06 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='3123' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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='3123' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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-07-06 20:00:00' AND e.date<='2024-07-07 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-07-06 20:00:00' AND e.date<='2024-07-07 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='9382' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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='9382' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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-07-06 20:00:00' AND e.date<='2024-07-07 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-07-06 20:00:00' AND e.date<='2024-07-07 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='356078111279820' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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='356078111279820' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-06 20:00:00' AND e.date<='2024-07-07 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='356078116287711' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='356078116287711' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2753' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2753' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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-07-07 20:00:00' AND e.date<='2024-07-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='5082' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='5082' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='353173060537865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='353173060537865' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2662' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2662' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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-07-07 20:00:00' AND e.date<='2024-07-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-07-07 20:00:00' AND e.date<='2024-07-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='352353083500956' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='352353083500956' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2912' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='2912' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 20:00:00' AND e.date<='2024-07-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='358021081839700' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-08 21:20:59' AND e.date<='2024-07-09 20:20:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081839700' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-08 21:20:59' AND e.date<='2024-07-09 20:20:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-08 21:20:59' AND e.date<='2024-07-09 20:20:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-08 21:20:59' AND e.date<='2024-07-09 20:20:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:20:59' AND e.date<='2024-07-10 20:20:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:20:59' AND e.date<='2024-07-10 20:20:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-09 06:35:29' AND e.date<='2024-07-10 06:35:29' 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-07-09 06:35:29' AND e.date<='2024-07-10 06:35:29' 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-07-08 06:35:29' AND e.date<='2024-07-10 06:35:29' 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-07-08 06:35:29' AND e.date<='2024-07-10 06:35:29' 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-06-23 20:00:00' AND e.date<='2024-06-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-06-23 20:00:00' AND e.date<='2024-06-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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-23 20:00:00' AND e.date<='2024-06-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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-23 20:00:00' AND e.date<='2024-06-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='2884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:03:42' AND e.date<='2024-07-08 20:03:42' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:03:42' AND e.date<='2024-07-08 20:03:42' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:29:35' AND e.date<='2024-07-02 20:29:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:29:35' AND e.date<='2024-07-02 20:29:35' 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-07-09 11:03:08' AND e.date<='2024-07-10 11:03:08' 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-07-09 11:03:08' AND e.date<='2024-07-10 11:03:08' 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-06-30 21:03:08' AND e.date<='2024-07-01 20:03:08' 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-06-30 21:03:08' AND e.date<='2024-07-01 20:03:08' 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-07-01 21:03:08' AND e.date<='2024-07-02 20:03:08' 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-07-01 21:03:08' AND e.date<='2024-07-02 20:03:08' 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-07-02 21:03:08' AND e.date<='2024-07-03 20:03:08' 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-07-02 21:03:08' AND e.date<='2024-07-03 20:03:08' 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-07-09 21:03:08' AND e.date<='2024-07-10 20:03:08' 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-07-09 21:03:08' AND e.date<='2024-07-10 20:03:08' 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-07-07 21:03:08' AND e.date<='2024-07-10 20:03:08' 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-07-07 21:03:08' AND e.date<='2024-07-10 20:03:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-13 20:00:00' AND e.date<='2024-06-14 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-13 20:00:00' AND e.date<='2024-06-14 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-14 20:00:00' AND e.date<='2024-06-15 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-14 20:00:00' AND e.date<='2024-06-15 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-14 20:00:00' AND e.date<='2024-06-15 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2761' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-14 20:00:00' AND e.date<='2024-06-15 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055170423' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:05:54' AND e.date<='2024-07-10 12:05:54' 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-06-30 21:05:54' AND e.date<='2024-07-10 12:05:54' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 03:36:37' AND e.date<='2024-07-10 17:36:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 03:36:37' AND e.date<='2024-07-10 17:36:37'