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-06-26 21:58:13' AND e.date<='2024-06-27 20:58:13' 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-06-26 21:58:13' AND e.date<='2024-06-27 20:58:13' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-24 21:01:13' AND e.date<='2024-06-25 20:01:13' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-24 21:01:13' AND e.date<='2024-06-25 20:01:13' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-06-30 21:08:12' AND e.date<='2024-07-01 07:08:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-06-30 21:08:12' AND e.date<='2024-07-01 07:08:12' 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-06-30 21:08:44' AND e.date<='2024-07-01 07:08: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:08:44' AND e.date<='2024-07-01 07:08: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-06-30 02:09:06' AND e.date<='2024-06-30 20:09:06' 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-06-30 02:09:06' AND e.date<='2024-06-30 20:09:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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='353173066433796' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='353173066433796' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='352353084234167' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='352353084234167' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='2871' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='2871' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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='352353086167449' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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='352353086167449' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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-06-28 20:00:00' AND e.date<='2024-06-29 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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='3045' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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='3045' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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='352353083473741' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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='2677' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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='2677' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-29 20:00:00' AND e.date<='2024-06-30 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-06-30 20:00:00' AND e.date<='2024-07-01 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-06-30 20:00:00' AND e.date<='2024-07-01 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 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-06-30 20:00:00' AND e.date<='2024-07-01 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-06-30 20:00:00' AND e.date<='2024-07-01 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='2574' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 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='2574' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 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='356078116291259' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 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='356078116291259' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 20:00:00' AND e.date<='2024-07-01 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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:18:56' AND e.date<='2024-07-01 10:18:56' 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-06-30 21:18:56' AND e.date<='2024-07-01 10:18:56' 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-07-01 08:34:40' AND e.date<='2024-07-01 10:34:40' 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-07-01 08:34:40' AND e.date<='2024-07-01 10:34:40' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 04:33:06' AND e.date<='2024-06-28 05:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 04:33:06' AND e.date<='2024-06-28 05:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 16:33:06' AND e.date<='2024-06-28 17:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 16:33:06' AND e.date<='2024-06-28 17:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 15:33:06' AND e.date<='2024-06-28 16:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 15:33:06' AND e.date<='2024-06-28 16:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-27 03:33:06' AND e.date<='2024-06-27 04:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-27 03:33:06' AND e.date<='2024-06-27 04:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 04:33:06' AND e.date<='2024-06-26 05:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 04:33:06' AND e.date<='2024-06-26 05:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 04:33:06' AND e.date<='2024-06-26 05:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 04:33:06' AND e.date<='2024-06-26 05:33:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 05:33:06' AND e.date<='2024-06-26 06:33:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 05:33:06' AND e.date<='2024-06-26 06:33:06' 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-07-01 10:18:53' AND e.date<='2024-07-01 13:18:53' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 10:18:53' AND e.date<='2024-07-01 13:18:53'