{"userId":"544","date":"2023-02-02 09:34:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2023-02-02 09:34:54')"}
{"userId":"574","date":"2023-02-02 09:49:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.12', '2023-02-02 09:49:02')"}
{"userId":"541","date":"2023-02-02 09:53:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('541', '14.139.206.130', '2023-02-02 09:53:54')"}
{"userId":"574","date":"2023-02-02 09:56:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.12', '2023-02-02 09:56:05')"}
{"userId":"543","date":"2023-02-02 10:10:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '14.139.206.130', '2023-02-02 10:10:28')"}
{"userId":"542","date":"2023-02-02 10:10:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('542', '14.139.206.130', '2023-02-02 10:10:38')"}
{"userId":"574","date":"2023-02-02 10:16:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.12', '2023-02-02 10:16:37')"}
{"userId":"544","date":"2023-02-02 10:17:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '223.187.204.6', '2023-02-02 10:17:12')"}
{"userId":"664","date":"2023-02-02 11:06:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('664', '110.235.232.12', '2023-02-02 11:06:23')"}
{"userId":"574","date":"2023-02-02 12:26:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.12', '2023-02-02 12:26:30')"}
{"userId":"544","date":"2023-02-02 13:03:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2023-02-02 13:03:04')"}
{"userId":"575","date":"2023-02-02 13:58:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.12', '2023-02-02 13:58:44')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('358', '3199', '575', '2023-02-02', '1', '110.235.232.12', '575', '2023-02-02 14:07:35', '', '')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2753', '0', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2753', '1', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2753', '2', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2753', '3', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2753', '4', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2753', '', '', 'Array', '', 'Array', '', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2753', '', '', 'Array', '', 'Array', '', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2753', '', '', 'Array', '', 'Array', '', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2753', '', '', 'Array', '', 'Array', '', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"575","date":"2023-02-02 14:07:35","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2753', '110.235.232.12', '575', '2023-02-02 14:07:35')"}
{"userId":"7","date":"2023-02-02 14:18:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-02-02 14:18:04')"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE sitesupervision SET `siteid` = '358', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '198', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2753'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Abha Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Dr Sonalika attended the training', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE onssid = '11340'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Mala', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE onssid = '11341'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Raj Kishor', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE onssid = '11342'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE onssid = '11343'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260148 then '' when ansid=260149 then '' when ansid=260150 then '' when ansid=260151 then '' when ansid=260152 then ''  when ansid=260153 then ''   when ansid=260154 then ''  when ansid=260254 then '' when ansid=260255 then '' when ansid=260197 then '' when ansid=260199 then '' when ansid=260201 then '' when ansid=260203 then '' when ansid=260205 then '' when ansid=260207 then '' when ansid=260208 then '' when ansid=260209 then '' when ansid=260210 then ''  when ansid=260211 then ''   when ansid=260212 then ''  when ansid=260213 then ''  when ansid=260214 then ''   when ansid=260215 then ''   when ansid=260216 then ''   when ansid=260217 then ''  when ansid=260218 then '' when ansid=260219 then '' when ansid=260220 then ''  when ansid=260221 then ''   when ansid=260222 then ''   when ansid=260223 then ''   when ansid=260224 then ''  when ansid=260225 then ''  when ansid=260226 then ''   when ansid=260227 then ''  when ansid=260228 then '' when ansid=260229 then '' when ansid=260230 then '' when ansid=260231 then '' when ansid=260232 then '' when ansid=260233 then '' when ansid=260234 then '' when ansid=260235 then '' when ansid=260236 then ''  when ansid=260237 then ''   when ansid=260238 then ''   when ansid=260239 then ''   when ansid=260240 then ''  when ansid=260241 then '' when ansid=260242 then ''  when ansid=260243 then ''   when ansid=260244 then ''  when ansid=260245 then '' when ansid=260246 then '' when ansid=260247 then '' when ansid=260248 then '' when ansid=260249 then '' when ansid=260250 then '' when ansid=260251 then '' when ansid=260252 then '' when ansid=260253 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 14:19:25'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260148','260149','260150','260151','260152','260153','260154','260254','260255','260197','260199','260201','260203','260205','260207','260208','260209','260210','260211','260212','260213','260214','260215','260216','260217','260218','260219','260220','260221','260222','260223','260224','260225','260226','260227','260228','260229','260230','260231','260232','260233','260234','260235','260236','260237','260238','260239','260240','260241','260242','260243','260244','260245','260246','260247','260248','260249','260250','260251','260252','260253')"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE supvisstepid = '13577'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE visitfeedbackid = '13541'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE visitfeedbackid = '13542'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE visitfeedbackid = '13543'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE visitfeedbackid = '13544'"}
{"userId":"575","date":"2023-02-02 14:19:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:19:25' WHERE visitfeedbackid = '13545'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE sitesupervision SET `siteid` = '358', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '198', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2753'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Abha Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Dr Sonalika attended the training', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE onssid = '11340'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Mala', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE onssid = '11341'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Raj Kishor', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE onssid = '11342'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE onssid = '11343'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260148 then '1' when ansid=260149 then '1' when ansid=260150 then '1' when ansid=260151 then '' when ansid=260152 then ''  when ansid=260153 then ''   when ansid=260154 then '1'  when ansid=260254 then '1' when ansid=260255 then '1' when ansid=260197 then '' when ansid=260199 then '' when ansid=260201 then '' when ansid=260203 then '' when ansid=260205 then '' when ansid=260207 then '' when ansid=260208 then '' when ansid=260209 then '' when ansid=260210 then ''  when ansid=260211 then ''   when ansid=260212 then ''  when ansid=260213 then ''  when ansid=260214 then ''   when ansid=260215 then ''   when ansid=260216 then ''   when ansid=260217 then ''  when ansid=260218 then '' when ansid=260219 then '' when ansid=260220 then ''  when ansid=260221 then ''   when ansid=260222 then ''   when ansid=260223 then ''   when ansid=260224 then ''  when ansid=260225 then ''  when ansid=260226 then ''   when ansid=260227 then ''  when ansid=260228 then '' when ansid=260229 then '' when ansid=260230 then '' when ansid=260231 then '' when ansid=260232 then '' when ansid=260233 then '' when ansid=260234 then '' when ansid=260235 then '' when ansid=260236 then ''  when ansid=260237 then ''   when ansid=260238 then ''   when ansid=260239 then ''   when ansid=260240 then ''  when ansid=260241 then '' when ansid=260242 then ''  when ansid=260243 then ''   when ansid=260244 then ''  when ansid=260245 then '' when ansid=260246 then '' when ansid=260247 then '' when ansid=260248 then '' when ansid=260249 then '' when ansid=260250 then '' when ansid=260251 then '' when ansid=260252 then '' when ansid=260253 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 14:21:36'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260148','260149','260150','260151','260152','260153','260154','260254','260255','260197','260199','260201','260203','260205','260207','260208','260209','260210','260211','260212','260213','260214','260215','260216','260217','260218','260219','260220','260221','260222','260223','260224','260225','260226','260227','260228','260229','260230','260231','260232','260233','260234','260235','260236','260237','260238','260239','260240','260241','260242','260243','260244','260245','260246','260247','260248','260249','260250','260251','260252','260253')"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE supvisstepid = '13578'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE visitfeedbackid = '13541'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE visitfeedbackid = '13542'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE visitfeedbackid = '13543'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE visitfeedbackid = '13544'"}
{"userId":"575","date":"2023-02-02 14:21:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:21:36' WHERE visitfeedbackid = '13545'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE sitesupervision SET `siteid` = '358', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '198', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2753'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Abha Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Dr Sonalika attended the training', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE onssid = '11340'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Mala', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE onssid = '11341'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Raj Kishor', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE onssid = '11342'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE onssid = '11343'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260148 then '1' when ansid=260149 then '1' when ansid=260150 then '1' when ansid=260151 then '' when ansid=260152 then ''  when ansid=260153 then ''   when ansid=260154 then '1'  when ansid=260254 then '1' when ansid=260255 then '1' when ansid=260197 then '0' when ansid=260199 then '0' when ansid=260201 then '0' when ansid=260203 then '100' when ansid=260205 then '5' when ansid=260207 then '' when ansid=260208 then '' when ansid=260209 then '' when ansid=260210 then ''  when ansid=260211 then ''   when ansid=260212 then ''  when ansid=260213 then ''  when ansid=260214 then ''   when ansid=260215 then ''   when ansid=260216 then ''   when ansid=260217 then ''  when ansid=260218 then '' when ansid=260219 then '' when ansid=260220 then ''  when ansid=260221 then ''   when ansid=260222 then ''   when ansid=260223 then ''   when ansid=260224 then ''  when ansid=260225 then ''  when ansid=260226 then ''   when ansid=260227 then ''  when ansid=260228 then '' when ansid=260229 then '' when ansid=260230 then '' when ansid=260231 then '' when ansid=260232 then '' when ansid=260233 then '' when ansid=260234 then '' when ansid=260235 then '' when ansid=260236 then ''  when ansid=260237 then ''   when ansid=260238 then ''   when ansid=260239 then ''   when ansid=260240 then ''  when ansid=260241 then '' when ansid=260242 then ''  when ansid=260243 then ''   when ansid=260244 then ''  when ansid=260245 then '' when ansid=260246 then '' when ansid=260247 then '' when ansid=260248 then '' when ansid=260249 then '' when ansid=260250 then '' when ansid=260251 then '' when ansid=260252 then '' when ansid=260253 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 14:22:00'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260148','260149','260150','260151','260152','260153','260154','260254','260255','260197','260199','260201','260203','260205','260207','260208','260209','260210','260211','260212','260213','260214','260215','260216','260217','260218','260219','260220','260221','260222','260223','260224','260225','260226','260227','260228','260229','260230','260231','260232','260233','260234','260235','260236','260237','260238','260239','260240','260241','260242','260243','260244','260245','260246','260247','260248','260249','260250','260251','260252','260253')"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE supvisstepid = '13579'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE visitfeedbackid = '13541'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE visitfeedbackid = '13542'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE visitfeedbackid = '13543'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE visitfeedbackid = '13544'"}
{"userId":"575","date":"2023-02-02 14:22:00","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '575', `modifieddate` = '2023-02-02 14:22:00' WHERE visitfeedbackid = '13545'"}
{"userId":"574","date":"2023-02-02 14:45:54","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.12', '2023-02-02 14:45:54')"}
{"userId":"2","date":"2023-02-02 15:04:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '110.235.232.12', '2023-02-02 15:04:37')"}
{"userId":"575","date":"2023-02-02 15:06:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.12', '2023-02-02 15:06:44')"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE sitesupervision SET `siteid` = '358', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '198', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2753'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Abha Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Dr Sonalika attended the training', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE onssid = '11340'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Mala', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE onssid = '11341'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Raj Kishor', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE onssid = '11342'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE onssid = '11343'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260148 then '1' when ansid=260149 then '1' when ansid=260150 then '1' when ansid=260151 then '' when ansid=260152 then ''  when ansid=260153 then ''   when ansid=260154 then '1'  when ansid=260254 then '1' when ansid=260255 then '1' when ansid=260197 then '0' when ansid=260199 then '0' when ansid=260201 then '0' when ansid=260203 then '100' when ansid=260205 then '5' when ansid=260207 then '10' when ansid=260208 then '0' when ansid=260209 then '1400' when ansid=260210 then '27'  when ansid=260211 then ''   when ansid=260212 then '1'  when ansid=260213 then '1'  when ansid=260214 then 'Consecutiveness not followed'   when ansid=260215 then '2'   when ansid=260216 then ''   when ansid=260217 then '1'  when ansid=260218 then '10' when ansid=260219 then '1' when ansid=260220 then '2'  when ansid=260221 then 'counselor'   when ansid=260222 then '1'   when ansid=260223 then ''   when ansid=260224 then '1'  when ansid=260225 then '1'  when ansid=260226 then ''   when ansid=260227 then '1'  when ansid=260228 then '4' when ansid=260229 then '1' when ansid=260230 then '1' when ansid=260231 then '2' when ansid=260232 then '1' when ansid=260233 then '2' when ansid=260234 then '1' when ansid=260235 then '1' when ansid=260236 then '1'  when ansid=260237 then ''   when ansid=260238 then '4'   when ansid=260239 then ''   when ansid=260240 then '1'  when ansid=260241 then '1' when ansid=260242 then '1'  when ansid=260243 then ''   when ansid=260244 then '1'  when ansid=260245 then '2' when ansid=260246 then '1' when ansid=260247 then '1' when ansid=260248 then '1' when ansid=260249 then '0' when ansid=260250 then 'Non availability of contingency money for courier etc.' when ansid=260251 then 'No' when ansid=260252 then 'Extremally poor quality of syringe. Almost 50% are not workingVery poor quality of syringe supplied by BMSICL. Almost 50% syringes were disabled. Cryo vial size was less than the recommended size of 3 ml. Supplied size was 1.8 ml. Consecutiveness not maintained.Operational Manual was not available with the site personnel.BMW management is poor.' when ansid=260253 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:11:26'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260148','260149','260150','260151','260152','260153','260154','260254','260255','260197','260199','260201','260203','260205','260207','260208','260209','260210','260211','260212','260213','260214','260215','260216','260217','260218','260219','260220','260221','260222','260223','260224','260225','260226','260227','260228','260229','260230','260231','260232','260233','260234','260235','260236','260237','260238','260239','260240','260241','260242','260243','260244','260245','260246','260247','260248','260249','260250','260251','260252','260253')"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE supvisstepid = '13580'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE visitfeedbackid = '13541'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE visitfeedbackid = '13542'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE visitfeedbackid = '13543'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE visitfeedbackid = '13544'"}
{"userId":"574","date":"2023-02-02 15:11:26","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:11:26' WHERE visitfeedbackid = '13545'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE sitesupervision SET `siteid` = '358', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '198', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20', `locationtype` = '1', `establishmentyear` = '2003', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2753'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Abha Sinha', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'Dr Sonalika attended the training', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE onssid = '11340'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Mala', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE onssid = '11341'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Raj Kishor', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE onssid = '11342'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE onssid = '11343'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260148 then '1' when ansid=260149 then '1' when ansid=260150 then '1' when ansid=260151 then '' when ansid=260152 then ''  when ansid=260153 then ''   when ansid=260154 then '1'  when ansid=260254 then '1' when ansid=260255 then '1' when ansid=260197 then '0' when ansid=260199 then '0' when ansid=260201 then '0' when ansid=260203 then '100' when ansid=260205 then '5' when ansid=260207 then '10' when ansid=260208 then '0' when ansid=260209 then '1400' when ansid=260210 then '27'  when ansid=260211 then ''   when ansid=260212 then '1'  when ansid=260213 then '1'  when ansid=260214 then 'Consecutiveness not followed'   when ansid=260215 then '2'   when ansid=260216 then ''   when ansid=260217 then '1'  when ansid=260218 then '10' when ansid=260219 then '1' when ansid=260220 then '2'  when ansid=260221 then 'counselor'   when ansid=260222 then '1'   when ansid=260223 then ''   when ansid=260224 then '1'  when ansid=260225 then '1'  when ansid=260226 then ''   when ansid=260227 then '1'  when ansid=260228 then '4' when ansid=260229 then '1' when ansid=260230 then '1' when ansid=260231 then '2' when ansid=260232 then '1' when ansid=260233 then '2' when ansid=260234 then '1' when ansid=260235 then '1' when ansid=260236 then '1'  when ansid=260237 then ''   when ansid=260238 then '4'   when ansid=260239 then ''   when ansid=260240 then '1'  when ansid=260241 then '1' when ansid=260242 then '1'  when ansid=260243 then ''   when ansid=260244 then '1'  when ansid=260245 then '2' when ansid=260246 then '1' when ansid=260247 then '1' when ansid=260248 then '1' when ansid=260249 then '0' when ansid=260250 then 'Non availability of contingency money for courier etc.' when ansid=260251 then 'No' when ansid=260252 then 'Extremally poor quality of syringe. Almost 50% are not workingVery poor quality of syringe supplied by BMSICL. Almost 50% syringes were disabled. Cryo vial size was less than the recommended size of 3 ml. Supplied size was 1.8 ml. Consecutiveness not maintained.Operational Manual was not available with the site personnel.BMW management is poor.' when ansid=260253 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:15:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260148','260149','260150','260151','260152','260153','260154','260254','260255','260197','260199','260201','260203','260205','260207','260208','260209','260210','260211','260212','260213','260214','260215','260216','260217','260218','260219','260220','260221','260222','260223','260224','260225','260226','260227','260228','260229','260230','260231','260232','260233','260234','260235','260236','260237','260238','260239','260240','260241','260242','260243','260244','260245','260246','260247','260248','260249','260250','260251','260252','260253')"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE supvisstepid = '13581'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE visitfeedback SET `feedback` = 'Consecutiveness not maintained - on site training was given', `recommendation` = 'A repeat visit is required to verify the consecutive recruitments.', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE visitfeedbackid = '13541'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE visitfeedback SET `feedback` = 'Poor quality of syringe supplied by BMSICL - No action taken but must be informed to higher authority.', `recommendation` = 'BSACS was asked to provide manuals and replace the vials with 3 ml', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE visitfeedbackid = '13542'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE visitfeedback SET `feedback` = 'TPHA kits were not as per recommendation', `recommendation` = 'TPHA kits issue to be resolved on priority', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE visitfeedbackid = '13543'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE visitfeedback SET `feedback` = 'Vial size was 1.8 ml - but can accomodate2 ml serum,', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE visitfeedbackid = '13544'"}
{"userId":"574","date":"2023-02-02 15:15:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:15:20' WHERE visitfeedbackid = '13545'"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('361', '3198', '574', '2023-02-02', '1', '110.235.232.12', '574', '2023-02-02 15:23:46', '', '')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2754', '0', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2754', '1', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2754', '2', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2754', '3', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2754', '4', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2754', '', '', 'Array', '', 'Array', '', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2754', '', '', 'Array', '', 'Array', '', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2754', '', '', 'Array', '', 'Array', '', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2754', '', '', 'Array', '', 'Array', '', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:23:46","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2754', '110.235.232.12', '574', '2023-02-02 15:23:46')"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE sitesupervision SET `siteid` = '361', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '82', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2754'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Sonali', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE onssid = '11344'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rupam', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE onssid = '11345'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE onsitestaffs SET `staffname` = 'Mr pankaj', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE onssid = '11346'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE onssid = '11347'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260256 then '' when ansid=260257 then '' when ansid=260258 then '' when ansid=260259 then '' when ansid=260260 then ''  when ansid=260261 then ''   when ansid=260262 then ''  when ansid=260362 then '' when ansid=260363 then '' when ansid=260305 then '' when ansid=260307 then '' when ansid=260309 then '' when ansid=260311 then '' when ansid=260313 then '' when ansid=260315 then '' when ansid=260316 then '' when ansid=260317 then '' when ansid=260318 then ''  when ansid=260319 then ''   when ansid=260320 then ''  when ansid=260321 then ''  when ansid=260322 then ''   when ansid=260323 then ''   when ansid=260324 then ''   when ansid=260325 then ''  when ansid=260326 then '' when ansid=260327 then '' when ansid=260328 then ''  when ansid=260329 then ''   when ansid=260330 then ''   when ansid=260331 then ''   when ansid=260332 then ''  when ansid=260333 then ''  when ansid=260334 then ''   when ansid=260335 then ''  when ansid=260336 then '' when ansid=260337 then '' when ansid=260338 then '' when ansid=260339 then '' when ansid=260340 then '' when ansid=260341 then '' when ansid=260342 then '' when ansid=260343 then '' when ansid=260344 then ''  when ansid=260345 then ''   when ansid=260346 then ''   when ansid=260347 then ''   when ansid=260348 then ''  when ansid=260349 then '' when ansid=260350 then ''  when ansid=260351 then ''   when ansid=260352 then ''  when ansid=260353 then '' when ansid=260354 then '' when ansid=260355 then '' when ansid=260356 then '' when ansid=260357 then '' when ansid=260358 then '' when ansid=260359 then '' when ansid=260360 then '' when ansid=260361 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:28:07'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260256','260257','260258','260259','260260','260261','260262','260362','260363','260305','260307','260309','260311','260313','260315','260316','260317','260318','260319','260320','260321','260322','260323','260324','260325','260326','260327','260328','260329','260330','260331','260332','260333','260334','260335','260336','260337','260338','260339','260340','260341','260342','260343','260344','260345','260346','260347','260348','260349','260350','260351','260352','260353','260354','260355','260356','260357','260358','260359','260360','260361')"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE supvisstepid = '13582'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE visitfeedbackid = '13546'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE visitfeedbackid = '13547'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE visitfeedbackid = '13548'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE visitfeedbackid = '13549'"}
{"userId":"574","date":"2023-02-02 15:28:07","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:07' WHERE visitfeedbackid = '13550'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE sitesupervision SET `siteid` = '361', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '82', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2754'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Sonali', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE onssid = '11344'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rupam', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE onssid = '11345'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE onsitestaffs SET `staffname` = 'Mr pankaj', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE onssid = '11346'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE onssid = '11347'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260256 then '1' when ansid=260257 then '1' when ansid=260258 then '1' when ansid=260259 then '' when ansid=260260 then ''  when ansid=260261 then ''   when ansid=260262 then '1'  when ansid=260362 then '1' when ansid=260363 then '1' when ansid=260305 then '' when ansid=260307 then '' when ansid=260309 then '' when ansid=260311 then '' when ansid=260313 then '' when ansid=260315 then '' when ansid=260316 then '' when ansid=260317 then '' when ansid=260318 then ''  when ansid=260319 then ''   when ansid=260320 then ''  when ansid=260321 then ''  when ansid=260322 then ''   when ansid=260323 then ''   when ansid=260324 then ''   when ansid=260325 then ''  when ansid=260326 then '' when ansid=260327 then '' when ansid=260328 then ''  when ansid=260329 then ''   when ansid=260330 then ''   when ansid=260331 then ''   when ansid=260332 then ''  when ansid=260333 then ''  when ansid=260334 then ''   when ansid=260335 then ''  when ansid=260336 then '' when ansid=260337 then '' when ansid=260338 then '' when ansid=260339 then '' when ansid=260340 then '' when ansid=260341 then '' when ansid=260342 then '' when ansid=260343 then '' when ansid=260344 then ''  when ansid=260345 then ''   when ansid=260346 then ''   when ansid=260347 then ''   when ansid=260348 then ''  when ansid=260349 then '' when ansid=260350 then ''  when ansid=260351 then ''   when ansid=260352 then ''  when ansid=260353 then '' when ansid=260354 then '' when ansid=260355 then '' when ansid=260356 then '' when ansid=260357 then '' when ansid=260358 then '' when ansid=260359 then '' when ansid=260360 then '' when ansid=260361 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:28:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260256','260257','260258','260259','260260','260261','260262','260362','260363','260305','260307','260309','260311','260313','260315','260316','260317','260318','260319','260320','260321','260322','260323','260324','260325','260326','260327','260328','260329','260330','260331','260332','260333','260334','260335','260336','260337','260338','260339','260340','260341','260342','260343','260344','260345','260346','260347','260348','260349','260350','260351','260352','260353','260354','260355','260356','260357','260358','260359','260360','260361')"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE supvisstepid = '13583'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE visitfeedbackid = '13546'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE visitfeedbackid = '13547'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE visitfeedbackid = '13548'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE visitfeedbackid = '13549'"}
{"userId":"574","date":"2023-02-02 15:28:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:28' WHERE visitfeedbackid = '13550'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE sitesupervision SET `siteid` = '361', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '82', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2754'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Sonali', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE onssid = '11344'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rupam', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE onssid = '11345'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr pankaj', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE onssid = '11346'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE onssid = '11347'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260256 then '1' when ansid=260257 then '1' when ansid=260258 then '1' when ansid=260259 then '' when ansid=260260 then ''  when ansid=260261 then ''   when ansid=260262 then '1'  when ansid=260362 then '1' when ansid=260363 then '1' when ansid=260305 then '0' when ansid=260307 then '0' when ansid=260309 then '0' when ansid=260311 then '100' when ansid=260313 then '5' when ansid=260315 then '' when ansid=260316 then '' when ansid=260317 then '' when ansid=260318 then ''  when ansid=260319 then ''   when ansid=260320 then ''  when ansid=260321 then ''  when ansid=260322 then ''   when ansid=260323 then ''   when ansid=260324 then ''   when ansid=260325 then ''  when ansid=260326 then '' when ansid=260327 then '' when ansid=260328 then ''  when ansid=260329 then ''   when ansid=260330 then ''   when ansid=260331 then ''   when ansid=260332 then ''  when ansid=260333 then ''  when ansid=260334 then ''   when ansid=260335 then ''  when ansid=260336 then '' when ansid=260337 then '' when ansid=260338 then '' when ansid=260339 then '' when ansid=260340 then '' when ansid=260341 then '' when ansid=260342 then '' when ansid=260343 then '' when ansid=260344 then ''  when ansid=260345 then ''   when ansid=260346 then ''   when ansid=260347 then ''   when ansid=260348 then ''  when ansid=260349 then '' when ansid=260350 then ''  when ansid=260351 then ''   when ansid=260352 then ''  when ansid=260353 then '' when ansid=260354 then '' when ansid=260355 then '' when ansid=260356 then '' when ansid=260357 then '' when ansid=260358 then '' when ansid=260359 then '' when ansid=260360 then '' when ansid=260361 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:28:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260256','260257','260258','260259','260260','260261','260262','260362','260363','260305','260307','260309','260311','260313','260315','260316','260317','260318','260319','260320','260321','260322','260323','260324','260325','260326','260327','260328','260329','260330','260331','260332','260333','260334','260335','260336','260337','260338','260339','260340','260341','260342','260343','260344','260345','260346','260347','260348','260349','260350','260351','260352','260353','260354','260355','260356','260357','260358','260359','260360','260361')"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE supvisstepid = '13584'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE visitfeedbackid = '13546'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE visitfeedbackid = '13547'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE visitfeedbackid = '13548'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE visitfeedbackid = '13549'"}
{"userId":"574","date":"2023-02-02 15:28:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:28:42' WHERE visitfeedbackid = '13550'"}
{"userId":"544","date":"2023-02-02 15:32:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '223.187.201.11', '2023-02-02 15:32:21')"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE sitesupervision SET `siteid` = '361', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '82', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2754'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Sonali', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE onssid = '11344'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rupam', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE onssid = '11345'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE onsitestaffs SET `staffname` = 'Mr pankaj', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE onssid = '11346'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE onssid = '11347'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260256 then '1' when ansid=260257 then '1' when ansid=260258 then '1' when ansid=260259 then '' when ansid=260260 then ''  when ansid=260261 then ''   when ansid=260262 then '1'  when ansid=260362 then '1' when ansid=260363 then '1' when ansid=260305 then '0' when ansid=260307 then '0' when ansid=260309 then '0' when ansid=260311 then '100' when ansid=260313 then '5' when ansid=260315 then '8' when ansid=260316 then '0' when ansid=260317 then '200' when ansid=260318 then '14'  when ansid=260319 then ''   when ansid=260320 then '1'  when ansid=260321 then '1'  when ansid=260322 then 'Consecutiveness not followed'   when ansid=260323 then '2'   when ansid=260324 then ''   when ansid=260325 then '1'  when ansid=260326 then '6' when ansid=260327 then '1' when ansid=260328 then '2'  when ansid=260329 then 'counselor'   when ansid=260330 then '1'   when ansid=260331 then ''   when ansid=260332 then '1'  when ansid=260333 then '1'  when ansid=260334 then ''   when ansid=260335 then '1'  when ansid=260336 then '4' when ansid=260337 then '1' when ansid=260338 then '1' when ansid=260339 then '1' when ansid=260340 then '1' when ansid=260341 then '2' when ansid=260342 then '1' when ansid=260343 then '1' when ansid=260344 then '1'  when ansid=260345 then ''   when ansid=260346 then '4'   when ansid=260347 then ''   when ansid=260348 then '1'  when ansid=260349 then '1' when ansid=260350 then '1'  when ansid=260351 then ''   when ansid=260352 then '1'  when ansid=260353 then '2' when ansid=260354 then '1' when ansid=260355 then '1' when ansid=260356 then '1' when ansid=260357 then '0' when ansid=260358 then 'ANC Manual not provided to site personnel. Both LT and Counsellor did not receive honorarium of year 2019.' when ansid=260359 then 'No' when ansid=260360 then 'Both LT and Counsellor did not receive honorarium of year 2019. ANC Manual not provided to site personnel.Extremally poor quality of syringe. Almost 50% are not workingVery poor quality of syringe supplied by BMSICL. Almost 50% syringes were disabled. Cryo vial size was less than the recommended size of 3 ml. Supplied size was 1.8 ml. Consecutiveness not maintained.' when ansid=260361 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:37:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260256','260257','260258','260259','260260','260261','260262','260362','260363','260305','260307','260309','260311','260313','260315','260316','260317','260318','260319','260320','260321','260322','260323','260324','260325','260326','260327','260328','260329','260330','260331','260332','260333','260334','260335','260336','260337','260338','260339','260340','260341','260342','260343','260344','260345','260346','260347','260348','260349','260350','260351','260352','260353','260354','260355','260356','260357','260358','260359','260360','260361')"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE supvisstepid = '13585'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE visitfeedbackid = '13546'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE visitfeedbackid = '13547'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE visitfeedbackid = '13548'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE visitfeedbackid = '13549'"}
{"userId":"574","date":"2023-02-02 15:37:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:37:11' WHERE visitfeedbackid = '13550'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE sitesupervision SET `siteid` = '361', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '82', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30', `locationtype` = '2', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2754'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Sonali', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE onssid = '11344'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Rupam', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE onssid = '11345'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr pankaj', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE onssid = '11346'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE onssid = '11347'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260256 then '1' when ansid=260257 then '1' when ansid=260258 then '1' when ansid=260259 then '' when ansid=260260 then ''  when ansid=260261 then ''   when ansid=260262 then '1'  when ansid=260362 then '1' when ansid=260363 then '1' when ansid=260305 then '0' when ansid=260307 then '0' when ansid=260309 then '0' when ansid=260311 then '100' when ansid=260313 then '5' when ansid=260315 then '8' when ansid=260316 then '0' when ansid=260317 then '200' when ansid=260318 then '14'  when ansid=260319 then ''   when ansid=260320 then '1'  when ansid=260321 then '1'  when ansid=260322 then 'Consecutiveness not followed'   when ansid=260323 then '2'   when ansid=260324 then ''   when ansid=260325 then '1'  when ansid=260326 then '6' when ansid=260327 then '1' when ansid=260328 then '2'  when ansid=260329 then 'counselor'   when ansid=260330 then '1'   when ansid=260331 then ''   when ansid=260332 then '1'  when ansid=260333 then '1'  when ansid=260334 then ''   when ansid=260335 then '1'  when ansid=260336 then '4' when ansid=260337 then '1' when ansid=260338 then '1' when ansid=260339 then '1' when ansid=260340 then '1' when ansid=260341 then '2' when ansid=260342 then '1' when ansid=260343 then '1' when ansid=260344 then '1'  when ansid=260345 then ''   when ansid=260346 then '4'   when ansid=260347 then ''   when ansid=260348 then '1'  when ansid=260349 then '1' when ansid=260350 then '1'  when ansid=260351 then ''   when ansid=260352 then '1'  when ansid=260353 then '2' when ansid=260354 then '1' when ansid=260355 then '1' when ansid=260356 then '1' when ansid=260357 then '0' when ansid=260358 then 'ANC Manual not provided to site personnel. Both LT and Counsellor did not receive honorarium of year 2019.' when ansid=260359 then 'No' when ansid=260360 then 'Both LT and Counsellor did not receive honorarium of year 2019. ANC Manual not provided to site personnel.Extremally poor quality of syringe. Almost 50% are not workingVery poor quality of syringe supplied by BMSICL. Almost 50% syringes were disabled. Cryo vial size was less than the recommended size of 3 ml. Supplied size was 1.8 ml. Consecutiveness not maintained.' when ansid=260361 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.12',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 15:40:30'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260256','260257','260258','260259','260260','260261','260262','260362','260363','260305','260307','260309','260311','260313','260315','260316','260317','260318','260319','260320','260321','260322','260323','260324','260325','260326','260327','260328','260329','260330','260331','260332','260333','260334','260335','260336','260337','260338','260339','260340','260341','260342','260343','260344','260345','260346','260347','260348','260349','260350','260351','260352','260353','260354','260355','260356','260357','260358','260359','260360','260361')"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE supvisstepid = '13586'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE visitfeedback SET `feedback` = 'Consecutiveness not maintained - on site training was given', `recommendation` = 'A repeat visit is required to verify the consecutive recruitments.', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE visitfeedbackid = '13546'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE visitfeedback SET `feedback` = 'Poor quality of syringe supplied by BMSICL - No action taken but must be informed to higher authority.', `recommendation` = 'Issue of TPHA kits to be resolved on priority', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE visitfeedbackid = '13547'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE visitfeedback SET `feedback` = 'TPHA kits were not as per recommendation', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE visitfeedbackid = '13548'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE visitfeedbackid = '13549'"}
{"userId":"574","date":"2023-02-02 15:40:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.12', `modifiedby` = '574', `modifieddate` = '2023-02-02 15:40:30' WHERE visitfeedbackid = '13550'"}
{"userId":"7","date":"2023-02-02 16:59:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-02-02 16:59:09')"}
{"userId":"660","date":"2023-02-02 21:14:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '103.102.116.173', '2023-02-02 21:14:32')"}
{"userId":"660","date":"2023-02-02 21:15:33","query":"UPDATE plannedsites SET `siteid` = '431', `visitdate` = '2023-02-02', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:15:33' WHERE plansiteid = '3218'"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('431', '3218', '660', '2023-02-02', '1', '103.102.116.173', '660', '2023-02-02 21:19:52', '', '')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2755', '0', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2755', '1', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2755', '2', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2755', '3', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2755', '4', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2755', '', '', 'Array', '', 'Array', '', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2755', '', '', 'Array', '', 'Array', '', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2755', '', '', 'Array', '', 'Array', '', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2755', '', '', 'Array', '', 'Array', '', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:19:52","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2755', '103.102.116.173', '660', '2023-02-02 21:19:52')"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE sitesupervision SET `siteid` = '431', `userid` = '660', `ancservicedays` = '3', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '204', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2755'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amita Pathak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '08', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE onssid = '11348'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE onsitestaffs SET `staffname` = 'Papri Sil', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE onssid = '11349'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE onsitestaffs SET `staffname` = 'Sk Noor Islam', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE onssid = '11350'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE onssid = '11351'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260364 then '' when ansid=260365 then '' when ansid=260366 then '' when ansid=260367 then '' when ansid=260368 then ''  when ansid=260369 then ''   when ansid=260370 then ''  when ansid=260470 then '' when ansid=260471 then '' when ansid=260413 then '' when ansid=260415 then '' when ansid=260417 then '' when ansid=260419 then '' when ansid=260421 then '' when ansid=260423 then '' when ansid=260424 then '' when ansid=260425 then '' when ansid=260426 then ''  when ansid=260427 then ''   when ansid=260428 then ''  when ansid=260429 then ''  when ansid=260430 then ''   when ansid=260431 then ''   when ansid=260432 then ''   when ansid=260433 then ''  when ansid=260434 then '' when ansid=260435 then '' when ansid=260436 then ''  when ansid=260437 then ''   when ansid=260438 then ''   when ansid=260439 then ''   when ansid=260440 then ''  when ansid=260441 then ''  when ansid=260442 then ''   when ansid=260443 then ''  when ansid=260444 then '' when ansid=260445 then '' when ansid=260446 then '' when ansid=260447 then '' when ansid=260448 then '' when ansid=260449 then '' when ansid=260450 then '' when ansid=260451 then '' when ansid=260452 then ''  when ansid=260453 then ''   when ansid=260454 then ''   when ansid=260455 then ''   when ansid=260456 then ''  when ansid=260457 then '' when ansid=260458 then ''  when ansid=260459 then ''   when ansid=260460 then ''  when ansid=260461 then '' when ansid=260462 then '' when ansid=260463 then '' when ansid=260464 then '' when ansid=260465 then '' when ansid=260466 then '' when ansid=260467 then '' when ansid=260468 then '' when ansid=260469 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.102.116.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 21:23:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260364','260365','260366','260367','260368','260369','260370','260470','260471','260413','260415','260417','260419','260421','260423','260424','260425','260426','260427','260428','260429','260430','260431','260432','260433','260434','260435','260436','260437','260438','260439','260440','260441','260442','260443','260444','260445','260446','260447','260448','260449','260450','260451','260452','260453','260454','260455','260456','260457','260458','260459','260460','260461','260462','260463','260464','260465','260466','260467','260468','260469')"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE supvisstepid = '13587'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE visitfeedbackid = '13551'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE visitfeedbackid = '13552'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE visitfeedbackid = '13553'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE visitfeedbackid = '13554'"}
{"userId":"660","date":"2023-02-02 21:23:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:23:05' WHERE visitfeedbackid = '13555'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE sitesupervision SET `siteid` = '431', `userid` = '660', `ancservicedays` = '3', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '204', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2755'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amita Pathak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '08', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE onssid = '11348'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE onsitestaffs SET `staffname` = 'Papri Sil', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE onssid = '11349'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE onsitestaffs SET `staffname` = 'Sk Noor Islam', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE onssid = '11350'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE onssid = '11351'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260364 then '1' when ansid=260365 then '1' when ansid=260366 then '1' when ansid=260367 then '' when ansid=260368 then ''  when ansid=260369 then '118'   when ansid=260370 then '1'  when ansid=260470 then '1' when ansid=260471 then '1' when ansid=260413 then '' when ansid=260415 then '' when ansid=260417 then '' when ansid=260419 then '' when ansid=260421 then '' when ansid=260423 then '' when ansid=260424 then '' when ansid=260425 then '' when ansid=260426 then ''  when ansid=260427 then ''   when ansid=260428 then ''  when ansid=260429 then ''  when ansid=260430 then ''   when ansid=260431 then ''   when ansid=260432 then ''   when ansid=260433 then ''  when ansid=260434 then '' when ansid=260435 then '' when ansid=260436 then ''  when ansid=260437 then ''   when ansid=260438 then ''   when ansid=260439 then ''   when ansid=260440 then ''  when ansid=260441 then ''  when ansid=260442 then ''   when ansid=260443 then ''  when ansid=260444 then '' when ansid=260445 then '' when ansid=260446 then '' when ansid=260447 then '' when ansid=260448 then '' when ansid=260449 then '' when ansid=260450 then '' when ansid=260451 then '' when ansid=260452 then ''  when ansid=260453 then ''   when ansid=260454 then ''   when ansid=260455 then ''   when ansid=260456 then ''  when ansid=260457 then '' when ansid=260458 then ''  when ansid=260459 then ''   when ansid=260460 then ''  when ansid=260461 then '' when ansid=260462 then '' when ansid=260463 then '' when ansid=260464 then '' when ansid=260465 then '' when ansid=260466 then '' when ansid=260467 then '' when ansid=260468 then '' when ansid=260469 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.102.116.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 21:24:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260364','260365','260366','260367','260368','260369','260370','260470','260471','260413','260415','260417','260419','260421','260423','260424','260425','260426','260427','260428','260429','260430','260431','260432','260433','260434','260435','260436','260437','260438','260439','260440','260441','260442','260443','260444','260445','260446','260447','260448','260449','260450','260451','260452','260453','260454','260455','260456','260457','260458','260459','260460','260461','260462','260463','260464','260465','260466','260467','260468','260469')"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE supvisstepid = '13588'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE visitfeedbackid = '13551'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE visitfeedbackid = '13552'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE visitfeedbackid = '13553'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE visitfeedbackid = '13554'"}
{"userId":"660","date":"2023-02-02 21:24:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:05' WHERE visitfeedbackid = '13555'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE sitesupervision SET `siteid` = '431', `userid` = '660', `ancservicedays` = '3', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '204', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2755'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amita Pathak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '08', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE onssid = '11348'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE onsitestaffs SET `staffname` = 'Papri Sil', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE onssid = '11349'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE onsitestaffs SET `staffname` = 'Sk Noor Islam', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE onssid = '11350'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE onssid = '11351'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260364 then '1' when ansid=260365 then '1' when ansid=260366 then '1' when ansid=260367 then '' when ansid=260368 then ''  when ansid=260369 then '118'   when ansid=260370 then '1'  when ansid=260470 then '1' when ansid=260471 then '1' when ansid=260413 then '02' when ansid=260415 then '01' when ansid=260417 then '0' when ansid=260419 then '300' when ansid=260421 then '3' when ansid=260423 then '' when ansid=260424 then '' when ansid=260425 then '' when ansid=260426 then ''  when ansid=260427 then ''   when ansid=260428 then ''  when ansid=260429 then ''  when ansid=260430 then ''   when ansid=260431 then ''   when ansid=260432 then ''   when ansid=260433 then ''  when ansid=260434 then '' when ansid=260435 then '' when ansid=260436 then ''  when ansid=260437 then ''   when ansid=260438 then ''   when ansid=260439 then ''   when ansid=260440 then ''  when ansid=260441 then ''  when ansid=260442 then ''   when ansid=260443 then ''  when ansid=260444 then '' when ansid=260445 then '' when ansid=260446 then '' when ansid=260447 then '' when ansid=260448 then '' when ansid=260449 then '' when ansid=260450 then '' when ansid=260451 then '' when ansid=260452 then ''  when ansid=260453 then ''   when ansid=260454 then ''   when ansid=260455 then ''   when ansid=260456 then ''  when ansid=260457 then '' when ansid=260458 then ''  when ansid=260459 then ''   when ansid=260460 then ''  when ansid=260461 then '' when ansid=260462 then '' when ansid=260463 then '' when ansid=260464 then '' when ansid=260465 then '' when ansid=260466 then '' when ansid=260467 then '' when ansid=260468 then '' when ansid=260469 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.102.116.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 21:24:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260364','260365','260366','260367','260368','260369','260370','260470','260471','260413','260415','260417','260419','260421','260423','260424','260425','260426','260427','260428','260429','260430','260431','260432','260433','260434','260435','260436','260437','260438','260439','260440','260441','260442','260443','260444','260445','260446','260447','260448','260449','260450','260451','260452','260453','260454','260455','260456','260457','260458','260459','260460','260461','260462','260463','260464','260465','260466','260467','260468','260469')"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE supvisstepid = '13589'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE visitfeedbackid = '13551'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE visitfeedbackid = '13552'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE visitfeedbackid = '13553'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE visitfeedbackid = '13554'"}
{"userId":"660","date":"2023-02-02 21:24:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:24:58' WHERE visitfeedbackid = '13555'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE sitesupervision SET `siteid` = '431', `userid` = '660', `ancservicedays` = '3', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '204', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2755'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amita Pathak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '08', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE onssid = '11348'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE onsitestaffs SET `staffname` = 'Papri Sil', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE onssid = '11349'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE onsitestaffs SET `staffname` = 'Sk Noor Islam', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE onssid = '11350'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE onssid = '11351'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260364 then '1' when ansid=260365 then '1' when ansid=260366 then '1' when ansid=260367 then '' when ansid=260368 then ''  when ansid=260369 then '118'   when ansid=260370 then '1'  when ansid=260470 then '1' when ansid=260471 then '1' when ansid=260413 then '02' when ansid=260415 then '01' when ansid=260417 then '0' when ansid=260419 then '300' when ansid=260421 then '3' when ansid=260423 then '05' when ansid=260424 then '05' when ansid=260425 then '365' when ansid=260426 then '75'  when ansid=260427 then ''   when ansid=260428 then '1'  when ansid=260429 then '1'  when ansid=260430 then ''   when ansid=260431 then '1'   when ansid=260432 then ''   when ansid=260433 then '1'  when ansid=260434 then '18' when ansid=260435 then '1' when ansid=260436 then '1'  when ansid=260437 then 'Counselor'   when ansid=260438 then '1'   when ansid=260439 then ''   when ansid=260440 then '1'  when ansid=260441 then '1'  when ansid=260442 then ''   when ansid=260443 then '1'  when ansid=260444 then '1' when ansid=260445 then '1' when ansid=260446 then '1' when ansid=260447 then '1' when ansid=260448 then '1' when ansid=260449 then '2' when ansid=260450 then '1' when ansid=260451 then '1' when ansid=260452 then '1'  when ansid=260453 then ''   when ansid=260454 then '3'   when ansid=260455 then 'Thermocol box with ice pack'   when ansid=260456 then '2'  when ansid=260457 then '1' when ansid=260458 then '2'  when ansid=260459 then ''   when ansid=260460 then '1'  when ansid=260461 then '2' when ansid=260462 then '1' when ansid=260463 then '1' when ansid=260464 then '1' when ansid=260465 then '0' when ansid=260466 then 'No specific problem regarding transportation of samples or other logistic supply' when ansid=260467 then 'No visit during this HSS round. Last visit on 21\/01\/2019 by SACS. No specific issues for action was mentioned.' when ansid=260468 then '1. ANC clinic and HSS clinic (for counseling and sample collection) in different floors of the same building, though consecutive sampling in recruitment is ensured.2. Consent taking process not appropriate. The actual consent form to be used and to be explained more elaborately. The process discussed with the counselor and also shown.3. All columns of the register to be filled up - for example, for yes\/no, either yes or no to be filled up in each cell. Shown to the counselor and corrected all missing enties.4. Blood sample collection= processing: Actually two aliquots are prepared - for HSS and PPTCT. Routine tests are done in separate days in pathology dept per hospital local practice. Shared with the superintendent. 5. Samples are transported in appropriate transportation box but using thermocol box. Vaccine carrier top be used, whic is available in the hospital.6. BMW management: Certain wrong practices\/limitations: a. Incorrect preparation of 1% hypochlorite solution - shown hot to prepare with corect dilution.b. Incorrect segregation of wastes - cotton swab placed in yellow bag etc c. Incorrect use of hub cutter- shown to use correctly d. Blue coloured cardboard box to be made available.' when ansid=260469 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.102.116.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 21:54:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260364','260365','260366','260367','260368','260369','260370','260470','260471','260413','260415','260417','260419','260421','260423','260424','260425','260426','260427','260428','260429','260430','260431','260432','260433','260434','260435','260436','260437','260438','260439','260440','260441','260442','260443','260444','260445','260446','260447','260448','260449','260450','260451','260452','260453','260454','260455','260456','260457','260458','260459','260460','260461','260462','260463','260464','260465','260466','260467','260468','260469')"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE supvisstepid = '13590'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE visitfeedbackid = '13551'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE visitfeedbackid = '13552'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE visitfeedbackid = '13553'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE visitfeedbackid = '13554'"}
{"userId":"660","date":"2023-02-02 21:54:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 21:54:29' WHERE visitfeedbackid = '13555'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE sitesupervision SET `siteid` = '431', `userid` = '660', `ancservicedays` = '3', `samplecollectiondays` = '3', `samplecollectionstartdate` = '2023-02-02', `numofsamplecollected` = '204', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11', `locationtype` = '1', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2755'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Amita Pathak', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '08', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE onssid = '11348'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE onsitestaffs SET `staffname` = 'Papri Sil', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '08', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE onssid = '11349'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE onsitestaffs SET `staffname` = 'Sk Noor Islam', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE onssid = '11350'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE onssid = '11351'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=260364 then '1' when ansid=260365 then '1' when ansid=260366 then '1' when ansid=260367 then '' when ansid=260368 then ''  when ansid=260369 then '118'   when ansid=260370 then '1'  when ansid=260470 then '1' when ansid=260471 then '1' when ansid=260413 then '02' when ansid=260415 then '01' when ansid=260417 then '0' when ansid=260419 then '300' when ansid=260421 then '3' when ansid=260423 then '05' when ansid=260424 then '05' when ansid=260425 then '365' when ansid=260426 then '75'  when ansid=260427 then ''   when ansid=260428 then '1'  when ansid=260429 then '1'  when ansid=260430 then ''   when ansid=260431 then '1'   when ansid=260432 then ''   when ansid=260433 then '1'  when ansid=260434 then '18' when ansid=260435 then '1' when ansid=260436 then '1'  when ansid=260437 then 'Counselor'   when ansid=260438 then '1'   when ansid=260439 then ''   when ansid=260440 then '1'  when ansid=260441 then '1'  when ansid=260442 then ''   when ansid=260443 then '1'  when ansid=260444 then '1' when ansid=260445 then '1' when ansid=260446 then '1' when ansid=260447 then '1' when ansid=260448 then '1' when ansid=260449 then '2' when ansid=260450 then '1' when ansid=260451 then '1' when ansid=260452 then '1'  when ansid=260453 then ''   when ansid=260454 then '3'   when ansid=260455 then 'Thermocol box with ice pack'   when ansid=260456 then '2'  when ansid=260457 then '1' when ansid=260458 then '2'  when ansid=260459 then ''   when ansid=260460 then '1'  when ansid=260461 then '2' when ansid=260462 then '1' when ansid=260463 then '1' when ansid=260464 then '1' when ansid=260465 then '0' when ansid=260466 then 'No specific problem regarding transportation of samples or other logistic supply' when ansid=260467 then 'No visit during this HSS round. Last visit on 21\/01\/2019 by SACS. No specific issues for action was mentioned.' when ansid=260468 then '1. ANC clinic and HSS clinic (for counseling and sample collection) in different floors of the same building, though consecutive sampling in recruitment is ensured.2. Consent taking process not appropriate. The actual consent form to be used and to be explained more elaborately. The process discussed with the counselor and also shown.3. All columns of the register to be filled up - for example, for yes\/no, either yes or no to be filled up in each cell. Shown to the counselor and corrected all missing enties.4. Blood sample collection= processing: Actually two aliquots are prepared - for HSS and PPTCT. Routine tests are done in separate days in pathology dept per hospital local practice. Shared with the superintendent. 5. Samples are transported in appropriate transportation box but using thermocol box. Vaccine carrier top be used, whic is available in the hospital.6. BMW management: Certain wrong practices\/limitations: a. Incorrect preparation of 1% hypochlorite solution - shown hot to prepare with corect dilution.b. Incorrect segregation of wastes - cotton swab placed in yellow bag etc c. Incorrect use of hub cutter- shown to use correctly d. Blue coloured cardboard box to be made available.' when ansid=260469 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.102.116.173',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-02 22:04:11'\r\n\t\t\t\t\t\t\tWHERE ansid in ('260364','260365','260366','260367','260368','260369','260370','260470','260471','260413','260415','260417','260419','260421','260423','260424','260425','260426','260427','260428','260429','260430','260431','260432','260433','260434','260435','260436','260437','260438','260439','260440','260441','260442','260443','260444','260445','260446','260447','260448','260449','260450','260451','260452','260453','260454','260455','260456','260457','260458','260459','260460','260461','260462','260463','260464','260465','260466','260467','260468','260469')"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE supvisstepid = '13591'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE visitfeedback SET `feedback` = 'Improper consent taking process by the counselor - shown how to improve and also to use the recommended consent form.', `recommendation` = 'Three aliquots to be prepared - for routine tests sample to be accepted on the same day, rather than in a separate day. The issue has also been discussed with the hospital superintendent.', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE visitfeedbackid = '13551'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE visitfeedback SET `feedback` = 'Incorrect preparation of hypochlorite solution- proper dilution immediately shown and corrected.', `recommendation` = 'Blue coloured cardboard box to be supplied.', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE visitfeedbackid = '13552'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE visitfeedback SET `feedback` = 'Wrong practices regarding BMW management - corrected immediately ( cotton swab to be placed in yellow bag, use of black bag, correct use of hub cutter).', `recommendation` = 'For tracing the positvies for linking to services, in the ANC register contact details to be recorded, whic is lacking. Discussed with the concerned personnel.', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE visitfeedbackid = '13553'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = 'For transport of samples- vaccine carrier to be used.', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE visitfeedbackid = '13554'"}
{"userId":"660","date":"2023-02-02 22:04:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.102.116.173', `modifiedby` = '660', `modifieddate` = '2023-02-02 22:04:11' WHERE visitfeedbackid = '13555'"}