{"userId":"575","date":"2023-03-16 11:42:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.70', '2023-03-16 11:42:24')"}
{"userId":"575","date":"2023-03-16 12:34:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.70', '2023-03-16 12:34:40')"}
{"userId":"575","date":"2023-03-16 12:35:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.70', '2023-03-16 12:35:07')"}
{"userId":"575","date":"2023-03-16 12:36:57","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('908', '2023-02-03', '575', '110.235.232.70', '575', '2023-03-16 12:36:57')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('908', '3287', '575', '2023-03-16', '1', '110.235.232.70', '575', '2023-03-16 12:37:02', '', '')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2824', '0', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2824', '1', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2824', '2', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2824', '3', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2824', '4', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2824', '', '', 'Array', '', 'Array', '', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2824', '', '', 'Array', '', 'Array', '', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2824', '', '', 'Array', '', 'Array', '', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2824', '', '', 'Array', '', 'Array', '', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:37:02","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2824', '110.235.232.70', '575', '2023-03-16 12:37:02')"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE sitesupervision SET `siteid` = '908', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-16', `numofsamplecollected` = '165', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2824'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Tejas', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE onssid = '11624'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Arshiya Nag', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE onssid = '11625'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Merry', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE onssid = '11626'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE onssid = '11627'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=267674 then '' when ansid=267675 then '' when ansid=267676 then '' when ansid=267677 then '' when ansid=267678 then ''  when ansid=267679 then ''   when ansid=267680 then ''  when ansid=267780 then '' when ansid=267781 then '' when ansid=267723 then '' when ansid=267725 then '' when ansid=267727 then '' when ansid=267729 then '' when ansid=267731 then '' when ansid=267733 then '' when ansid=267734 then '' when ansid=267735 then '' when ansid=267736 then ''  when ansid=267737 then ''   when ansid=267738 then ''  when ansid=267739 then ''  when ansid=267740 then ''   when ansid=267741 then ''   when ansid=267742 then ''   when ansid=267743 then ''  when ansid=267744 then '' when ansid=267745 then '' when ansid=267746 then ''  when ansid=267747 then ''   when ansid=267748 then ''   when ansid=267749 then ''   when ansid=267750 then ''  when ansid=267751 then ''  when ansid=267752 then ''   when ansid=267753 then ''  when ansid=267754 then '' when ansid=267755 then '' when ansid=267756 then '' when ansid=267757 then '' when ansid=267758 then '' when ansid=267759 then '' when ansid=267760 then '' when ansid=267761 then '' when ansid=267762 then ''  when ansid=267763 then ''   when ansid=267764 then ''   when ansid=267765 then ''   when ansid=267766 then ''  when ansid=267767 then '' when ansid=267768 then ''  when ansid=267769 then ''   when ansid=267770 then ''  when ansid=267771 then '' when ansid=267772 then '' when ansid=267773 then '' when ansid=267774 then '' when ansid=267775 then '' when ansid=267776 then '' when ansid=267777 then '' when ansid=267778 then '' when ansid=267779 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.70',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-16 12:39:22'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267674','267675','267676','267677','267678','267679','267680','267780','267781','267723','267725','267727','267729','267731','267733','267734','267735','267736','267737','267738','267739','267740','267741','267742','267743','267744','267745','267746','267747','267748','267749','267750','267751','267752','267753','267754','267755','267756','267757','267758','267759','267760','267761','267762','267763','267764','267765','267766','267767','267768','267769','267770','267771','267772','267773','267774','267775','267776','267777','267778','267779')"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE supvisstepid = '13920'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE visitfeedbackid = '13896'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE visitfeedbackid = '13897'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE visitfeedbackid = '13898'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE visitfeedbackid = '13899'"}
{"userId":"575","date":"2023-03-16 12:39:22","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:39:22' WHERE visitfeedbackid = '13900'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE sitesupervision SET `siteid` = '908', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-16', `numofsamplecollected` = '165', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2824'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Tejas', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE onssid = '11624'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Arshiya Nag', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE onssid = '11625'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Merry', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE onssid = '11626'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE onssid = '11627'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=267674 then '1' when ansid=267675 then '1' when ansid=267676 then '1' when ansid=267677 then '' when ansid=267678 then ''  when ansid=267679 then '500'   when ansid=267680 then '1'  when ansid=267780 then '1' when ansid=267781 then '1' when ansid=267723 then '' when ansid=267725 then '' when ansid=267727 then '' when ansid=267729 then '' when ansid=267731 then '' when ansid=267733 then '' when ansid=267734 then '' when ansid=267735 then '' when ansid=267736 then ''  when ansid=267737 then ''   when ansid=267738 then ''  when ansid=267739 then ''  when ansid=267740 then ''   when ansid=267741 then ''   when ansid=267742 then ''   when ansid=267743 then ''  when ansid=267744 then '' when ansid=267745 then '' when ansid=267746 then ''  when ansid=267747 then ''   when ansid=267748 then ''   when ansid=267749 then ''   when ansid=267750 then ''  when ansid=267751 then ''  when ansid=267752 then ''   when ansid=267753 then ''  when ansid=267754 then '' when ansid=267755 then '' when ansid=267756 then '' when ansid=267757 then '' when ansid=267758 then '' when ansid=267759 then '' when ansid=267760 then '' when ansid=267761 then '' when ansid=267762 then ''  when ansid=267763 then ''   when ansid=267764 then ''   when ansid=267765 then ''   when ansid=267766 then ''  when ansid=267767 then '' when ansid=267768 then ''  when ansid=267769 then ''   when ansid=267770 then ''  when ansid=267771 then '' when ansid=267772 then '' when ansid=267773 then '' when ansid=267774 then '' when ansid=267775 then '' when ansid=267776 then '' when ansid=267777 then '' when ansid=267778 then '' when ansid=267779 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.70',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-16 12:40:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267674','267675','267676','267677','267678','267679','267680','267780','267781','267723','267725','267727','267729','267731','267733','267734','267735','267736','267737','267738','267739','267740','267741','267742','267743','267744','267745','267746','267747','267748','267749','267750','267751','267752','267753','267754','267755','267756','267757','267758','267759','267760','267761','267762','267763','267764','267765','267766','267767','267768','267769','267770','267771','267772','267773','267774','267775','267776','267777','267778','267779')"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE supvisstepid = '13921'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE visitfeedbackid = '13896'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE visitfeedbackid = '13897'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE visitfeedbackid = '13898'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE visitfeedbackid = '13899'"}
{"userId":"575","date":"2023-03-16 12:40:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:42' WHERE visitfeedbackid = '13900'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE sitesupervision SET `siteid` = '908', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-16', `numofsamplecollected` = '165', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2824'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Tejas', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE onssid = '11624'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Arshiya Nag', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE onssid = '11625'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Merry', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE onssid = '11626'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE onssid = '11627'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=267674 then '1' when ansid=267675 then '1' when ansid=267676 then '1' when ansid=267677 then '' when ansid=267678 then ''  when ansid=267679 then '500'   when ansid=267680 then '1'  when ansid=267780 then '1' when ansid=267781 then '1' when ansid=267723 then '1' when ansid=267725 then '1' when ansid=267727 then '1' when ansid=267729 then '1' when ansid=267731 then '1' when ansid=267733 then '' when ansid=267734 then '' when ansid=267735 then '' when ansid=267736 then ''  when ansid=267737 then ''   when ansid=267738 then ''  when ansid=267739 then ''  when ansid=267740 then ''   when ansid=267741 then ''   when ansid=267742 then ''   when ansid=267743 then ''  when ansid=267744 then '' when ansid=267745 then '' when ansid=267746 then ''  when ansid=267747 then ''   when ansid=267748 then ''   when ansid=267749 then ''   when ansid=267750 then ''  when ansid=267751 then ''  when ansid=267752 then ''   when ansid=267753 then ''  when ansid=267754 then '' when ansid=267755 then '' when ansid=267756 then '' when ansid=267757 then '' when ansid=267758 then '' when ansid=267759 then '' when ansid=267760 then '' when ansid=267761 then '' when ansid=267762 then ''  when ansid=267763 then ''   when ansid=267764 then ''   when ansid=267765 then ''   when ansid=267766 then ''  when ansid=267767 then '' when ansid=267768 then ''  when ansid=267769 then ''   when ansid=267770 then ''  when ansid=267771 then '' when ansid=267772 then '' when ansid=267773 then '' when ansid=267774 then '' when ansid=267775 then '' when ansid=267776 then '' when ansid=267777 then '' when ansid=267778 then '' when ansid=267779 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.70',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-16 12:40:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267674','267675','267676','267677','267678','267679','267680','267780','267781','267723','267725','267727','267729','267731','267733','267734','267735','267736','267737','267738','267739','267740','267741','267742','267743','267744','267745','267746','267747','267748','267749','267750','267751','267752','267753','267754','267755','267756','267757','267758','267759','267760','267761','267762','267763','267764','267765','267766','267767','267768','267769','267770','267771','267772','267773','267774','267775','267776','267777','267778','267779')"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE supvisstepid = '13922'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE visitfeedbackid = '13896'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE visitfeedbackid = '13897'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE visitfeedbackid = '13898'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE visitfeedbackid = '13899'"}
{"userId":"575","date":"2023-03-16 12:40:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:40:59' WHERE visitfeedbackid = '13900'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE sitesupervision SET `siteid` = '908', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-16', `numofsamplecollected` = '165', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2824'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Tejas', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE onssid = '11624'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Arshiya Nag', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE onssid = '11625'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Merry', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE onssid = '11626'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE onssid = '11627'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=267674 then '1' when ansid=267675 then '1' when ansid=267676 then '1' when ansid=267677 then '' when ansid=267678 then ''  when ansid=267679 then '500'   when ansid=267680 then '1'  when ansid=267780 then '1' when ansid=267781 then '1' when ansid=267723 then '1' when ansid=267725 then '1' when ansid=267727 then '1' when ansid=267729 then '1' when ansid=267731 then '1' when ansid=267733 then '2' when ansid=267734 then '2' when ansid=267735 then '1500' when ansid=267736 then '150'  when ansid=267737 then ''   when ansid=267738 then '1'  when ansid=267739 then '1'  when ansid=267740 then ''   when ansid=267741 then '1'   when ansid=267742 then ''   when ansid=267743 then '1'  when ansid=267744 then '10' when ansid=267745 then '1' when ansid=267746 then '1'  when ansid=267747 then 'counselor'   when ansid=267748 then '1'   when ansid=267749 then ''   when ansid=267750 then '1'  when ansid=267751 then '1'  when ansid=267752 then ''   when ansid=267753 then '1'  when ansid=267754 then '1' when ansid=267755 then '1' when ansid=267756 then '1' when ansid=267757 then '1' when ansid=267758 then '1' when ansid=267759 then '1' when ansid=267760 then '1' when ansid=267761 then '1' when ansid=267762 then '1'  when ansid=267763 then ''   when ansid=267764 then '3'   when ansid=267765 then ''   when ansid=267766 then '1'  when ansid=267767 then '1' when ansid=267768 then '1'  when ansid=267769 then ''   when ansid=267770 then '1'  when ansid=267771 then '1' when ansid=267772 then '1' when ansid=267773 then '1' when ansid=267774 then '1' when ansid=267775 then '0' when ansid=267776 then 'None' when ansid=267777 then 'None' when ansid=267778 then 'No Major problem identified' when ansid=267779 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.70',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-16 12:47:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267674','267675','267676','267677','267678','267679','267680','267780','267781','267723','267725','267727','267729','267731','267733','267734','267735','267736','267737','267738','267739','267740','267741','267742','267743','267744','267745','267746','267747','267748','267749','267750','267751','267752','267753','267754','267755','267756','267757','267758','267759','267760','267761','267762','267763','267764','267765','267766','267767','267768','267769','267770','267771','267772','267773','267774','267775','267776','267777','267778','267779')"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE supvisstepid = '13923'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE visitfeedbackid = '13896'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE visitfeedbackid = '13897'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE visitfeedbackid = '13898'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE visitfeedbackid = '13899'"}
{"userId":"575","date":"2023-03-16 12:47:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:47:28' WHERE visitfeedbackid = '13900'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE sitesupervision SET `siteid` = '908', `userid` = '575', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-03-16', `numofsamplecollected` = '165', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04', `locationtype` = '1', `establishmentyear` = '2000', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2824'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Tejas', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE onssid = '11624'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Arshiya Nag', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE onssid = '11625'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Merry', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE onssid = '11626'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE onssid = '11627'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=267674 then '1' when ansid=267675 then '1' when ansid=267676 then '1' when ansid=267677 then '' when ansid=267678 then ''  when ansid=267679 then '500'   when ansid=267680 then '1'  when ansid=267780 then '1' when ansid=267781 then '1' when ansid=267723 then '1' when ansid=267725 then '1' when ansid=267727 then '1' when ansid=267729 then '1' when ansid=267731 then '1' when ansid=267733 then '2' when ansid=267734 then '2' when ansid=267735 then '1500' when ansid=267736 then '150'  when ansid=267737 then ''   when ansid=267738 then '1'  when ansid=267739 then '1'  when ansid=267740 then ''   when ansid=267741 then '1'   when ansid=267742 then ''   when ansid=267743 then '1'  when ansid=267744 then '10' when ansid=267745 then '1' when ansid=267746 then '1'  when ansid=267747 then 'counselor'   when ansid=267748 then '1'   when ansid=267749 then ''   when ansid=267750 then '1'  when ansid=267751 then '1'  when ansid=267752 then ''   when ansid=267753 then '1'  when ansid=267754 then '1' when ansid=267755 then '1' when ansid=267756 then '1' when ansid=267757 then '1' when ansid=267758 then '1' when ansid=267759 then '1' when ansid=267760 then '1' when ansid=267761 then '1' when ansid=267762 then '1'  when ansid=267763 then ''   when ansid=267764 then '3'   when ansid=267765 then ''   when ansid=267766 then '1'  when ansid=267767 then '1' when ansid=267768 then '1'  when ansid=267769 then ''   when ansid=267770 then '1'  when ansid=267771 then '1' when ansid=267772 then '1' when ansid=267773 then '1' when ansid=267774 then '1' when ansid=267775 then '0' when ansid=267776 then 'None' when ansid=267777 then 'None' when ansid=267778 then 'No Major problem identified' when ansid=267779 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.70',\r\n\t\t\t\t\t\t\t\tmodifiedby =575,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-03-16 12:50:04'\r\n\t\t\t\t\t\t\tWHERE ansid in ('267674','267675','267676','267677','267678','267679','267680','267780','267781','267723','267725','267727','267729','267731','267733','267734','267735','267736','267737','267738','267739','267740','267741','267742','267743','267744','267745','267746','267747','267748','267749','267750','267751','267752','267753','267754','267755','267756','267757','267758','267759','267760','267761','267762','267763','267764','267765','267766','267767','267768','267769','267770','267771','267772','267773','267774','267775','267776','267777','267778','267779')"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE supvisstepid = '13924'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE visitfeedbackid = '13896'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE visitfeedbackid = '13897'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE visitfeedbackid = '13898'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE visitfeedbackid = '13899'"}
{"userId":"575","date":"2023-03-16 12:50:04","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.70', `modifiedby` = '575', `modifieddate` = '2023-03-16 12:50:04' WHERE visitfeedbackid = '13900'"}
{"userId":"681","date":"2023-03-16 14:43:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '110.235.232.70', '2023-03-16 14:43:06')"}
{"userId":"56","date":"2023-03-16 14:44:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('56', '110.235.232.70', '2023-03-16 14:44:33')"}
{"userId":"575","date":"2023-03-16 14:51:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.70', '2023-03-16 14:51:53')"}