{"userId":"680","date":"2023-02-11 10:18:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '14.139.218.146', '2023-02-11 10:18:27')"}
{"userId":"681","date":"2023-02-11 10:50:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '103.47.35.43', '2023-02-11 10:50:15')"}
{"userId":"574","date":"2023-02-11 10:50:41","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.37', '2023-02-11 10:50:41')"}
{"userId":"574","date":"2023-02-11 10:51:29","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('189', '2023-02-10', '574', '110.235.232.37', '574', '2023-02-11 10:51:29')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('189', '3253', '574', '2023-02-11', '1', '110.235.232.37', '574', '2023-02-11 10:51:32', '', '')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2786', '0', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2786', '1', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2786', '2', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2786', '3', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2786', '4', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2786', '', '', 'Array', '', 'Array', '', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2786', '', '', 'Array', '', 'Array', '', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2786', '', '', 'Array', '', 'Array', '', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2786', '', '', 'Array', '', 'Array', '', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:51:32","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2786', '110.235.232.37', '574', '2023-02-11 10:51:32')"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE sitesupervision SET `siteid` = '189', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '175', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2786'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shivani', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '04', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE onssid = '11472'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE onsitestaffs SET `staffname` = 'Nisha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE onssid = '11473'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE onsitestaffs SET `staffname` = 'Sushil', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE onssid = '11474'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE onssid = '11475'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=263653 then '' when ansid=263654 then '' when ansid=263655 then '' when ansid=263656 then '' when ansid=263657 then ''  when ansid=263658 then ''   when ansid=263659 then ''  when ansid=263759 then '' when ansid=263760 then '' when ansid=263702 then '' when ansid=263704 then '' when ansid=263706 then '' when ansid=263708 then '' when ansid=263710 then '' when ansid=263712 then '' when ansid=263713 then '' when ansid=263714 then '' when ansid=263715 then ''  when ansid=263716 then ''   when ansid=263717 then ''  when ansid=263718 then ''  when ansid=263719 then ''   when ansid=263720 then ''   when ansid=263721 then ''   when ansid=263722 then ''  when ansid=263723 then '' when ansid=263724 then '' when ansid=263725 then ''  when ansid=263726 then ''   when ansid=263727 then ''   when ansid=263728 then ''   when ansid=263729 then ''  when ansid=263730 then ''  when ansid=263731 then ''   when ansid=263732 then ''  when ansid=263733 then '' when ansid=263734 then '' when ansid=263735 then '' when ansid=263736 then '' when ansid=263737 then '' when ansid=263738 then '' when ansid=263739 then '' when ansid=263740 then '' when ansid=263741 then ''  when ansid=263742 then ''   when ansid=263743 then ''   when ansid=263744 then ''   when ansid=263745 then ''  when ansid=263746 then '' when ansid=263747 then ''  when ansid=263748 then ''   when ansid=263749 then ''  when ansid=263750 then '' when ansid=263751 then '' when ansid=263752 then '' when ansid=263753 then '' when ansid=263754 then '' when ansid=263755 then '' when ansid=263756 then '' when ansid=263757 then '' when ansid=263758 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.37',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-11 10:53:28'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263653','263654','263655','263656','263657','263658','263659','263759','263760','263702','263704','263706','263708','263710','263712','263713','263714','263715','263716','263717','263718','263719','263720','263721','263722','263723','263724','263725','263726','263727','263728','263729','263730','263731','263732','263733','263734','263735','263736','263737','263738','263739','263740','263741','263742','263743','263744','263745','263746','263747','263748','263749','263750','263751','263752','263753','263754','263755','263756','263757','263758')"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE supvisstepid = '13736'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE visitfeedbackid = '13706'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE visitfeedbackid = '13707'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE visitfeedbackid = '13708'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE visitfeedbackid = '13709'"}
{"userId":"574","date":"2023-02-11 10:53:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:53:28' WHERE visitfeedbackid = '13710'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE sitesupervision SET `siteid` = '189', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '175', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2786'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shivani', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '04', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE onssid = '11472'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE onsitestaffs SET `staffname` = 'Nisha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE onssid = '11473'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE onsitestaffs SET `staffname` = 'Sushil', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE onssid = '11474'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE onssid = '11475'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=263653 then '1' when ansid=263654 then '1' when ansid=263655 then '1' when ansid=263656 then '' when ansid=263657 then ''  when ansid=263658 then '504'   when ansid=263659 then '1'  when ansid=263759 then '1' when ansid=263760 then '1' when ansid=263702 then '' when ansid=263704 then '' when ansid=263706 then '' when ansid=263708 then '' when ansid=263710 then '' when ansid=263712 then '' when ansid=263713 then '' when ansid=263714 then '' when ansid=263715 then ''  when ansid=263716 then ''   when ansid=263717 then ''  when ansid=263718 then ''  when ansid=263719 then ''   when ansid=263720 then ''   when ansid=263721 then ''   when ansid=263722 then ''  when ansid=263723 then '' when ansid=263724 then '' when ansid=263725 then ''  when ansid=263726 then ''   when ansid=263727 then ''   when ansid=263728 then ''   when ansid=263729 then ''  when ansid=263730 then ''  when ansid=263731 then ''   when ansid=263732 then ''  when ansid=263733 then '' when ansid=263734 then '' when ansid=263735 then '' when ansid=263736 then '' when ansid=263737 then '' when ansid=263738 then '' when ansid=263739 then '' when ansid=263740 then '' when ansid=263741 then ''  when ansid=263742 then ''   when ansid=263743 then ''   when ansid=263744 then ''   when ansid=263745 then ''  when ansid=263746 then '' when ansid=263747 then ''  when ansid=263748 then ''   when ansid=263749 then ''  when ansid=263750 then '' when ansid=263751 then '' when ansid=263752 then '' when ansid=263753 then '' when ansid=263754 then '' when ansid=263755 then '' when ansid=263756 then '' when ansid=263757 then '' when ansid=263758 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.37',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-11 10:54:01'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263653','263654','263655','263656','263657','263658','263659','263759','263760','263702','263704','263706','263708','263710','263712','263713','263714','263715','263716','263717','263718','263719','263720','263721','263722','263723','263724','263725','263726','263727','263728','263729','263730','263731','263732','263733','263734','263735','263736','263737','263738','263739','263740','263741','263742','263743','263744','263745','263746','263747','263748','263749','263750','263751','263752','263753','263754','263755','263756','263757','263758')"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE supvisstepid = '13737'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE visitfeedbackid = '13706'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE visitfeedbackid = '13707'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE visitfeedbackid = '13708'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE visitfeedbackid = '13709'"}
{"userId":"574","date":"2023-02-11 10:54:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:01' WHERE visitfeedbackid = '13710'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE sitesupervision SET `siteid` = '189', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '175', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2786'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shivani', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '04', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE onssid = '11472'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Nisha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE onssid = '11473'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE onsitestaffs SET `staffname` = 'Sushil', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE onssid = '11474'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE onssid = '11475'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=263653 then '1' when ansid=263654 then '1' when ansid=263655 then '1' when ansid=263656 then '' when ansid=263657 then ''  when ansid=263658 then '504'   when ansid=263659 then '1'  when ansid=263759 then '1' when ansid=263760 then '1' when ansid=263702 then '0' when ansid=263704 then '1' when ansid=263706 then '0' when ansid=263708 then '3' when ansid=263710 then '1' when ansid=263712 then '' when ansid=263713 then '' when ansid=263714 then '' when ansid=263715 then ''  when ansid=263716 then ''   when ansid=263717 then ''  when ansid=263718 then ''  when ansid=263719 then ''   when ansid=263720 then ''   when ansid=263721 then ''   when ansid=263722 then ''  when ansid=263723 then '' when ansid=263724 then '' when ansid=263725 then ''  when ansid=263726 then ''   when ansid=263727 then ''   when ansid=263728 then ''   when ansid=263729 then ''  when ansid=263730 then ''  when ansid=263731 then ''   when ansid=263732 then ''  when ansid=263733 then '' when ansid=263734 then '' when ansid=263735 then '' when ansid=263736 then '' when ansid=263737 then '' when ansid=263738 then '' when ansid=263739 then '' when ansid=263740 then '' when ansid=263741 then ''  when ansid=263742 then ''   when ansid=263743 then ''   when ansid=263744 then ''   when ansid=263745 then ''  when ansid=263746 then '' when ansid=263747 then ''  when ansid=263748 then ''   when ansid=263749 then ''  when ansid=263750 then '' when ansid=263751 then '' when ansid=263752 then '' when ansid=263753 then '' when ansid=263754 then '' when ansid=263755 then '' when ansid=263756 then '' when ansid=263757 then '' when ansid=263758 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.37',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-11 10:54:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263653','263654','263655','263656','263657','263658','263659','263759','263760','263702','263704','263706','263708','263710','263712','263713','263714','263715','263716','263717','263718','263719','263720','263721','263722','263723','263724','263725','263726','263727','263728','263729','263730','263731','263732','263733','263734','263735','263736','263737','263738','263739','263740','263741','263742','263743','263744','263745','263746','263747','263748','263749','263750','263751','263752','263753','263754','263755','263756','263757','263758')"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE supvisstepid = '13738'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE visitfeedbackid = '13706'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE visitfeedbackid = '13707'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE visitfeedbackid = '13708'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE visitfeedbackid = '13709'"}
{"userId":"574","date":"2023-02-11 10:54:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:54:24' WHERE visitfeedbackid = '13710'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE sitesupervision SET `siteid` = '189', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '175', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2786'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shivani', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '04', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE onssid = '11472'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE onsitestaffs SET `staffname` = 'Nisha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE onssid = '11473'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE onsitestaffs SET `staffname` = 'Sushil', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE onssid = '11474'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE onssid = '11475'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=263653 then '1' when ansid=263654 then '1' when ansid=263655 then '1' when ansid=263656 then '' when ansid=263657 then ''  when ansid=263658 then '504'   when ansid=263659 then '1'  when ansid=263759 then '1' when ansid=263760 then '1' when ansid=263702 then '0' when ansid=263704 then '1' when ansid=263706 then '0' when ansid=263708 then '3' when ansid=263710 then '1' when ansid=263712 then '3' when ansid=263713 then '0' when ansid=263714 then '922' when ansid=263715 then '200'  when ansid=263716 then ''   when ansid=263717 then '1'  when ansid=263718 then '1'  when ansid=263719 then ''   when ansid=263720 then '1'   when ansid=263721 then ''   when ansid=263722 then '1'  when ansid=263723 then '10' when ansid=263724 then '1' when ansid=263725 then '1'  when ansid=263726 then 'counsellor'   when ansid=263727 then '1'   when ansid=263728 then ''   when ansid=263729 then '1'  when ansid=263730 then '1'  when ansid=263731 then ''   when ansid=263732 then '1'  when ansid=263733 then '4' when ansid=263734 then '1' when ansid=263735 then '1' when ansid=263736 then '1' when ansid=263737 then '1' when ansid=263738 then '2' when ansid=263739 then '1' when ansid=263740 then '1' when ansid=263741 then '1'  when ansid=263742 then ''   when ansid=263743 then '3'   when ansid=263744 then ''   when ansid=263745 then '1'  when ansid=263746 then '1' when ansid=263747 then '1'  when ansid=263748 then ''   when ansid=263749 then '1'  when ansid=263750 then '1' when ansid=263751 then '1' when ansid=263752 then '1' when ansid=263753 then '1' when ansid=263754 then '0' when ansid=263755 then 'none' when ansid=263756 then 'none' when ansid=263757 then 'site is functioning satisfactorily..' when ansid=263758 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.37',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-11 10:58:46'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263653','263654','263655','263656','263657','263658','263659','263759','263760','263702','263704','263706','263708','263710','263712','263713','263714','263715','263716','263717','263718','263719','263720','263721','263722','263723','263724','263725','263726','263727','263728','263729','263730','263731','263732','263733','263734','263735','263736','263737','263738','263739','263740','263741','263742','263743','263744','263745','263746','263747','263748','263749','263750','263751','263752','263753','263754','263755','263756','263757','263758')"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE supvisstepid = '13739'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE visitfeedbackid = '13706'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE visitfeedbackid = '13707'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE visitfeedbackid = '13708'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE visitfeedbackid = '13709'"}
{"userId":"574","date":"2023-02-11 10:58:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:46' WHERE visitfeedbackid = '13710'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE sitesupervision SET `siteid` = '189', `userid` = '574', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-11', `numofsamplecollected` = '175', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54', `locationtype` = '1', `establishmentyear` = '2017', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2786'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Shivani', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '04', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE onssid = '11472'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE onsitestaffs SET `staffname` = 'Nisha', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE onssid = '11473'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE onsitestaffs SET `staffname` = 'Sushil', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '1', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE onssid = '11474'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE onssid = '11475'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=263653 then '1' when ansid=263654 then '1' when ansid=263655 then '1' when ansid=263656 then '' when ansid=263657 then ''  when ansid=263658 then '504'   when ansid=263659 then '1'  when ansid=263759 then '1' when ansid=263760 then '1' when ansid=263702 then '0' when ansid=263704 then '1' when ansid=263706 then '0' when ansid=263708 then '3' when ansid=263710 then '1' when ansid=263712 then '3' when ansid=263713 then '0' when ansid=263714 then '922' when ansid=263715 then '200'  when ansid=263716 then ''   when ansid=263717 then '1'  when ansid=263718 then '1'  when ansid=263719 then ''   when ansid=263720 then '1'   when ansid=263721 then ''   when ansid=263722 then '1'  when ansid=263723 then '10' when ansid=263724 then '1' when ansid=263725 then '1'  when ansid=263726 then 'counsellor'   when ansid=263727 then '1'   when ansid=263728 then ''   when ansid=263729 then '1'  when ansid=263730 then '1'  when ansid=263731 then ''   when ansid=263732 then '1'  when ansid=263733 then '4' when ansid=263734 then '1' when ansid=263735 then '1' when ansid=263736 then '1' when ansid=263737 then '1' when ansid=263738 then '2' when ansid=263739 then '1' when ansid=263740 then '1' when ansid=263741 then '1'  when ansid=263742 then ''   when ansid=263743 then '3'   when ansid=263744 then ''   when ansid=263745 then '1'  when ansid=263746 then '1' when ansid=263747 then '1'  when ansid=263748 then ''   when ansid=263749 then '1'  when ansid=263750 then '1' when ansid=263751 then '1' when ansid=263752 then '1' when ansid=263753 then '1' when ansid=263754 then '0' when ansid=263755 then 'none' when ansid=263756 then 'none' when ansid=263757 then 'site is functioning satisfactorily..' when ansid=263758 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '110.235.232.37',\r\n\t\t\t\t\t\t\t\tmodifiedby =574,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-11 10:58:54'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263653','263654','263655','263656','263657','263658','263659','263759','263760','263702','263704','263706','263708','263710','263712','263713','263714','263715','263716','263717','263718','263719','263720','263721','263722','263723','263724','263725','263726','263727','263728','263729','263730','263731','263732','263733','263734','263735','263736','263737','263738','263739','263740','263741','263742','263743','263744','263745','263746','263747','263748','263749','263750','263751','263752','263753','263754','263755','263756','263757','263758')"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE supvisstepid = '13740'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE visitfeedbackid = '13706'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE visitfeedbackid = '13707'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE visitfeedbackid = '13708'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE visitfeedbackid = '13709'"}
{"userId":"574","date":"2023-02-11 10:58:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.37', `modifiedby` = '574', `modifieddate` = '2023-02-11 10:58:54' WHERE visitfeedbackid = '13710'"}
{"userId":"681","date":"2023-02-11 11:03:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('681', '103.47.35.43', '2023-02-11 11:03:32')"}
{"userId":"521","date":"2023-02-11 11:05:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-11 11:05:23')"}
{"userId":"521","date":"2023-02-11 11:34:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-11 11:34:36')"}
{"userId":"521","date":"2023-02-11 11:36:02","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-11 11:36:02')"}
{"userId":"574","date":"2023-02-11 11:37:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.37', '2023-02-11 11:37:16')"}
{"userId":"575","date":"2023-02-11 11:37:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.37', '2023-02-11 11:37:56')"}
{"userId":"680","date":"2023-02-11 11:46:03","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '110.235.232.37', '2023-02-11 11:46:03')"}
{"userId":"574","date":"2023-02-11 11:47:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.37', '2023-02-11 11:47:13')"}
{"userId":"521","date":"2023-02-11 12:27:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-02-11 12:27:58')"}