[06/Dec/2020:02:00:01] (OfflineReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='offline' order by accountID 
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) Get Groups For :tn1962  administrator
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) Get Account Settings For :tn1962
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) Get Account String For :tn1962
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) Return Group List 
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[06/Dec/2020:02:00:01] (OfflineReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[06/Dec/2020:02:30:04] (IgnitionOnOffReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='ignitiononoff' order by accountID 
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='currentstatus' order by accountID 
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) Get Groups For :tn1962  administrator
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) Get Account String For :tnemri
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account String For :tn1962
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) Return Group List 
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) Return Group List 
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:02:40:02] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[06/Dec/2020:02:40:02] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) Get Account String For :tnemri
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) Return Group List 
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:02:55:02] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='overspeed' order by accountID 
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) Get Groups For :tn1962  admin
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) Get Account Settings For :tn1962
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) Get Account String For :tn1962
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) Return Group List 
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[06/Dec/2020:03:00:02] (OverSpeedReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[06/Dec/2020:03:10:04] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) Get Account String For :tnemri
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) Return Group List 
[06/Dec/2020:03:10:05] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:03:10:06] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[06/Dec/2020:03:30:03] (GeozoneReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='geozone' order by accountID 
[06/Dec/2020:08:24:49] (login) Get Groups For :tnemri  karur
[06/Dec/2020:08:24:49] (login) select * from AccountUserSettings where accountID='tnemri' and userID='karur'
[06/Dec/2020:08:24:49] (login) Get Account Settings For :tnemri
[06/Dec/2020:08:24:49] (login) select * from  AccountSetup where accountID='tnemri'
[06/Dec/2020:08:24:49] (login) Get Account String For :tnemri
[06/Dec/2020:08:24:49] (login) select * from  AccountString where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:49] (login) Return Group List 
[06/Dec/2020:08:24:50] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:51] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:51] (index) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:51] (index) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:24:53] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:53] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:24:54] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','karur','mapmyindia','map','1607223294','42.106.184.166')
[06/Dec/2020:08:24:59] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:24:59] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:25:03] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:25:03] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:25:07] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:25:07] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:25:09] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:25:09] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:25:11] (dashboardStats) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:25:11] (dashboardStats) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:25:15] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:22] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:22] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:22] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:22] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:22] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:22] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:22] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:22] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:27] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:28] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:46] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:27:53] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:27:53] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:28:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:28:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:28:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:28:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:29:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:29:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:29:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:29:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:30:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:30:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:30:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:30:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:31:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:31:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:31:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:31:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:32:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:32:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:32:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:32:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:33:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:33:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:33:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:33:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:34:18] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:34:18] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:34:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:34:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:35:20] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:35:20] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:35:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:35:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:36:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:36:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:36:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:36:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:37:17] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:37:17] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:08:37:47] (GetNotification) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[06/Dec/2020:08:37:47] (GetNotification) select * from tripschedule  where accountID='tnemri' and userID='karur' and tripStatus='open'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) SELECT a.accountID,a.emailaddress,a.groupID,a.reportSchedule,a.reporttype,a.userID FROM email a,AccountSetup b where a.accountID=b.accountID and b.distanceidlereportcron=1 and a.reportSchedule='daily' and a.description='distanceidlereport' order by a.accountID 
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) Get Groups For :tn1962  administrator
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) Get Account Settings For :tn1962
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) Get Account String For :tn1962
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) Return Group List 
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1607106600 AND 1607192999
[06/Dec/2020:10:00:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1607106600 AND 1607192999