{"userId":"29","date":"2019-04-09 21:10:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('29', '223.230.149.110', '2019-04-09 21:10:18')"}
{"userId":"29","date":"2019-04-09 21:12:30","query":"UPDATE usermst SET `password` = 'b97d8e4b33d5a5ff13c54d01d8389877', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:12:30', `ipaddress` = '223.230.149.110' WHERE userid = '29'"}
{"userId":"29","date":"2019-04-09 21:27:48","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('362', '2019-04-08', '29', '223.230.149.110', '29', '2019-04-09 21:27:48')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('362', '905', '29', '2019-04-09', '1', '223.230.149.110', '29', '2019-04-09 21:27:57', '', '')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '0', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '1', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '2', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '3', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '4', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '5', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('723', '6', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('723', '', '', 'Array', '', 'Array', '', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('723', '', '', 'Array', '', 'Array', '', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('723', '', '', 'Array', '', 'Array', '', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('723', '', '', 'Array', '', 'Array', '', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:27:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:53","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:58","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:28:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:00","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:29:03","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('723', '223.230.149.110', '29', '2019-04-09 21:27:57')"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:32:52","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '' when ansid=75729 then '' when ansid=75730 then '' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then ''   when ansid=75734 then ''  when ansid=75735 then '' when ansid=75737 then '' when ansid=75739 then '' when ansid=75741 then '' when ansid=75743 then '' when ansid=75745 then '' when ansid=75747 then '' when ansid=75749 then '' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '' when ansid=75779 then '' when ansid=75781 then '' when ansid=75783 then '' when ansid=75785 then '' when ansid=75787 then '' when ansid=75788 then '' when ansid=75789 then '' when ansid=75790 then ''  when ansid=75791 then ''   when ansid=75792 then ''  when ansid=75793 then ''  when ansid=75794 then ''   when ansid=75795 then ''   when ansid=75796 then ''   when ansid=75797 then ''  when ansid=75798 then '' when ansid=75799 then '' when ansid=75800 then ''  when ansid=75801 then ''   when ansid=75802 then ''   when ansid=75803 then ''   when ansid=75804 then ''  when ansid=75805 then ''  when ansid=75806 then ''   when ansid=75807 then ''  when ansid=75808 then '' when ansid=75809 then '' when ansid=75810 then '' when ansid=75811 then '' when ansid=75812 then '' when ansid=75813 then '' when ansid=75814 then '' when ansid=75815 then '' when ansid=75816 then ''  when ansid=75817 then ''   when ansid=75818 then ''   when ansid=75819 then ''   when ansid=75820 then ''  when ansid=75821 then '' when ansid=75822 then ''  when ansid=75823 then ''   when ansid=75824 then ''  when ansid=75825 then '' when ansid=75826 then '' when ansid=75827 then '' when ansid=75828 then '' when ansid=75829 then '' when ansid=75830 then '' when ansid=75831 then '' when ansid=75832 then '' when ansid=75833 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:32:52'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE supvisstepid = '4637'"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:32:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:32:52' WHERE visitfeedbackid = '3395'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:34:31","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '2' when ansid=75729 then '1' when ansid=75730 then '1' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then '320'   when ansid=75734 then '1'  when ansid=75735 then '' when ansid=75737 then '' when ansid=75739 then '' when ansid=75741 then '' when ansid=75743 then '' when ansid=75745 then '' when ansid=75747 then '' when ansid=75749 then '' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '' when ansid=75779 then '' when ansid=75781 then '' when ansid=75783 then '' when ansid=75785 then '' when ansid=75787 then '' when ansid=75788 then '' when ansid=75789 then '' when ansid=75790 then ''  when ansid=75791 then ''   when ansid=75792 then ''  when ansid=75793 then ''  when ansid=75794 then ''   when ansid=75795 then ''   when ansid=75796 then ''   when ansid=75797 then ''  when ansid=75798 then '' when ansid=75799 then '' when ansid=75800 then ''  when ansid=75801 then ''   when ansid=75802 then ''   when ansid=75803 then ''   when ansid=75804 then ''  when ansid=75805 then ''  when ansid=75806 then ''   when ansid=75807 then ''  when ansid=75808 then '' when ansid=75809 then '' when ansid=75810 then '' when ansid=75811 then '' when ansid=75812 then '' when ansid=75813 then '' when ansid=75814 then '' when ansid=75815 then '' when ansid=75816 then ''  when ansid=75817 then ''   when ansid=75818 then ''   when ansid=75819 then ''   when ansid=75820 then ''  when ansid=75821 then '' when ansid=75822 then ''  when ansid=75823 then ''   when ansid=75824 then ''  when ansid=75825 then '' when ansid=75826 then '' when ansid=75827 then '' when ansid=75828 then '' when ansid=75829 then '' when ansid=75830 then '' when ansid=75831 then '' when ansid=75832 then '' when ansid=75833 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:34:31'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE supvisstepid = '4638'"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:34:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:34:31' WHERE visitfeedbackid = '3395'"}
{"userId":"29","date":"2019-04-09 21:36:07","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:36:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:08' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:36:08","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:08' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:36:08","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:08' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:36:08","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:08' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:36:08","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '2' when ansid=75729 then '1' when ansid=75730 then '1' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then '320'   when ansid=75734 then '1'  when ansid=75735 then '2' when ansid=75737 then '1' when ansid=75739 then '450' when ansid=75741 then '5' when ansid=75743 then '5' when ansid=75745 then '448' when ansid=75747 then '1' when ansid=75749 then '1' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '' when ansid=75779 then '' when ansid=75781 then '' when ansid=75783 then '' when ansid=75785 then '' when ansid=75787 then '' when ansid=75788 then '' when ansid=75789 then '' when ansid=75790 then ''  when ansid=75791 then ''   when ansid=75792 then ''  when ansid=75793 then ''  when ansid=75794 then ''   when ansid=75795 then ''   when ansid=75796 then ''   when ansid=75797 then ''  when ansid=75798 then '' when ansid=75799 then '' when ansid=75800 then ''  when ansid=75801 then ''   when ansid=75802 then ''   when ansid=75803 then ''   when ansid=75804 then ''  when ansid=75805 then ''  when ansid=75806 then ''   when ansid=75807 then ''  when ansid=75808 then '' when ansid=75809 then '' when ansid=75810 then '' when ansid=75811 then '' when ansid=75812 then '' when ansid=75813 then '' when ansid=75814 then '' when ansid=75815 then '' when ansid=75816 then ''  when ansid=75817 then ''   when ansid=75818 then ''   when ansid=75819 then ''   when ansid=75820 then ''  when ansid=75821 then '' when ansid=75822 then ''  when ansid=75823 then ''   when ansid=75824 then ''  when ansid=75825 then '' when ansid=75826 then '' when ansid=75827 then '' when ansid=75828 then '' when ansid=75829 then '' when ansid=75830 then '' when ansid=75831 then '' when ansid=75832 then '' when ansid=75833 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:36:07'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE supvisstepid = '4640'"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:36:09","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:07' WHERE visitfeedbackid = '3395'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:36:56","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '2' when ansid=75729 then '1' when ansid=75730 then '1' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then '320'   when ansid=75734 then '1'  when ansid=75735 then '2' when ansid=75737 then '1' when ansid=75739 then '450' when ansid=75741 then '5' when ansid=75743 then '5' when ansid=75745 then '448' when ansid=75747 then '1' when ansid=75749 then '1' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '1' when ansid=75779 then '0' when ansid=75781 then '0' when ansid=75783 then '0' when ansid=75785 then '1' when ansid=75787 then '' when ansid=75788 then '' when ansid=75789 then '' when ansid=75790 then ''  when ansid=75791 then ''   when ansid=75792 then ''  when ansid=75793 then ''  when ansid=75794 then ''   when ansid=75795 then ''   when ansid=75796 then ''   when ansid=75797 then ''  when ansid=75798 then '' when ansid=75799 then '' when ansid=75800 then ''  when ansid=75801 then ''   when ansid=75802 then ''   when ansid=75803 then ''   when ansid=75804 then ''  when ansid=75805 then ''  when ansid=75806 then ''   when ansid=75807 then ''  when ansid=75808 then '' when ansid=75809 then '' when ansid=75810 then '' when ansid=75811 then '' when ansid=75812 then '' when ansid=75813 then '' when ansid=75814 then '' when ansid=75815 then '' when ansid=75816 then ''  when ansid=75817 then ''   when ansid=75818 then ''   when ansid=75819 then ''   when ansid=75820 then ''  when ansid=75821 then '' when ansid=75822 then ''  when ansid=75823 then ''   when ansid=75824 then ''  when ansid=75825 then '' when ansid=75826 then '' when ansid=75827 then '' when ansid=75828 then '' when ansid=75829 then '' when ansid=75830 then '' when ansid=75831 then '' when ansid=75832 then '' when ansid=75833 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:36:56'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE supvisstepid = '4641'"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:36:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:36:56' WHERE visitfeedbackid = '3395'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '2' when ansid=75729 then '1' when ansid=75730 then '1' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then '320'   when ansid=75734 then '1'  when ansid=75735 then '2' when ansid=75737 then '1' when ansid=75739 then '450' when ansid=75741 then '5' when ansid=75743 then '5' when ansid=75745 then '448' when ansid=75747 then '1' when ansid=75749 then '1' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '1' when ansid=75779 then '0' when ansid=75781 then '0' when ansid=75783 then '0' when ansid=75785 then '1' when ansid=75787 then '5' when ansid=75788 then '5' when ansid=75789 then '1200' when ansid=75790 then '250'  when ansid=75791 then ''   when ansid=75792 then '1'  when ansid=75793 then '1'  when ansid=75794 then ''   when ansid=75795 then '1'   when ansid=75796 then ''   when ansid=75797 then '1'  when ansid=75798 then '7' when ansid=75799 then '1' when ansid=75800 then '1'  when ansid=75801 then 'counsellor'   when ansid=75802 then '1'   when ansid=75803 then ''   when ansid=75804 then '1'  when ansid=75805 then '1'  when ansid=75806 then ''   when ansid=75807 then '1'  when ansid=75808 then '4' when ansid=75809 then '2' when ansid=75810 then '1' when ansid=75811 then '2' when ansid=75812 then '1' when ansid=75813 then '2' when ansid=75814 then '1' when ansid=75815 then '1' when ansid=75816 then '1'  when ansid=75817 then 'once in 10 days'   when ansid=75818 then '5'   when ansid=75819 then 'thermocol box'   when ansid=75820 then '2'  when ansid=75821 then '1' when ansid=75822 then '2'  when ansid=75823 then ''   when ansid=75824 then '1'  when ansid=75825 then '2' when ansid=75826 then '1' when ansid=75827 then '3' when ansid=75828 then '2' when ansid=75829 then '0' when ansid=75830 then 'vaccine carrier no available,few data forms are not signed by the site in charge hence the lot is not sent to RI,data transportation sheet and sample transportation forms are not provided by the SACS,they are using photocopied version of the same' when ansid=75831 then 'none' when ansid=75832 then 'waste disposal is not satisfactory(no use of puncture proof container and sodium hypochlorite solution), the PPTCT and HSS sites are not in the same building as ANC clinic, the patients were pricked twice for taking blood samples, once at PPTCT\/HSS and other at general lab, the counsellor was on leave for two days hence slow progress, cryovials were covered completely by the stickers hence difficult to comment in the quality of serum samples' when ansid=75833 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:51:38'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE supvisstepid = '4642'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:51:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:51:38' WHERE visitfeedbackid = '3395'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE sitesupervision SET `siteid` = '362', `userid` = '29', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-19', `numofsamplecollected` = '57', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '723'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Rakesh kumar', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '1', `remarks` = 'years of experience not known', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE onssid = '3220'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE onsitestaffs SET `staffname` = 'REETA', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE onssid = '3221'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE onsitestaffs SET `staffname` = 'Madhubala', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '11', `istrained` = '1', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE onssid = '3222'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE onssid = '3223'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=75728 then '2' when ansid=75729 then '1' when ansid=75730 then '1' when ansid=75731 then '' when ansid=75732 then ''  when ansid=75733 then '320'   when ansid=75734 then '1'  when ansid=75735 then '2' when ansid=75737 then '1' when ansid=75739 then '450' when ansid=75741 then '5' when ansid=75743 then '5' when ansid=75745 then '448' when ansid=75747 then '1' when ansid=75749 then '1' when ansid=75751 then '' when ansid=75753 then '' when ansid=75755 then '' when ansid=75757 then '' when ansid=75759 then '' when ansid=75761 then '' when ansid=75763 then '' when ansid=75765 then '' when ansid=75767 then '' when ansid=75769 then '' when ansid=75771 then '' when ansid=75773 then '' when ansid=75775 then '' when ansid=75777 then '1' when ansid=75779 then '0' when ansid=75781 then '0' when ansid=75783 then '0' when ansid=75785 then '1' when ansid=75787 then '5' when ansid=75788 then '5' when ansid=75789 then '1200' when ansid=75790 then '250'  when ansid=75791 then ''   when ansid=75792 then '1'  when ansid=75793 then '1'  when ansid=75794 then ''   when ansid=75795 then '1'   when ansid=75796 then ''   when ansid=75797 then '1'  when ansid=75798 then '7' when ansid=75799 then '1' when ansid=75800 then '1'  when ansid=75801 then 'counsellor'   when ansid=75802 then '1'   when ansid=75803 then ''   when ansid=75804 then '1'  when ansid=75805 then '1'  when ansid=75806 then ''   when ansid=75807 then '1'  when ansid=75808 then '4' when ansid=75809 then '2' when ansid=75810 then '1' when ansid=75811 then '2' when ansid=75812 then '1' when ansid=75813 then '2' when ansid=75814 then '1' when ansid=75815 then '1' when ansid=75816 then '1'  when ansid=75817 then 'once in 10 days'   when ansid=75818 then '5'   when ansid=75819 then 'thermocol box'   when ansid=75820 then '2'  when ansid=75821 then '1' when ansid=75822 then '2'  when ansid=75823 then ''   when ansid=75824 then '1'  when ansid=75825 then '2' when ansid=75826 then '1' when ansid=75827 then '3' when ansid=75828 then '2' when ansid=75829 then '0' when ansid=75830 then 'vaccine carrier no available,few data forms are not signed by the site in charge hence the lot is not sent to RI,data transportation sheet and sample transportation forms are not provided by the SACS,they are using photocopied version of the same' when ansid=75831 then 'none' when ansid=75832 then 'waste disposal is not satisfactory(no use of puncture proof container and sodium hypochlorite solution), the PPTCT and HSS sites are not in the same building as ANC clinic, the patients were pricked twice for taking blood samples, once at PPTCT\/HSS and other at general lab, the counsellor was on leave for two days hence slow progress, cryovials were covered completely by the stickers hence difficult to comment in the quality of serum samples' when ansid=75833 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '223.230.149.110',\n\t\t\t\t\t\t\t\tmodifiedby =29,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-09 21:58:43'\n\t\t\t\t\t\t\tWHERE ansid in ('75728','75729','75730','75731','75732','75733','75734','75735','75737','75739','75741','75743','75745','75747','75749','75751','75753','75755','75757','75759','75761','75763','75765','75767','75769','75771','75773','75775','75777','75779','75781','75783','75785','75787','75788','75789','75790','75791','75792','75793','75794','75795','75796','75797','75798','75799','75800','75801','75802','75803','75804','75805','75806','75807','75808','75809','75810','75811','75812','75813','75814','75815','75816','75817','75818','75819','75820','75821','75822','75823','75824','75825','75826','75827','75828','75829','75830','75831','75832','75833')"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE supvisstepid = '4643'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE visitfeedback SET `feedback` = 'PPTCT\/HSS in other buliding (not near to ANC clinic)', `recommendation` = 'briefed the counsellor regarding the same', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE visitfeedbackid = '3391'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE visitfeedback SET `feedback` = 'cryovials were covered completely by the stickers and difficult to comment on quality of serum samples', `recommendation` = 'size of stickers should be smaller', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE visitfeedbackid = '3392'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE visitfeedback SET `feedback` = 'waste disposal is not being practiced as per guidelines', `recommendation` = 'instructed to adhere to the guidelines', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE visitfeedbackid = '3393'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE visitfeedback SET `feedback` = 'frequency of sample transportation to reference lab is less', `recommendation` = 'lab technician was instructed about the weekly transport of samples', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE visitfeedbackid = '3394'"}
{"userId":"29","date":"2019-04-09 21:58:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '223.230.149.110', `modifiedby` = '29', `modifieddate` = '2019-04-09 21:58:43' WHERE visitfeedbackid = '3395'"}