Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 06:53:34' AND e.date<='2024-11-16 21:53:34' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 06:53:34' AND e.date<='2024-11-16 21:53:34' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 06:55:03' AND e.date<='2024-11-17 21:55:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 06:55:03' AND e.date<='2024-11-17 21:55:03' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-16 05:56:22' AND e.date<='2024-11-18 06:56:22' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-16 05:56:22' AND e.date<='2024-11-18 06:56:22' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 06:57:21' AND e.date<='2024-11-18 06:57:21' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 06:57:21' AND e.date<='2024-11-18 06:57:21' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-16 06:58:10' AND e.date<='2024-11-18 06:58:10' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-16 06:58:10' AND e.date<='2024-11-18 06:58:10' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 01:58:01' AND e.date<='2024-11-18 07:58:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 01:58:01' AND e.date<='2024-11-18 07:58:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 01:58:37' AND e.date<='2024-11-18 07:58:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 01:58:37' AND e.date<='2024-11-18 07:58:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 01:59:07' AND e.date<='2024-11-18 07:59:07' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 01:59:07' AND e.date<='2024-11-18 07:59:07' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 03:30:56' AND e.date<='2024-11-18 09:30:56' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 03:30:56' AND e.date<='2024-11-18 09:30:56' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 02:31:19' AND e.date<='2024-11-18 09:31:19' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 02:31:19' AND e.date<='2024-11-18 09:31:19' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116281466' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 05:16:58' AND e.date<='2024-11-18 10:16:58' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116281466' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 05:16:58' AND e.date<='2024-11-18 10:16:58' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3064' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4883' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4883' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2677' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2677' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086144547' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086144547' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2499' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2499' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2627' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2888' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2888' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-15 21:00:00' AND e.date<='2024-11-16 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9014' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9014' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060537865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060537865' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086185359' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086185359' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080080590' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080080590' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8983' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8983' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9011' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9011' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3136' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3136' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3025' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3025' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5082' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5082' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4959' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4959' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279820' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279820' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2755' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2755' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-18 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 11:52:35' AND e.date<='2024-11-18 11:52:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 11:52:35' AND e.date<='2024-11-18 11:52:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 22:52:35' AND e.date<='2024-11-18 11:52:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 22:52:35' AND e.date<='2024-11-18 11:52:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 22:52:35' AND e.date<='2024-11-17 21:52:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055521468' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 22:52:35' AND e.date<='2024-11-17 21:52:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2875' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-11 16:45:35' AND e.date<='2024-11-11 16:59:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2875' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-11 16:45:35' AND e.date<='2024-11-11 16:59:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-14 13:00:35' AND e.date<='2024-11-14 13:10:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-14 13:00:35' AND e.date<='2024-11-14 13:10:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 20:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 20:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 19:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 19:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 18:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 18:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 17:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 17:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 21:59:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 21:59:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 16:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 22:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 15:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-16 23:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 03:00:00' AND e.date<='2024-11-16 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 03:00:00' AND e.date<='2024-11-17 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-16 21:00:00' AND e.date<='2024-11-17 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2722' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-11 03:00:00' AND e.date<='2024-11-15 21:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2722' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-11 03:00:00' AND e.date<='2024-11-15 21:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 01:51:11' AND e.date<='2024-11-18 12:51:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 01:51:11' AND e.date<='2024-11-18 12:51:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 05:02:35' AND e.date<='2024-11-18 13:02:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-18 05:02:35' AND e.date<='2024-11-18 13:02:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 12:13:41' AND e.date<='2024-11-18 13:13:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 12:13:41' AND e.date<='2024-11-18 13:13:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-18 11:13:59' AND e.date<='2024-11-18 13:13:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-18 11:13:59' AND e.date<='2024-11-18 13:13:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-18 11:14:31' AND e.date<='2024-11-18 13:14:31' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-18 11:14:31' AND e.date<='2024-11-18 13:14:31'