[28/Nov/2020:02:00:09] (OfflineReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='offline' order by accountID [28/Nov/2020:02:00:09] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:00:09] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:00:09] (OfflineReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:00:09] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:00:09] (OfflineReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:00:09] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:09] (OfflineReportSentToMail) Return Group List [28/Nov/2020:02:00:09] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:09] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:00:26] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:00:26] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:00:26] (OfflineReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:00:26] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:00:26] (OfflineReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:00:26] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:26] (OfflineReportSentToMail) Return Group List [28/Nov/2020:02:00:26] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:26] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:00:29] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:00:29] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:00:29] (OfflineReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:00:29] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:00:29] (OfflineReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:00:29] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:29] (OfflineReportSentToMail) Return Group List [28/Nov/2020:02:00:29] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:00:29] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:30:01] (IgnitionOnOffReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='ignitiononoff' order by accountID [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='powercut' order by accountID [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Groups For :tnemri admin [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account Settings For :tnemri [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account String For :tnemri [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) Return Group List [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='currentstatus' order by accountID [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) Return Group List [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:03] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) Return Group List [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:04] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) Return Group List [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:05] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Return Group List [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Groups For :tnemri administrator [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='administrator' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Account Settings For :tnemri [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Get Account String For :tnemri [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) Return Group List [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:40:06] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) Get Groups For :tnemri admin [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) Get Account Settings For :tnemri [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) Get Account String For :tnemri [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) Return Group List [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:44:42] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) Get Groups For :tnemri admin [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) Get Account Settings For :tnemri [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) Get Account String For :tnemri [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) Return Group List [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:02:45:09] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='overspeed' order by accountID [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) Return Group List [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:03] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) Return Group List [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:11] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Return Group List [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) Return Group List [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:03:00:12] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:03:30:02] (GeozoneReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='geozone' order by accountID [28/Nov/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 [28/Nov/2020:10:00:02] (DistanceReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:10:00:02] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:10:00:02] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:02] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:02] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:02] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:02] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:02] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:02] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:03] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:03] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:03] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:03] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:04] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:04] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Groups For :tn1962 administrator [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:04] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Groups For :tn1962 admin [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account Settings For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Get Account String For :tn1962 [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) Return Group List [28/Nov/2020:10:00:04] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [28/Nov/2020:10:00:04] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:00:04] (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 1606415400 AND 1606501799 [28/Nov/2020:10:24:16] (login) Get Groups For :tnemri administrator [28/Nov/2020:10:24:16] (login) select * from AccountUserSettings where accountID='tnemri' and userID='administrator' [28/Nov/2020:10:24:16] (login) Get Account Settings For :tnemri [28/Nov/2020:10:24:16] (login) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:10:24:16] (login) Get Account String For :tnemri [28/Nov/2020:10:24:16] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:16] (login) Return Group List [28/Nov/2020:10:24:16] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:16] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:16] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:16] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:23] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:23] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:23] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606539263','106.211.230.10') [28/Nov/2020:10:24:24] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:24] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:31] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:31] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:33] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:33] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:34] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:40] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:40] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:40] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:42] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:42] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:48] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:48] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:48] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:55] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:55] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:55] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:24:56] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:24:56] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:26:07] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:07] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:07] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:07] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:26:10] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:10] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:26:11] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:11] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:26:15] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606539375','106.211.230.10') [28/Nov/2020:10:26:16] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:16] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:26:16] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:18] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:26:18] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:28:55] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:28:55] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:28:55] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:28:55] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:28:58] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:28:58] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:28:58] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606539538','106.211.230.10') [28/Nov/2020:10:29:00] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:29:00] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:29:01] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:29:28] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:29:28] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:29:28] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:29:28] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:29:49] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:30:56] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:31:33] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:32:34] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:32:41] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:34:14] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:34:47] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:34:47] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:34:47] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:40] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:40] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:41] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:41] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:43] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:43] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:49] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:49] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:50] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:50] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:50] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:50] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:52] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:52] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:35:58] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:35:58] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:01] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:01] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:13] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:13] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:14] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:14] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:27] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:27] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:27] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:27] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:27] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:28] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:28] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:31] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:31] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:31] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:31] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:31] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:33] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606539992','106.211.230.10') [28/Nov/2020:10:36:42] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:42] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:42] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:48] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:48] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:51] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:36:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:36:57] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:37:19] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:37:19] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:37:43] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:37:43] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:38:58] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:38:58] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:39:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:39:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:40:00] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:40:00] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:40:28] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:40:28] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:40:57] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:40:58] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:41:28] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:41:28] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:41:58] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:41:58] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:42:28] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:42:28] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:42:57] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:42:57] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:42:58] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:42:58] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:42:58] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:02] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:02] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:02] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:02] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606540382','106.211.230.10') [28/Nov/2020:10:43:12] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:12] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:12] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:17] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:34] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:34] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:36] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:36] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:39] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:39] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:43:48] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:43:48] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:02] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:02] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:04] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:04] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:18] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:18] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:27] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:42] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:42] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:43] (OfflineAndCurrentStatusForAllVehicles) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:43] (OfflineAndCurrentStatusForAllVehicles) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:49] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:49] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:44:59] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:44:59] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:45:12] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:45:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:45:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:45:43] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:45:43] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:47:16] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:47:16] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:47:43] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:47:43] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:47:43] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:47:51] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:48:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:48:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:48:07] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:48:07] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:48:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:48:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:48:57] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:48:57] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:49:24] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:49:24] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:49:53] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:49:53] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:50:23] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:50:23] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:50:52] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:50:52] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:51:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:51:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:51:53] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:51:53] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:52:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:52:23] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:52:52] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:52:52] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:53:55] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:53:56] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:10:54:23] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:10:54:23] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:51:45] (login) Get Groups For :tnemri administrator [28/Nov/2020:12:51:45] (login) select * from AccountUserSettings where accountID='tnemri' and userID='administrator' [28/Nov/2020:12:51:45] (login) Get Account Settings For :tnemri [28/Nov/2020:12:51:45] (login) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:12:51:45] (login) Get Account String For :tnemri [28/Nov/2020:12:51:45] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:45] (login) Return Group List [28/Nov/2020:12:51:47] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:47] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:47] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:47] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:51:52] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:52] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:51:53] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606548113','106.211.230.34') [28/Nov/2020:12:51:53] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:54] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:51:56] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:56] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:56] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:51:57] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:51:57] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:56:16] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:56:16] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:56:16] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:56:18] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:56:18] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:56:20] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606548379','106.211.230.34') [28/Nov/2020:12:56:22] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:56:22] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:56:22] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:22] (login) Get Groups For :tnemri administrator [28/Nov/2020:12:58:22] (login) select * from AccountUserSettings where accountID='tnemri' and userID='administrator' [28/Nov/2020:12:58:22] (login) Get Account Settings For :tnemri [28/Nov/2020:12:58:22] (login) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:12:58:22] (login) Get Account String For :tnemri [28/Nov/2020:12:58:22] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:22] (login) Return Group List [28/Nov/2020:12:58:22] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:22] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:22] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:22] (index) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:24] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:24] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:27] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:27] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:31] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606548511','106.211.230.34') [28/Nov/2020:12:58:32] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:32] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:34] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:34] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:40] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:40] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:41] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606548521','106.211.230.34') [28/Nov/2020:12:58:42] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:42] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:48] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:48] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:49] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:49] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:54] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:54] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:58:56] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:58:56] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:59:01] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:01] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:59:02] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:02] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:59:06] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:12:59:48] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','administrator','mapmyindia','map','1606548588','106.211.230.34') [28/Nov/2020:12:59:51] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:12:59:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:00:30] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:00:30] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:00:33] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:00:33] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:00:36] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:27] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:38] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:38] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:05:57] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:05:57] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:06:23] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:06:23] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:06:38] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:06:38] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:07:08] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:07:08] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:07:38] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:07:38] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:08:08] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:08:08] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:08:38] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:08:38] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:09:08] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:09:08] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:09:39] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:09:39] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:10:08] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:10:08] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:10:38] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:10:39] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:13:11:08] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:13:11:08] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [28/Nov/2020:20:43:43] (login) Get Groups For :tnemri karur [28/Nov/2020:20:43:43] (login) select * from AccountUserSettings where accountID='tnemri' and userID='karur' [28/Nov/2020:20:43:43] (login) Get Account Settings For :tnemri [28/Nov/2020:20:43:43] (login) select * from AccountSetup where accountID='tnemri' [28/Nov/2020:20:43:43] (login) Get Account String For :tnemri [28/Nov/2020:20:43:43] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:43] (login) Return Group List [28/Nov/2020:20:43:44] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:44] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:44] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:44] (index) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:43:49] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:49] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','karur','mapmyindia','map','1606576429','42.106.187.250') [28/Nov/2020:20:43:50] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:43:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:43:53] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:53] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:43:54] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:58] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:43:58] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:49:45] (login) Get Groups For :Tnemri admin [28/Nov/2020:20:49:45] (login) select * from AccountUserSettings where accountID='Tnemri' and userID='admin' [28/Nov/2020:20:49:45] (login) Get Account Settings For :Tnemri [28/Nov/2020:20:49:45] (login) select * from AccountSetup where accountID='Tnemri' [28/Nov/2020:20:49:45] (login) Get Account String For :Tnemri [28/Nov/2020:20:49:45] (login) select * from AccountString where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:45] (login) Return Group List [28/Nov/2020:20:49:45] (index) SELECT * from Geozone where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:45] (index) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:45] (index) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:45] (index) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:49:57] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:57] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:49:58] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tnemri','admin','mapmyindia','map','1606576798','157.46.107.18') [28/Nov/2020:20:49:59] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:49:59] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:50:01] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:50:01] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:50:03] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:50:03] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:50:37] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:50:37] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:50:39] (dashboardStats) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:50:39] (dashboardStats) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:19] (login) Get Groups For :Tn1962 admin [28/Nov/2020:20:52:19] (login) select * from AccountUserSettings where accountID='Tn1962' and userID='admin' [28/Nov/2020:20:52:19] (login) Get Account Settings For :Tn1962 [28/Nov/2020:20:52:19] (login) select * from AccountSetup where accountID='Tn1962' [28/Nov/2020:20:52:19] (login) Get Account String For :Tn1962 [28/Nov/2020:20:52:19] (login) select * from AccountString where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:19] (login) Return Group List [28/Nov/2020:20:52:19] (index) SELECT * from Geozone where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:19] (index) select groupID,description from DeviceGroup where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:19] (index) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:19] (index) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:22] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:22] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:23] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:23] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:23] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tn1962','admin','mapmyindia','map','1606576943','157.46.107.18') [28/Nov/2020:20:52:23] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:23] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:23] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:23] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:29] (index) select groupID,description from DeviceGroup where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:29] (index) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:29] (index) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:31] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:31] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:31] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:32] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tn1962','admin','mapmyindia','map','1606576952','157.46.107.18') [28/Nov/2020:20:52:51] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:51] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:51] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:52] (index) SELECT * from Geozone where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:52] (index) select groupID,description from DeviceGroup where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:52] (index) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:52] (index) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:53] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:53] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:53] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:53] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:53] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tn1962','admin','mapmyindia','map','1606576973','157.46.107.18') [28/Nov/2020:20:52:53] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:53] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:52:53] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:52:53] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:03] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:03] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:03] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:03] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:43] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:43] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:43] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:43] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:53:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:53:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:14] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:14] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:14] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:14] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:14] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:15] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:15] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:15] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:15] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:15] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:15] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:15] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:24] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:24] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:25] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:25] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:34] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:34] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:34] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:34] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:44] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:44] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:54] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:54] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:54:54] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:54:54] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:55:03] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:55:03] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:55:03] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:55:03] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:55:13] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:55:13] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:55:14] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:55:14] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='Tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='Tnemri' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='karur' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:04] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:05] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:05] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:06] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:06] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:07] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:07] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:15] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:15] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:15] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:15] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:16] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:16] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:20] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:20] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:20] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:20] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:44] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:44] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:45] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:45] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:46] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:46] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:46] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:46] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:55] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:55] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:57:55] (dashboardStats) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:57:55] (dashboardStats) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open' [28/Nov/2020:20:58:13] (GetNotification) SELECT * from Driver where accountID='Tn1962' and ln_id='en' [28/Nov/2020:20:58:13] (GetNotification) select * from tripschedule where accountID='Tn1962' and userID='admin' and tripStatus='open'