{"userId":"601","date":"2023-02-12 18:38:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('601', '49.36.103.147', '2023-02-12 18:38:27')"} {"userId":"601","date":"2023-02-12 18:45:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('601', '49.36.103.147', '2023-02-12 18:45:09')"} {"userId":"647","date":"2023-02-12 21:04:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('647', '103.95.82.173', '2023-02-12 21:04:29')"} {"userId":"647","date":"2023-02-12 21:07:56","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1831', '2023-02-10', '647', '103.95.82.173', '647', '2023-02-12 21:07:56')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1831', '3254', '647', '2023-02-12', '1', '103.95.82.173', '647', '2023-02-12 21:08:04', '', '')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2787', '0', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2787', '1', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2787', '2', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2787', '3', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2787', '4', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2787', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2787', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2787', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2787', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:08:04","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2787', '103.95.82.173', '647', '2023-02-12 21:08:04')"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE sitesupervision SET `siteid` = '1831', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2787'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Anil Kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE onssid = '11476'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE onsitestaffs SET `staffname` = 'Indumati', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE onssid = '11477'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE onsitestaffs SET `staffname` = 'Appa Rao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE onssid = '11478'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE onssid = '11479'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263761 then '' when ansid=263762 then '' when ansid=263763 then '' when ansid=263764 then '' when ansid=263765 then '' when ansid=263766 then '' when ansid=263767 then '' when ansid=263867 then '' when ansid=263868 then '' when ansid=263810 then '' when ansid=263812 then '' when ansid=263814 then '' when ansid=263816 then '' when ansid=263818 then '' when ansid=263820 then '' when ansid=263821 then '' when ansid=263822 then '' when ansid=263823 then '' when ansid=263824 then '' when ansid=263825 then '' when ansid=263826 then '' when ansid=263827 then '' when ansid=263828 then '' when ansid=263829 then '' when ansid=263830 then '' when ansid=263831 then '' when ansid=263832 then '' when ansid=263833 then '' when ansid=263834 then '' when ansid=263835 then '' when ansid=263836 then '' when ansid=263837 then '' when ansid=263838 then '' when ansid=263839 then '' when ansid=263840 then '' when ansid=263841 then '' when ansid=263842 then '' when ansid=263843 then '' when ansid=263844 then '' when ansid=263845 then '' when ansid=263846 then '' when ansid=263847 then '' when ansid=263848 then '' when ansid=263849 then '' when ansid=263850 then '' when ansid=263851 then '' when ansid=263852 then '' when ansid=263853 then '' when ansid=263854 then '' when ansid=263855 then '' when ansid=263856 then '' when ansid=263857 then '' when ansid=263858 then '' when ansid=263859 then '' when ansid=263860 then '' when ansid=263861 then '' when ansid=263862 then '' when ansid=263863 then '' when ansid=263864 then '' when ansid=263865 then '' when ansid=263866 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 21:11:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263761','263762','263763','263764','263765','263766','263767','263867','263868','263810','263812','263814','263816','263818','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263839','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866')"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE supvisstepid = '13741'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE visitfeedbackid = '13711'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE visitfeedbackid = '13712'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE visitfeedbackid = '13713'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE visitfeedbackid = '13714'"} {"userId":"647","date":"2023-02-12 21:11:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:11:20' WHERE visitfeedbackid = '13715'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE sitesupervision SET `siteid` = '1831', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2787'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Anil Kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE onssid = '11476'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE onsitestaffs SET `staffname` = 'Indumati', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE onssid = '11477'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE onsitestaffs SET `staffname` = 'Appa Rao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE onssid = '11478'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE onssid = '11479'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263761 then '1' when ansid=263762 then '1' when ansid=263763 then '1' when ansid=263764 then '' when ansid=263765 then '' when ansid=263766 then '' when ansid=263767 then '2' when ansid=263867 then '1' when ansid=263868 then '1' when ansid=263810 then '' when ansid=263812 then '' when ansid=263814 then '' when ansid=263816 then '' when ansid=263818 then '' when ansid=263820 then '' when ansid=263821 then '' when ansid=263822 then '' when ansid=263823 then '' when ansid=263824 then '' when ansid=263825 then '' when ansid=263826 then '' when ansid=263827 then '' when ansid=263828 then '' when ansid=263829 then '' when ansid=263830 then '' when ansid=263831 then '' when ansid=263832 then '' when ansid=263833 then '' when ansid=263834 then '' when ansid=263835 then '' when ansid=263836 then '' when ansid=263837 then '' when ansid=263838 then '' when ansid=263839 then '' when ansid=263840 then '' when ansid=263841 then '' when ansid=263842 then '' when ansid=263843 then '' when ansid=263844 then '' when ansid=263845 then '' when ansid=263846 then '' when ansid=263847 then '' when ansid=263848 then '' when ansid=263849 then '' when ansid=263850 then '' when ansid=263851 then '' when ansid=263852 then '' when ansid=263853 then '' when ansid=263854 then '' when ansid=263855 then '' when ansid=263856 then '' when ansid=263857 then '' when ansid=263858 then '' when ansid=263859 then '' when ansid=263860 then '' when ansid=263861 then '' when ansid=263862 then '' when ansid=263863 then '' when ansid=263864 then '' when ansid=263865 then '' when ansid=263866 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 21:12:07'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263761','263762','263763','263764','263765','263766','263767','263867','263868','263810','263812','263814','263816','263818','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263839','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866')"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE supvisstepid = '13742'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE visitfeedbackid = '13711'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE visitfeedbackid = '13712'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE visitfeedbackid = '13713'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE visitfeedbackid = '13714'"} {"userId":"647","date":"2023-02-12 21:12:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:12:07' WHERE visitfeedbackid = '13715'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE sitesupervision SET `siteid` = '1831', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2787'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Anil Kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE onssid = '11476'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE onsitestaffs SET `staffname` = 'Indumati', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE onssid = '11477'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE onsitestaffs SET `staffname` = 'Appa Rao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE onssid = '11478'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE onssid = '11479'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263761 then '1' when ansid=263762 then '1' when ansid=263763 then '1' when ansid=263764 then '' when ansid=263765 then '' when ansid=263766 then '' when ansid=263767 then '2' when ansid=263867 then '1' when ansid=263868 then '1' when ansid=263810 then '1' when ansid=263812 then '1' when ansid=263814 then '0' when ansid=263816 then '0' when ansid=263818 then '1' when ansid=263820 then '' when ansid=263821 then '' when ansid=263822 then '' when ansid=263823 then '' when ansid=263824 then '' when ansid=263825 then '' when ansid=263826 then '' when ansid=263827 then '' when ansid=263828 then '' when ansid=263829 then '' when ansid=263830 then '' when ansid=263831 then '' when ansid=263832 then '' when ansid=263833 then '' when ansid=263834 then '' when ansid=263835 then '' when ansid=263836 then '' when ansid=263837 then '' when ansid=263838 then '' when ansid=263839 then '' when ansid=263840 then '' when ansid=263841 then '' when ansid=263842 then '' when ansid=263843 then '' when ansid=263844 then '' when ansid=263845 then '' when ansid=263846 then '' when ansid=263847 then '' when ansid=263848 then '' when ansid=263849 then '' when ansid=263850 then '' when ansid=263851 then '' when ansid=263852 then '' when ansid=263853 then '' when ansid=263854 then '' when ansid=263855 then '' when ansid=263856 then '' when ansid=263857 then '' when ansid=263858 then '' when ansid=263859 then '' when ansid=263860 then '' when ansid=263861 then '' when ansid=263862 then '' when ansid=263863 then '' when ansid=263864 then '' when ansid=263865 then '' when ansid=263866 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 21:13:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263761','263762','263763','263764','263765','263766','263767','263867','263868','263810','263812','263814','263816','263818','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263839','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866')"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE supvisstepid = '13743'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE visitfeedbackid = '13711'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE visitfeedbackid = '13712'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE visitfeedbackid = '13713'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE visitfeedbackid = '13714'"} {"userId":"647","date":"2023-02-12 21:13:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:13:04' WHERE visitfeedbackid = '13715'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE sitesupervision SET `siteid` = '1831', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2787'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Anil Kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE onssid = '11476'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE onsitestaffs SET `staffname` = 'Indumati', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE onssid = '11477'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE onsitestaffs SET `staffname` = 'Appa Rao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE onssid = '11478'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE onssid = '11479'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263761 then '1' when ansid=263762 then '1' when ansid=263763 then '1' when ansid=263764 then '' when ansid=263765 then '' when ansid=263766 then '' when ansid=263767 then '2' when ansid=263867 then '1' when ansid=263868 then '1' when ansid=263810 then '1' when ansid=263812 then '1' when ansid=263814 then '0' when ansid=263816 then '0' when ansid=263818 then '1' when ansid=263820 then '8' when ansid=263821 then '0' when ansid=263822 then '30' when ansid=263823 then '15' when ansid=263824 then '' when ansid=263825 then '1' when ansid=263826 then '2' when ansid=263827 then '' when ansid=263828 then '1' when ansid=263829 then '' when ansid=263830 then '1' when ansid=263831 then '01' when ansid=263832 then '3' when ansid=263833 then '1' when ansid=263834 then 'Counselor' when ansid=263835 then '1' when ansid=263836 then 'Skip patterns not followed' when ansid=263837 then '2' when ansid=263838 then '1' when ansid=263839 then 'Although it is maintainned, ANC registration numbers are repeated between the dates' when ansid=263840 then '2' when ansid=263841 then '2' when ansid=263842 then '1' when ansid=263843 then '1' when ansid=263844 then '1' when ansid=263845 then '1' when ansid=263846 then '2' when ansid=263847 then '1' when ansid=263848 then '1' when ansid=263849 then '1' when ansid=263850 then '' when ansid=263851 then '3' when ansid=263852 then '' when ansid=263853 then '1' when ansid=263854 then '1' when ansid=263855 then '1' when ansid=263856 then '' when ansid=263857 then '1' when ansid=263858 then '1' when ansid=263859 then '1' when ansid=263860 then '3' when ansid=263861 then '1' when ansid=263862 then '0' when ansid=263863 then 'NO' when ansid=263864 then 'on 6th Jan 2023, KD Samant RI visited, on 23th Jan 2023 V.Virabhadra Rao visited, Dr. Y. Padmasri SST visited and remarked that blood samples are drawn but data forms are not completed ,advised to complete. on 4thFebruary Dr. Rajendra Prasad, AP SACS visited the facility' when ansid=263865 then 'The facility cannot complete the day wise target to achieve the sample size. The facility is not screening the ANC attendees properly. Facility is excluding eligible ANC and only including those who are coming for the first time to the facility.' when ansid=263866 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 21:42:08'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263761','263762','263763','263764','263765','263766','263767','263867','263868','263810','263812','263814','263816','263818','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263839','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866')"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE supvisstepid = '13744'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE visitfeedbackid = '13711'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE visitfeedbackid = '13712'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE visitfeedbackid = '13713'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE visitfeedbackid = '13714'"} {"userId":"647","date":"2023-02-12 21:42:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:42:08' WHERE visitfeedbackid = '13715'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE sitesupervision SET `siteid` = '1831', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '28.5278208', `endlongitude` = '77.2112384' WHERE ssid = '2787'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Anil Kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE onssid = '11476'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE onsitestaffs SET `staffname` = 'Indumati', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE onssid = '11477'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE onsitestaffs SET `staffname` = 'Appa Rao', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE onssid = '11478'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE onssid = '11479'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263761 then '1' when ansid=263762 then '1' when ansid=263763 then '1' when ansid=263764 then '' when ansid=263765 then '' when ansid=263766 then '' when ansid=263767 then '2' when ansid=263867 then '1' when ansid=263868 then '1' when ansid=263810 then '1' when ansid=263812 then '1' when ansid=263814 then '0' when ansid=263816 then '0' when ansid=263818 then '1' when ansid=263820 then '8' when ansid=263821 then '0' when ansid=263822 then '30' when ansid=263823 then '15' when ansid=263824 then '' when ansid=263825 then '1' when ansid=263826 then '2' when ansid=263827 then '' when ansid=263828 then '1' when ansid=263829 then '' when ansid=263830 then '1' when ansid=263831 then '01' when ansid=263832 then '3' when ansid=263833 then '1' when ansid=263834 then 'Counselor' when ansid=263835 then '1' when ansid=263836 then 'Skip patterns not followed' when ansid=263837 then '2' when ansid=263838 then '1' when ansid=263839 then 'Although it is maintainned, ANC registration numbers are repeated between the dates' when ansid=263840 then '2' when ansid=263841 then '2' when ansid=263842 then '1' when ansid=263843 then '1' when ansid=263844 then '1' when ansid=263845 then '1' when ansid=263846 then '2' when ansid=263847 then '1' when ansid=263848 then '1' when ansid=263849 then '1' when ansid=263850 then '' when ansid=263851 then '3' when ansid=263852 then '' when ansid=263853 then '1' when ansid=263854 then '1' when ansid=263855 then '1' when ansid=263856 then '' when ansid=263857 then '1' when ansid=263858 then '1' when ansid=263859 then '1' when ansid=263860 then '3' when ansid=263861 then '1' when ansid=263862 then '0' when ansid=263863 then 'NO' when ansid=263864 then 'on 6th Jan 2023, KD Samant RI visited, on 23th Jan 2023 V.Virabhadra Rao visited, Dr. Y. Padmasri SST visited and remarked that blood samples are drawn but data forms are not completed ,advised to complete. on 4thFebruary Dr. Rajendra Prasad, AP SACS visited the facility' when ansid=263865 then 'The facility cannot complete the day wise target to achieve the sample size. The facility is not screening the ANC attendees properly. Facility is excluding eligible ANC and only including those who are coming for the first time to the facility.' when ansid=263866 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 21:54:45'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263761','263762','263763','263764','263765','263766','263767','263867','263868','263810','263812','263814','263816','263818','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263839','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866')"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE supvisstepid = '13745'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE visitfeedback SET `feedback` = 'Many ANC Attendees are excluded from HSS although many of them are eligible', `recommendation` = 'Advised- to meet the target by using inclusion criteria for ANC attendees', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE visitfeedbackid = '13711'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE visitfeedback SET `feedback` = 'Data forms filled, many inconsistency observed, skipping pattern not followed', `recommendation` = 'Showed the mistakes in the data form and asked to fill correctly', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE visitfeedbackid = '13712'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE visitfeedback SET `feedback` = 'ANC registration is not continuous over the period, Everyday the registration starts from 1. hence, the same number repeated between the dates', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE visitfeedbackid = '13713'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE visitfeedbackid = '13714'"} {"userId":"647","date":"2023-02-12 21:54:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 21:54:45' WHERE visitfeedbackid = '13715'"} {"userId":"647","date":"2023-02-12 21:57:07","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1832', '2023-02-10', '647', '103.95.82.173', '647', '2023-02-12 21:57:07')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1832', '3255', '647', '2023-02-12', '1', '103.95.82.173', '647', '2023-02-12 21:57:24', '', '')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2788', '0', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2788', '1', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2788', '2', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2788', '3', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2788', '4', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2788', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2788', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2788', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2788', '', '', 'Array', '', 'Array', '', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 21:57:24","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2788', '103.95.82.173', '647', '2023-02-12 21:57:24')"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE sitesupervision SET `siteid` = '1832', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '120', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2788'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Supriya', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE onssid = '11480'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE onsitestaffs SET `staffname` = 'Gopinath', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE onssid = '11481'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE onsitestaffs SET `staffname` = 'Chandrabela', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE onssid = '11482'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE onssid = '11483'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263869 then '' when ansid=263870 then '' when ansid=263871 then '' when ansid=263872 then '' when ansid=263873 then '' when ansid=263874 then '' when ansid=263875 then '' when ansid=263975 then '' when ansid=263976 then '' when ansid=263918 then '' when ansid=263920 then '' when ansid=263922 then '' when ansid=263924 then '' when ansid=263926 then '' when ansid=263928 then '' when ansid=263929 then '' when ansid=263930 then '' when ansid=263931 then '' when ansid=263932 then '' when ansid=263933 then '' when ansid=263934 then '' when ansid=263935 then '' when ansid=263936 then '' when ansid=263937 then '' when ansid=263938 then '' when ansid=263939 then '' when ansid=263940 then '' when ansid=263941 then '' when ansid=263942 then '' when ansid=263943 then '' when ansid=263944 then '' when ansid=263945 then '' when ansid=263946 then '' when ansid=263947 then '' when ansid=263948 then '' when ansid=263949 then '' when ansid=263950 then '' when ansid=263951 then '' when ansid=263952 then '' when ansid=263953 then '' when ansid=263954 then '' when ansid=263955 then '' when ansid=263956 then '' when ansid=263957 then '' when ansid=263958 then '' when ansid=263959 then '' when ansid=263960 then '' when ansid=263961 then '' when ansid=263962 then '' when ansid=263963 then '' when ansid=263964 then '' when ansid=263965 then '' when ansid=263966 then '' when ansid=263967 then '' when ansid=263968 then '' when ansid=263969 then '' when ansid=263970 then '' when ansid=263971 then '' when ansid=263972 then '' when ansid=263973 then '' when ansid=263974 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 22:00:45'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263869','263870','263871','263872','263873','263874','263875','263975','263976','263918','263920','263922','263924','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974')"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE supvisstepid = '13746'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE visitfeedbackid = '13716'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE visitfeedbackid = '13717'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE visitfeedbackid = '13718'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE visitfeedbackid = '13719'"} {"userId":"647","date":"2023-02-12 22:00:45","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:00:45' WHERE visitfeedbackid = '13720'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE sitesupervision SET `siteid` = '1832', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '120', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2788'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Supriya', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE onssid = '11480'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE onsitestaffs SET `staffname` = 'Gopinath', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE onssid = '11481'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE onsitestaffs SET `staffname` = 'Chandrabela', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE onssid = '11482'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE onssid = '11483'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263869 then '1' when ansid=263870 then '1' when ansid=263871 then '1' when ansid=263872 then '' when ansid=263873 then '' when ansid=263874 then '' when ansid=263875 then '2' when ansid=263975 then '1' when ansid=263976 then '1' when ansid=263918 then '' when ansid=263920 then '' when ansid=263922 then '' when ansid=263924 then '' when ansid=263926 then '' when ansid=263928 then '' when ansid=263929 then '' when ansid=263930 then '' when ansid=263931 then '' when ansid=263932 then '' when ansid=263933 then '' when ansid=263934 then '' when ansid=263935 then '' when ansid=263936 then '' when ansid=263937 then '' when ansid=263938 then '' when ansid=263939 then '' when ansid=263940 then '' when ansid=263941 then '' when ansid=263942 then '' when ansid=263943 then '' when ansid=263944 then '' when ansid=263945 then '' when ansid=263946 then '' when ansid=263947 then '' when ansid=263948 then '' when ansid=263949 then '' when ansid=263950 then '' when ansid=263951 then '' when ansid=263952 then '' when ansid=263953 then '' when ansid=263954 then '' when ansid=263955 then '' when ansid=263956 then '' when ansid=263957 then '' when ansid=263958 then '' when ansid=263959 then '' when ansid=263960 then '' when ansid=263961 then '' when ansid=263962 then '' when ansid=263963 then '' when ansid=263964 then '' when ansid=263965 then '' when ansid=263966 then '' when ansid=263967 then '' when ansid=263968 then '' when ansid=263969 then '' when ansid=263970 then '' when ansid=263971 then '' when ansid=263972 then '' when ansid=263973 then '' when ansid=263974 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 22:01:37'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263869','263870','263871','263872','263873','263874','263875','263975','263976','263918','263920','263922','263924','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974')"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE supvisstepid = '13747'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE visitfeedbackid = '13716'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE visitfeedbackid = '13717'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE visitfeedbackid = '13718'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE visitfeedbackid = '13719'"} {"userId":"647","date":"2023-02-12 22:01:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:01:37' WHERE visitfeedbackid = '13720'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE sitesupervision SET `siteid` = '1832', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '120', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2788'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Supriya', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE onssid = '11480'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE onsitestaffs SET `staffname` = 'Gopinath', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE onssid = '11481'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE onsitestaffs SET `staffname` = 'Chandrabela', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE onssid = '11482'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE onssid = '11483'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263869 then '1' when ansid=263870 then '1' when ansid=263871 then '1' when ansid=263872 then '' when ansid=263873 then '' when ansid=263874 then '' when ansid=263875 then '2' when ansid=263975 then '1' when ansid=263976 then '1' when ansid=263918 then '1' when ansid=263920 then '1' when ansid=263922 then '0' when ansid=263924 then '80' when ansid=263926 then '1' when ansid=263928 then '' when ansid=263929 then '' when ansid=263930 then '' when ansid=263931 then '' when ansid=263932 then '' when ansid=263933 then '' when ansid=263934 then '' when ansid=263935 then '' when ansid=263936 then '' when ansid=263937 then '' when ansid=263938 then '' when ansid=263939 then '' when ansid=263940 then '' when ansid=263941 then '' when ansid=263942 then '' when ansid=263943 then '' when ansid=263944 then '' when ansid=263945 then '' when ansid=263946 then '' when ansid=263947 then '' when ansid=263948 then '' when ansid=263949 then '' when ansid=263950 then '' when ansid=263951 then '' when ansid=263952 then '' when ansid=263953 then '' when ansid=263954 then '' when ansid=263955 then '' when ansid=263956 then '' when ansid=263957 then '' when ansid=263958 then '' when ansid=263959 then '' when ansid=263960 then '' when ansid=263961 then '' when ansid=263962 then '' when ansid=263963 then '' when ansid=263964 then '' when ansid=263965 then '' when ansid=263966 then '' when ansid=263967 then '' when ansid=263968 then '' when ansid=263969 then '' when ansid=263970 then '' when ansid=263971 then '' when ansid=263972 then '' when ansid=263973 then '' when ansid=263974 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 22:02:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263869','263870','263871','263872','263873','263874','263875','263975','263976','263918','263920','263922','263924','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974')"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE supvisstepid = '13748'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE visitfeedbackid = '13716'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE visitfeedbackid = '13717'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE visitfeedbackid = '13718'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE visitfeedbackid = '13719'"} {"userId":"647","date":"2023-02-12 22:02:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:02:04' WHERE visitfeedbackid = '13720'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE sitesupervision SET `siteid` = '1832', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '120', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2788'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Supriya', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE onssid = '11480'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE onsitestaffs SET `staffname` = 'Gopinath', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE onssid = '11481'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE onsitestaffs SET `staffname` = 'Chandrabela', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE onssid = '11482'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE onssid = '11483'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263869 then '1' when ansid=263870 then '1' when ansid=263871 then '1' when ansid=263872 then '' when ansid=263873 then '' when ansid=263874 then '' when ansid=263875 then '2' when ansid=263975 then '1' when ansid=263976 then '1' when ansid=263918 then '1' when ansid=263920 then '1' when ansid=263922 then '0' when ansid=263924 then '80' when ansid=263926 then '1' when ansid=263928 then '19' when ansid=263929 then '0' when ansid=263930 then '120' when ansid=263931 then '14' when ansid=263932 then '' when ansid=263933 then '1' when ansid=263934 then '1' when ansid=263935 then '' when ansid=263936 then '1' when ansid=263937 then '' when ansid=263938 then '1' when ansid=263939 then '4' when ansid=263940 then '3' when ansid=263941 then '1' when ansid=263942 then 'Counselor' when ansid=263943 then '1' when ansid=263944 then 'Skip patterns not followed, and many forms were not complete' when ansid=263945 then '2' when ansid=263946 then '1' when ansid=263947 then '' when ansid=263948 then '1' when ansid=263949 then '2' when ansid=263950 then '1' when ansid=263951 then '1' when ansid=263952 then '1' when ansid=263953 then '1' when ansid=263954 then '2' when ansid=263955 then '1' when ansid=263956 then '1' when ansid=263957 then '2' when ansid=263958 then 'there was time lag of 18 days. now once in a week' when ansid=263959 then '5' when ansid=263960 then '' when ansid=263961 then '1' when ansid=263962 then '1' when ansid=263963 then '1' when ansid=263964 then '' when ansid=263965 then '1' when ansid=263966 then '1' when ansid=263967 then '1' when ansid=263968 then '2' when ansid=263969 then '1' when ansid=263970 then '0' when ansid=263971 then 'NO' when ansid=263972 then 'On 6th Jan K.D. Samant visited the facility and on 31st Jan SST Dr. Y. Padmasri visited and given in her remark that the samples were not transported since 12\/1\/2023 (18 days)' when ansid=263973 then 'Data forms were not completely filled up and skip patterns not followed. Serum samples were not kept in the desired box' when ansid=263974 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 22:26:16'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263869','263870','263871','263872','263873','263874','263875','263975','263976','263918','263920','263922','263924','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974')"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE supvisstepid = '13749'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE visitfeedbackid = '13716'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE visitfeedbackid = '13717'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE visitfeedbackid = '13718'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE visitfeedbackid = '13719'"} {"userId":"647","date":"2023-02-12 22:26:16","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:26:16' WHERE visitfeedbackid = '13720'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE sitesupervision SET `siteid` = '1832', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '120', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '28.5278208', `endlongitude` = '77.2112384' WHERE ssid = '2788'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Supriya', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE onssid = '11480'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE onsitestaffs SET `staffname` = 'Gopinath', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE onssid = '11481'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE onsitestaffs SET `staffname` = 'Chandrabela', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE onssid = '11482'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE onssid = '11483'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263869 then '1' when ansid=263870 then '1' when ansid=263871 then '1' when ansid=263872 then '' when ansid=263873 then '' when ansid=263874 then '' when ansid=263875 then '2' when ansid=263975 then '1' when ansid=263976 then '1' when ansid=263918 then '1' when ansid=263920 then '1' when ansid=263922 then '0' when ansid=263924 then '80' when ansid=263926 then '1' when ansid=263928 then '19' when ansid=263929 then '0' when ansid=263930 then '120' when ansid=263931 then '14' when ansid=263932 then '' when ansid=263933 then '1' when ansid=263934 then '1' when ansid=263935 then '' when ansid=263936 then '1' when ansid=263937 then '' when ansid=263938 then '1' when ansid=263939 then '4' when ansid=263940 then '3' when ansid=263941 then '1' when ansid=263942 then 'Counselor' when ansid=263943 then '1' when ansid=263944 then 'Skip patterns not followed, and many forms were not complete' when ansid=263945 then '2' when ansid=263946 then '1' when ansid=263947 then '' when ansid=263948 then '1' when ansid=263949 then '2' when ansid=263950 then '1' when ansid=263951 then '1' when ansid=263952 then '1' when ansid=263953 then '1' when ansid=263954 then '2' when ansid=263955 then '1' when ansid=263956 then '1' when ansid=263957 then '2' when ansid=263958 then 'there was time lag of 18 days. now once in a week' when ansid=263959 then '5' when ansid=263960 then '' when ansid=263961 then '1' when ansid=263962 then '1' when ansid=263963 then '1' when ansid=263964 then '' when ansid=263965 then '1' when ansid=263966 then '1' when ansid=263967 then '1' when ansid=263968 then '2' when ansid=263969 then '1' when ansid=263970 then '0' when ansid=263971 then 'NO' when ansid=263972 then 'On 6th Jan K.D. Samant visited the facility and on 31st Jan SST Dr. Y. Padmasri visited and given in her remark that the samples were not transported since 12\/1\/2023 (18 days)' when ansid=263973 then 'Data forms were not completely filled up and skip patterns not followed. Serum samples were not kept in the desired box' when ansid=263974 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.95.82.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-12 22:30:23'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263869','263870','263871','263872','263873','263874','263875','263975','263976','263918','263920','263922','263924','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974')"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE supvisstepid = '13750'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE visitfeedback SET `feedback` = 'Data forms are not complete and inconsistent', `recommendation` = 'Pointed out the mistakes made by counselor and asked her to correctly filled up', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE visitfeedbackid = '13716'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE visitfeedback SET `feedback` = 'Serum sample were not kept in desired box', `recommendation` = 'Advised Lab technician to keep sample in the desired box to avoid contamination', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE visitfeedbackid = '13717'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE visitfeedbackid = '13718'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE visitfeedbackid = '13719'"} {"userId":"647","date":"2023-02-12 22:30:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.95.82.173', `modifiedby` = '647', `modifieddate` = '2023-02-12 22:30:23' WHERE visitfeedbackid = '13720'"}