{"userId":"1","date":"2021-01-21 12:08:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '117.204.227.161', '2021-01-21 12:08:26')"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE onssid = '3360'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE onssid = '3361'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE onssid = '3362'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE onssid = '3363'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '1' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '3' when ansid=79239 then '3' when ansid=79240 then '3' when ansid=79241 then '1' when ansid=79242 then '' when ansid=79243 then '1' when ansid=79244 then '1' when ansid=79245 then '' when ansid=79246 then '1' when ansid=79247 then '' when ansid=79248 then '1' when ansid=79249 then '' when ansid=79250 then '1' when ansid=79251 then '1' when ansid=79252 then '1' when ansid=79253 then '1' when ansid=79254 then '' when ansid=79255 then '1' when ansid=79256 then '' when ansid=79257 then '1' when ansid=79258 then '' when ansid=79259 then '1' when ansid=79260 then '' when ansid=79261 then '1' when ansid=79262 then '' when ansid=79263 then '1' when ansid=79264 then '' when ansid=79265 then '1' when ansid=79266 then '' when ansid=79267 then '1' when ansid=79268 then '1' when ansid=79269 then '1' when ansid=79270 then '1' when ansid=79271 then '1' when ansid=79272 then '1' when ansid=79273 then 'NO' when ansid=79274 then 'NO' when ansid=79275 then 'NO' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.204.227.161',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 12:19:38'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE supvisstepid = '4844'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE visitfeedbackid = '3566'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE visitfeedbackid = '3567'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE visitfeedbackid = '3568'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE visitfeedbackid = '3569'"} {"userId":"1","date":"2021-01-21 12:19:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:19:38' WHERE visitfeedbackid = '3570'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3360'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3361'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3362'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3363'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '1' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '3' when ansid=79239 then '3' when ansid=79240 then '3' when ansid=79241 then '1' when ansid=79242 then '' when ansid=79243 then '1' when ansid=79244 then '1' when ansid=79245 then '' when ansid=79246 then '1' when ansid=79247 then '' when ansid=79248 then '1' when ansid=79249 then '' when ansid=79250 then '1' when ansid=79251 then '1' when ansid=79252 then '1' when ansid=79253 then '1' when ansid=79254 then '' when ansid=79255 then '1' when ansid=79256 then '' when ansid=79257 then '1' when ansid=79258 then '' when ansid=79259 then '1' when ansid=79260 then '' when ansid=79261 then '1' when ansid=79262 then '' when ansid=79263 then '1' when ansid=79264 then '' when ansid=79265 then '1' when ansid=79266 then '' when ansid=79267 then '1' when ansid=79268 then '1' when ansid=79269 then '1' when ansid=79270 then '1' when ansid=79271 then '1' when ansid=79272 then '1' when ansid=79273 then 'NO' when ansid=79274 then 'NO' when ansid=79275 then 'NO' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.204.227.161',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 12:20:08'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE supvisstepid = '4844'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3566'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3567'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3568'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3569'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3570'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3360'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3361'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3362'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE onssid = '3363'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '1' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '3' when ansid=79239 then '3' when ansid=79240 then '3' when ansid=79241 then '1' when ansid=79242 then '' when ansid=79243 then '1' when ansid=79244 then '1' when ansid=79245 then '' when ansid=79246 then '1' when ansid=79247 then '' when ansid=79248 then '1' when ansid=79249 then '' when ansid=79250 then '1' when ansid=79251 then '1' when ansid=79252 then '1' when ansid=79253 then '1' when ansid=79254 then '' when ansid=79255 then '1' when ansid=79256 then '' when ansid=79257 then '1' when ansid=79258 then '' when ansid=79259 then '1' when ansid=79260 then '' when ansid=79261 then '1' when ansid=79262 then '' when ansid=79263 then '1' when ansid=79264 then '' when ansid=79265 then '1' when ansid=79266 then '' when ansid=79267 then '1' when ansid=79268 then '1' when ansid=79269 then '1' when ansid=79270 then '1' when ansid=79271 then '1' when ansid=79272 then '1' when ansid=79273 then 'NO' when ansid=79274 then 'NO' when ansid=79275 then 'NO' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.204.227.161',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 12:20:08'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE supvisstepid = '4845'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3566'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3567'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3568'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3569'"} {"userId":"1","date":"2021-01-21 12:20:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:08' WHERE visitfeedbackid = '3570'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE onssid = '3360'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE onssid = '3361'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE onssid = '3362'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE onssid = '3363'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '1' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '3' when ansid=79239 then '3' when ansid=79240 then '3' when ansid=79241 then '1' when ansid=79242 then '' when ansid=79243 then '1' when ansid=79244 then '1' when ansid=79245 then '' when ansid=79246 then '1' when ansid=79247 then '' when ansid=79248 then '1' when ansid=79249 then '' when ansid=79250 then '1' when ansid=79251 then '1' when ansid=79252 then '1' when ansid=79253 then '1' when ansid=79254 then '' when ansid=79255 then '1' when ansid=79256 then '' when ansid=79257 then '1' when ansid=79258 then '' when ansid=79259 then '1' when ansid=79260 then '' when ansid=79261 then '1' when ansid=79262 then '' when ansid=79263 then '1' when ansid=79264 then '' when ansid=79265 then '1' when ansid=79266 then '' when ansid=79267 then '1' when ansid=79268 then '1' when ansid=79269 then '1' when ansid=79270 then '1' when ansid=79271 then '1' when ansid=79272 then '1' when ansid=79273 then 'NO' when ansid=79274 then 'NO' when ansid=79275 then 'NO' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.204.227.161',\n\t\t\t\t\t\t\t\tmodifiedby =1,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 12:20:31'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE supvisstepid = '4845'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE visitfeedbackid = '3566'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE visitfeedbackid = '3567'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE visitfeedbackid = '3568'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE visitfeedbackid = '3569'"} {"userId":"1","date":"2021-01-21 12:20:31","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.204.227.161', `modifiedby` = '1', `modifieddate` = '2021-01-21 12:20:31' WHERE visitfeedbackid = '3570'"} {"userId":"1","date":"2021-01-21 15:26:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '49.34.178.132', '2021-01-21 15:26:00')"} {"userId":"1","date":"2021-01-21 18:44:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '117.204.227.161', '2021-01-21 18:44:33')"} {"userId":"243","date":"2021-01-21 21:37:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '122.161.165.188', '2021-01-21 21:37:18')"} {"userId":"243","date":"2021-01-21 21:38:28","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1529', '2021-01-21', '243', '122.161.165.188', '243', '2021-01-21 21:38:28')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1529', '950', '243', '2021-01-21', '1', '122.161.165.188', '243', '2021-01-21 21:38:32', '', '')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('761', '0', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('761', '1', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('761', '2', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('761', '3', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('761', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('761', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('761', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('761', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:38:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('761', '122.161.165.188', '243', '2021-01-21 21:38:32')"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE sitesupervision SET `siteid` = '1529', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '761'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE onssid = '3372'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE onssid = '3373'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE onssid = '3374'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE onssid = '3375'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79436 then '1' when ansid=79437 then '1' when ansid=79438 then '1' when ansid=79439 then '10' when ansid=79440 then '10' when ansid=79441 then '1' when ansid=79442 then '1' when ansid=79443 then '' when ansid=79444 then '' when ansid=79445 then '' when ansid=79446 then '' when ansid=79447 then '' when ansid=79448 then '' when ansid=79449 then '' when ansid=79450 then '' when ansid=79451 then '' when ansid=79452 then '' when ansid=79453 then '' when ansid=79454 then '' when ansid=79455 then '' when ansid=79456 then '' when ansid=79457 then '' when ansid=79458 then '' when ansid=79459 then '' when ansid=79460 then '' when ansid=79461 then '' when ansid=79462 then '' when ansid=79463 then '' when ansid=79464 then '' when ansid=79465 then '' when ansid=79466 then '' when ansid=79467 then '' when ansid=79468 then '' when ansid=79469 then '' when ansid=79470 then '' when ansid=79471 then '' when ansid=79472 then '' when ansid=79473 then '' when ansid=79474 then '' when ansid=79475 then '' when ansid=79476 then '' when ansid=79477 then '' when ansid=79478 then '' when ansid=79479 then '' when ansid=79480 then '' when ansid=79481 then '' when ansid=79482 then '' when ansid=79483 then '' when ansid=79484 then '' when ansid=79485 then '' when ansid=79486 then '' when ansid=79487 then '' when ansid=79488 then '' when ansid=79489 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.165.188',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 21:39:45'\n\t\t\t\t\t\t\tWHERE ansid in ('79436','79437','79438','79439','79440','79441','79442','79443','79444','79445','79446','79447','79448','79449','79450','79451','79452','79453','79454','79455','79456','79457','79458','79459','79460','79461','79462','79463','79464','79465','79466','79467','79468','79469','79470','79471','79472','79473','79474','79475','79476','79477','79478','79479','79480','79481','79482','79483','79484','79485','79486','79487','79488','79489')"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE supvisstepid = '4853'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE visitfeedbackid = '3581'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE visitfeedbackid = '3582'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE visitfeedbackid = '3583'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE visitfeedbackid = '3584'"} {"userId":"243","date":"2021-01-21 21:39:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:39:45' WHERE visitfeedbackid = '3585'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE sitesupervision SET `siteid` = '1529', `userid` = '243', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-21', `numofsamplecollected` = '100', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '761'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE onssid = '3372'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE onssid = '3373'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE onssid = '3374'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE onssid = '3375'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=79436 then '1' when ansid=79437 then '1' when ansid=79438 then '1' when ansid=79439 then '10' when ansid=79440 then '10' when ansid=79441 then '1' when ansid=79442 then '1' when ansid=79443 then '1' when ansid=79444 then '1' when ansid=79445 then '1' when ansid=79446 then '1' when ansid=79447 then '1' when ansid=79448 then '1' when ansid=79449 then '1' when ansid=79450 then '1' when ansid=79451 then '1' when ansid=79452 then '' when ansid=79453 then '' when ansid=79454 then '' when ansid=79455 then '' when ansid=79456 then '' when ansid=79457 then '' when ansid=79458 then '' when ansid=79459 then '' when ansid=79460 then '' when ansid=79461 then '' when ansid=79462 then '' when ansid=79463 then '' when ansid=79464 then '' when ansid=79465 then '' when ansid=79466 then '' when ansid=79467 then '' when ansid=79468 then '' when ansid=79469 then '' when ansid=79470 then '' when ansid=79471 then '' when ansid=79472 then '' when ansid=79473 then '' when ansid=79474 then '' when ansid=79475 then '' when ansid=79476 then '' when ansid=79477 then '' when ansid=79478 then '' when ansid=79479 then '' when ansid=79480 then '' when ansid=79481 then '' when ansid=79482 then '' when ansid=79483 then '' when ansid=79484 then '' when ansid=79485 then '' when ansid=79486 then '' when ansid=79487 then '' when ansid=79488 then '' when ansid=79489 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '122.161.165.188',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-21 21:40:11'\n\t\t\t\t\t\t\tWHERE ansid in ('79436','79437','79438','79439','79440','79441','79442','79443','79444','79445','79446','79447','79448','79449','79450','79451','79452','79453','79454','79455','79456','79457','79458','79459','79460','79461','79462','79463','79464','79465','79466','79467','79468','79469','79470','79471','79472','79473','79474','79475','79476','79477','79478','79479','79480','79481','79482','79483','79484','79485','79486','79487','79488','79489')"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE supvisstepid = '4854'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE visitfeedbackid = '3581'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE visitfeedbackid = '3582'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE visitfeedbackid = '3583'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE visitfeedbackid = '3584'"} {"userId":"243","date":"2021-01-21 21:40:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '122.161.165.188', `modifiedby` = '243', `modifieddate` = '2021-01-21 21:40:11' WHERE visitfeedbackid = '3585'"} {"userId":"243","date":"2021-01-21 21:41:03","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('381', '2021-01-21', '243', '122.161.165.188', '243', '2021-01-21 21:41:03')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('381', '951', '243', '2021-01-21', '1', '122.161.165.188', '243', '2021-01-21 21:41:07', '', '')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('762', '0', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('762', '1', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('762', '2', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('762', '3', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('762', '4', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('762', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('762', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('762', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('762', '', '', 'Array', '', 'Array', '', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('762', '122.161.165.188', '243', '2021-01-21 21:41:07')"} {"userId":"243","date":"2021-01-21 21:41:07","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('762', '122.161.165.188', '243', '2021-01-21 21:41:07')"}