{"userId":"166","date":"2019-05-03 10:39:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('166', '192.168.100.115', '2019-05-03 10:39:33')"}
{"userId":"166","date":"2019-05-03 10:41:54","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1046', '2019-05-02', '166', '192.168.100.115', '166', '2019-05-03 10:41:54')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1046', '920', '166', '2019-05-03', '1', '192.168.100.115', '166', '2019-05-03 10:42:15', '', '')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '0', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '1', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '2', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '3', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '4', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('734', '5', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('734', '', '', 'Array', '', 'Array', '', '192.168.100.115', '166', '2019-05-03 10:42:16')"}
{"userId":"166","date":"2019-05-03 10:42:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('734', '', '', 'Array', '', 'Array', '', '192.168.100.115', '166', '2019-05-03 10:42:16')"}
{"userId":"166","date":"2019-05-03 10:42:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('734', '', '', 'Array', '', 'Array', '', '192.168.100.115', '166', '2019-05-03 10:42:17')"}
{"userId":"166","date":"2019-05-03 10:42:17","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('734', '', '', 'Array', '', 'Array', '', '192.168.100.115', '166', '2019-05-03 10:42:17')"}
{"userId":"166","date":"2019-05-03 10:42:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:25","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:36","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:44","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:42:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:03","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:10","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:43:21","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('734', '192.168.100.115', '166', '2019-05-03 10:42:15')"}
{"userId":"166","date":"2019-05-03 10:48:45","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 10:48:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:46' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 10:48:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:46' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 10:48:46","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:46' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 10:48:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:46' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 10:48:46","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '' when ansid=76872 then '' when ansid=76874 then '' when ansid=76876 then '' when ansid=76878 then '' when ansid=76880 then '' when ansid=76882 then '' when ansid=76884 then '' when ansid=76886 then '' when ansid=76888 then '' when ansid=76890 then '' when ansid=76892 then '' when ansid=76894 then '' when ansid=76896 then '' when ansid=76898 then '' when ansid=76900 then '' when ansid=76902 then '' when ansid=76904 then '' when ansid=76906 then '' when ansid=76908 then '' when ansid=76910 then '' when ansid=76912 then '' when ansid=76914 then '' when ansid=76916 then '' when ansid=76918 then '' when ansid=76920 then '' when ansid=76922 then '' when ansid=76924 then '' when ansid=76926 then '' when ansid=76927 then ''  when ansid=76928 then ''   when ansid=76929 then ''   when ansid=76930 then ''   when ansid=76931 then ''   when ansid=76932 then ''   when ansid=76933 then ''  when ansid=76934 then '' when ansid=76935 then ''  when ansid=76936 then ''   when ansid=76937 then ''   when ansid=76938 then ''   when ansid=76939 then ''  when ansid=76940 then '' when ansid=76941 then '' when ansid=76942 then '' when ansid=76943 then '' when ansid=76944 then '' when ansid=76945 then '' when ansid=76946 then '' when ansid=76947 then '' when ansid=76948 then '' when ansid=76949 then '' when ansid=76950 then '' when ansid=76951 then '' when ansid=76952 then '' when ansid=76953 then ''  when ansid=76954 then ''   when ansid=76955 then ''  when ansid=76956 then '' when ansid=76957 then '' when ansid=76958 then '' when ansid=76959 then '' when ansid=76960 then '' when ansid=76961 then '' when ansid=76962 then '' when ansid=76963 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 10:48:45'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE supvisstepid = '4700'"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 10:48:47","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:48:45' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 10:50:25","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '' when ansid=76892 then '' when ansid=76894 then '' when ansid=76896 then '' when ansid=76898 then '' when ansid=76900 then '' when ansid=76902 then '' when ansid=76904 then '' when ansid=76906 then '' when ansid=76908 then '' when ansid=76910 then '' when ansid=76912 then '' when ansid=76914 then '' when ansid=76916 then '' when ansid=76918 then '' when ansid=76920 then '' when ansid=76922 then '' when ansid=76924 then '' when ansid=76926 then '' when ansid=76927 then ''  when ansid=76928 then ''   when ansid=76929 then ''   when ansid=76930 then ''   when ansid=76931 then ''   when ansid=76932 then ''   when ansid=76933 then ''  when ansid=76934 then '' when ansid=76935 then ''  when ansid=76936 then ''   when ansid=76937 then ''   when ansid=76938 then ''   when ansid=76939 then ''  when ansid=76940 then '' when ansid=76941 then '' when ansid=76942 then '' when ansid=76943 then '' when ansid=76944 then '' when ansid=76945 then '' when ansid=76946 then '' when ansid=76947 then '' when ansid=76948 then '' when ansid=76949 then '' when ansid=76950 then '' when ansid=76951 then '' when ansid=76952 then '' when ansid=76953 then ''  when ansid=76954 then ''   when ansid=76955 then ''  when ansid=76956 then '' when ansid=76957 then '' when ansid=76958 then '' when ansid=76959 then '' when ansid=76960 then '' when ansid=76961 then '' when ansid=76962 then '' when ansid=76963 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 10:50:25'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE supvisstepid = '4701'"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 10:50:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:50:25' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 10:51:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '' when ansid=76918 then '' when ansid=76920 then '' when ansid=76922 then '' when ansid=76924 then '' when ansid=76926 then '' when ansid=76927 then ''  when ansid=76928 then ''   when ansid=76929 then ''   when ansid=76930 then ''   when ansid=76931 then ''   when ansid=76932 then ''   when ansid=76933 then ''  when ansid=76934 then '' when ansid=76935 then ''  when ansid=76936 then ''   when ansid=76937 then ''   when ansid=76938 then ''   when ansid=76939 then ''  when ansid=76940 then '' when ansid=76941 then '' when ansid=76942 then '' when ansid=76943 then '' when ansid=76944 then '' when ansid=76945 then '' when ansid=76946 then '' when ansid=76947 then '' when ansid=76948 then '' when ansid=76949 then '' when ansid=76950 then '' when ansid=76951 then '' when ansid=76952 then '' when ansid=76953 then ''  when ansid=76954 then ''   when ansid=76955 then ''  when ansid=76956 then '' when ansid=76957 then '' when ansid=76958 then '' when ansid=76959 then '' when ansid=76960 then '' when ansid=76961 then '' when ansid=76962 then '' when ansid=76963 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 10:51:34'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE supvisstepid = '4702'"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 10:51:35","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:51:34' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 10:52:28","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 10:52:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:29' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 10:52:29","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:29' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 10:52:29","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:29' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 10:52:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:29' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 10:52:29","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '' when ansid=76927 then ''  when ansid=76928 then ''   when ansid=76929 then ''   when ansid=76930 then ''   when ansid=76931 then ''   when ansid=76932 then ''   when ansid=76933 then ''  when ansid=76934 then '' when ansid=76935 then ''  when ansid=76936 then ''   when ansid=76937 then ''   when ansid=76938 then ''   when ansid=76939 then ''  when ansid=76940 then '' when ansid=76941 then '' when ansid=76942 then '' when ansid=76943 then '' when ansid=76944 then '' when ansid=76945 then '' when ansid=76946 then '' when ansid=76947 then '' when ansid=76948 then '' when ansid=76949 then '' when ansid=76950 then '' when ansid=76951 then '' when ansid=76952 then '' when ansid=76953 then ''  when ansid=76954 then ''   when ansid=76955 then ''  when ansid=76956 then '' when ansid=76957 then '' when ansid=76958 then '' when ansid=76959 then '' when ansid=76960 then '' when ansid=76961 then '' when ansid=76962 then '' when ansid=76963 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 10:52:28'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE supvisstepid = '4703'"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 10:52:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 10:52:28' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:08:05","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:08:06","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:06' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:08:06","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:06' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:08:06","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:06' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:08:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:06' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:08:06","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are a very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), a time-location cluster sampling approach is the most appropriate approach for them. These under trails needs to be listed and selected on every field day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:08:05'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE supvisstepid = '4704'"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:08:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:08:05' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:18:35","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:18:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:36' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:18:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:36' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:18:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:36' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:18:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:36' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:18:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are a very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), a time-location cluster sampling approach is the most appropriate approach for them. These under trails needs to be listed and selected on every field day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:18:35'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE supvisstepid = '4700'"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:18:37","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:35' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:18:48","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:18:50","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:50' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:18:50","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:50' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:18:50","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:50' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:18:50","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:50' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:18:50","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are a very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), a time-location cluster sampling approach is the most appropriate approach for them. These under trails needs to be listed and selected on every field day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:18:48'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE supvisstepid = '4701'"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:18:52","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:48' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:18:59","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are a very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), a time-location cluster sampling approach is the most appropriate approach for them. These under trails needs to be listed and selected on every field day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:18:59'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE supvisstepid = '4702'"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:19:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:18:59' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:19:09","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are a very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), a time-location cluster sampling approach is the most appropriate approach for them. These under trails needs to be listed and selected on every field day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:19:09'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE supvisstepid = '4703'"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:19:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:19:09' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:22:39","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), time-location cluster sampling approach is the most appropriate approach for them. These under trails need to be listed and selected on every fieldwork day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is absolutely fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:22:39'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE supvisstepid = '4704'"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:22:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:22:39' WHERE visitfeedbackid = '3450'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE sitesupervision SET `siteid` = '1046', `userid` = '166', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2019-02-22', `numofsamplecollected` = '175', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04', `locationtype` = '1', `establishmentyear` = '', `recruitmentdays` = '2', `prisontype` = '0', `prisontypetext` = '', `convictedprisoners` = '454', `undertrialprisoners` = '2106', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '734'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Prasanta Kr Ghosh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE onssid = '3264'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Munshi A Ali', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE onssid = '3265'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Suman M Chaudhury', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = 'new site', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE onssid = '3266'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE onssid = '3267'"}
{"userId":"166","date":"2019-05-03 11:23:04","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=76870 then '3' when ansid=76872 then '1' when ansid=76874 then '450' when ansid=76876 then '30' when ansid=76878 then '30' when ansid=76880 then '500' when ansid=76882 then '450' when ansid=76884 then '1' when ansid=76886 then '1' when ansid=76888 then '1' when ansid=76890 then '2' when ansid=76892 then '450' when ansid=76894 then '450' when ansid=76896 then '450' when ansid=76898 then '30' when ansid=76900 then '1' when ansid=76902 then '450' when ansid=76904 then '450' when ansid=76906 then '500' when ansid=76908 then '2' when ansid=76910 then '5' when ansid=76912 then '1' when ansid=76914 then '5' when ansid=76916 then '1' when ansid=76918 then '1' when ansid=76920 then '1' when ansid=76922 then '90' when ansid=76924 then '1' when ansid=76926 then '0' when ansid=76927 then '0'  when ansid=76928 then ''   when ansid=76929 then '1'   when ansid=76930 then ''   when ansid=76931 then '1'   when ansid=76932 then ''   when ansid=76933 then '1'  when ansid=76934 then '15' when ansid=76935 then '2'  when ansid=76936 then 'Counsellor'   when ansid=76937 then '1'   when ansid=76938 then ''   when ansid=76939 then '1'  when ansid=76940 then '1' when ansid=76941 then '1' when ansid=76942 then '1' when ansid=76943 then '1' when ansid=76944 then '1' when ansid=76945 then '1' when ansid=76946 then '2' when ansid=76947 then '2' when ansid=76948 then '1' when ansid=76949 then '1' when ansid=76950 then '3' when ansid=76951 then '1' when ansid=76952 then '1' when ansid=76953 then '1'  when ansid=76954 then ''   when ansid=76955 then '1'  when ansid=76956 then '1' when ansid=76957 then '1' when ansid=76958 then '1' when ansid=76959 then '1' when ansid=76960 then '0' when ansid=76961 then 'One key issue related to recruitment is non-availability of many selected under trials for the interview as they get released by the time they are being approached for the interview.  It is one of the main reasons for the slow progress of the fieldwork.' when ansid=76962 then 'RI visited the field few times in the past.' when ansid=76963 then 'One of the key observations is that the sampling approach, particularly for the under trials, needs to be modified in the next round of the surveillance. Since the under trials are very dynamic and mobile group (nearly 10% to 15% of them get changed everyday), time-location cluster sampling approach is the most appropriate approach for them. These under trails need to be listed and selected on every fieldwork day like we follow in the TLCS approach. Whereas, the conventional cluster sampling approach is absolutely fine for the convicts as they are mostly a stable and fixed group (it seems that only 10% might change over three months period). It is an excellent learning during this round of the surveillance.' end),\n\t\t\t\t\t\t\t\t ipaddress = '192.168.100.115',\n\t\t\t\t\t\t\t\tmodifiedby =166,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-05-03 11:23:04'\n\t\t\t\t\t\t\tWHERE ansid in ('76870','76872','76874','76876','76878','76880','76882','76884','76886','76888','76890','76892','76894','76896','76898','76900','76902','76904','76906','76908','76910','76912','76914','76916','76918','76920','76922','76924','76926','76927','76928','76929','76930','76931','76932','76933','76934','76935','76936','76937','76938','76939','76940','76941','76942','76943','76944','76945','76946','76947','76948','76949','76950','76951','76952','76953','76954','76955','76956','76957','76958','76959','76960','76961','76962','76963')"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE supvisstepid = '4705'"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE visitfeedback SET `feedback` = 'Non-availability of many selected under trials by the time they are being approached for the interview. It is forcing us to go for many replacements and also it is slowing down the on-going fieldwork.', `recommendation` = 'The convicts are a stable and fixed group over a period of time. However, the under trials are an extremely dynamic and mobile group. For example, according to the Prison Authority, nearly 10-15% of the under trials are changing every day.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE visitfeedbackid = '3446'"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'Continuation of Recommendation 1: Therefore, in the next round, we need to have a better sampling approach (TLCS approach), particuarly for covering the under trials. It is very important.', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE visitfeedbackid = '3447'"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE visitfeedbackid = '3448'"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE visitfeedbackid = '3449'"}
{"userId":"166","date":"2019-05-03 11:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.100.115', `modifiedby` = '166', `modifieddate` = '2019-05-03 11:23:04' WHERE visitfeedbackid = '3450'"}