{"userId":"660","date":"2023-01-26 08:44:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 08:44:29')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('423', '3140', '660', '2023-01-26', '1', '202.78.236.43', '660', '2023-01-26 08:47:16', '', '')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2718', '0', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2718', '1', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2718', '2', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2718', '3', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2718', '4', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2718', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2718', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2718', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2718', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:47:16","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2718', '202.78.236.43', '660', '2023-01-26 08:47:16')"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE sitesupervision SET `siteid` = '423', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '116', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2718'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sunil Kumar Mondal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE onssid = '11200'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'Soma Mukherjee', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE onssid = '11201'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE onsitestaffs SET `staffname` = 'Abhijit Mukherjee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE onssid = '11202'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE onssid = '11203'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256382 then '' when ansid=256383 then '' when ansid=256384 then '' when ansid=256385 then '' when ansid=256386 then '' when ansid=256387 then '' when ansid=256388 then '' when ansid=256488 then '' when ansid=256489 then '' when ansid=256431 then '' when ansid=256433 then '' when ansid=256435 then '' when ansid=256437 then '' when ansid=256439 then '' when ansid=256441 then '' when ansid=256442 then '' when ansid=256443 then '' when ansid=256444 then '' when ansid=256445 then '' when ansid=256446 then '' when ansid=256447 then '' when ansid=256448 then '' when ansid=256449 then '' when ansid=256450 then '' when ansid=256451 then '' when ansid=256452 then '' when ansid=256453 then '' when ansid=256454 then '' when ansid=256455 then '' when ansid=256456 then '' when ansid=256457 then '' when ansid=256458 then '' when ansid=256459 then '' when ansid=256460 then '' when ansid=256461 then '' when ansid=256462 then '' when ansid=256463 then '' when ansid=256464 then '' when ansid=256465 then '' when ansid=256466 then '' when ansid=256467 then '' when ansid=256468 then '' when ansid=256469 then '' when ansid=256470 then '' when ansid=256471 then '' when ansid=256472 then '' when ansid=256473 then '' when ansid=256474 then '' when ansid=256475 then '' when ansid=256476 then '' when ansid=256477 then '' when ansid=256478 then '' when ansid=256479 then '' when ansid=256480 then '' when ansid=256481 then '' when ansid=256482 then '' when ansid=256483 then '' when ansid=256484 then '' when ansid=256485 then '' when ansid=256486 then '' when ansid=256487 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 08:53:13'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256382','256383','256384','256385','256386','256387','256388','256488','256489','256431','256433','256435','256437','256439','256441','256442','256443','256444','256445','256446','256447','256448','256449','256450','256451','256452','256453','256454','256455','256456','256457','256458','256459','256460','256461','256462','256463','256464','256465','256466','256467','256468','256469','256470','256471','256472','256473','256474','256475','256476','256477','256478','256479','256480','256481','256482','256483','256484','256485','256486','256487')"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE supvisstepid = '13408'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE visitfeedbackid = '13366'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE visitfeedbackid = '13367'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE visitfeedbackid = '13368'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE visitfeedbackid = '13369'"} {"userId":"660","date":"2023-01-26 08:53:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:53:13' WHERE visitfeedbackid = '13370'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE sitesupervision SET `siteid` = '423', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '116', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2718'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sunil Kumar Mondal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE onssid = '11200'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE onsitestaffs SET `staffname` = 'Soma Mukherjee', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE onssid = '11201'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE onsitestaffs SET `staffname` = 'Abhijit Mukherjee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE onssid = '11202'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE onssid = '11203'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256382 then '1' when ansid=256383 then '1' when ansid=256384 then '2' when ansid=256385 then '1' when ansid=256386 then '' when ansid=256387 then '105' when ansid=256388 then '1' when ansid=256488 then '1' when ansid=256489 then '1' when ansid=256431 then '' when ansid=256433 then '' when ansid=256435 then '' when ansid=256437 then '' when ansid=256439 then '' when ansid=256441 then '' when ansid=256442 then '' when ansid=256443 then '' when ansid=256444 then '' when ansid=256445 then '' when ansid=256446 then '' when ansid=256447 then '' when ansid=256448 then '' when ansid=256449 then '' when ansid=256450 then '' when ansid=256451 then '' when ansid=256452 then '' when ansid=256453 then '' when ansid=256454 then '' when ansid=256455 then '' when ansid=256456 then '' when ansid=256457 then '' when ansid=256458 then '' when ansid=256459 then '' when ansid=256460 then '' when ansid=256461 then '' when ansid=256462 then '' when ansid=256463 then '' when ansid=256464 then '' when ansid=256465 then '' when ansid=256466 then '' when ansid=256467 then '' when ansid=256468 then '' when ansid=256469 then '' when ansid=256470 then '' when ansid=256471 then '' when ansid=256472 then '' when ansid=256473 then '' when ansid=256474 then '' when ansid=256475 then '' when ansid=256476 then '' when ansid=256477 then '' when ansid=256478 then '' when ansid=256479 then '' when ansid=256480 then '' when ansid=256481 then '' when ansid=256482 then '' when ansid=256483 then '' when ansid=256484 then '' when ansid=256485 then '' when ansid=256486 then '' when ansid=256487 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 08:55:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256382','256383','256384','256385','256386','256387','256388','256488','256489','256431','256433','256435','256437','256439','256441','256442','256443','256444','256445','256446','256447','256448','256449','256450','256451','256452','256453','256454','256455','256456','256457','256458','256459','256460','256461','256462','256463','256464','256465','256466','256467','256468','256469','256470','256471','256472','256473','256474','256475','256476','256477','256478','256479','256480','256481','256482','256483','256484','256485','256486','256487')"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE supvisstepid = '13409'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE visitfeedbackid = '13366'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE visitfeedbackid = '13367'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE visitfeedbackid = '13368'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE visitfeedbackid = '13369'"} {"userId":"660","date":"2023-01-26 08:55:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 08:55:29' WHERE visitfeedbackid = '13370'"} {"userId":"660","date":"2023-01-26 10:36:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 10:36:48')"} {"userId":"660","date":"2023-01-26 10:48:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 10:48:21')"} {"userId":"660","date":"2023-01-26 10:53:10","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 10:53:10')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('429', '3141', '660', '2023-01-26', '1', '202.78.236.43', '660', '2023-01-26 10:54:18', '', '')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2719', '0', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2719', '1', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2719', '2', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2719', '3', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2719', '4', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2719', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2719', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2719', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2719', '', '', 'Array', '', 'Array', '', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 10:54:18","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2719', '202.78.236.43', '660', '2023-01-26 10:54:18')"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '' when ansid=256491 then '' when ansid=256492 then '' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '' when ansid=256496 then '' when ansid=256596 then '' when ansid=256597 then '' when ansid=256539 then '' when ansid=256541 then '' when ansid=256543 then '' when ansid=256545 then '' when ansid=256547 then '' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 11:00:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE supvisstepid = '13413'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 11:00:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:00:39' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '' when ansid=256541 then '' when ansid=256543 then '' when ansid=256545 then '' when ansid=256547 then '' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 11:01:49'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE supvisstepid = '13414'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 11:01:49","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:01:49' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '03', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '02' when ansid=256541 then '02' when ansid=256543 then '01' when ansid=256545 then '300' when ansid=256547 then '5' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 11:02:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE supvisstepid = '13415'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 11:02:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 11:02:42' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 11:48:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 11:48:46')"} {"userId":"660","date":"2023-01-26 12:48:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '202.78.236.43', '2023-01-26 12:48:30')"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '02' when ansid=256541 then '02' when ansid=256543 then '01' when ansid=256545 then '300' when ansid=256547 then '5' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 12:49:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE supvisstepid = '13414'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '02' when ansid=256541 then '02' when ansid=256543 then '01' when ansid=256545 then '300' when ansid=256547 then '5' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 12:49:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE supvisstepid = '13413'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 12:49:39","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:49:39' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE sitesupervision SET `siteid` = '423', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '116', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2718'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sunil Kumar Mondal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE onssid = '11200'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE onsitestaffs SET `staffname` = 'Soma Mukherjee', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE onssid = '11201'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE onsitestaffs SET `staffname` = 'Abhijit Mukherjee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE onssid = '11202'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE onssid = '11203'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256382 then '1' when ansid=256383 then '1' when ansid=256384 then '2' when ansid=256385 then '1' when ansid=256386 then '' when ansid=256387 then '105' when ansid=256388 then '1' when ansid=256488 then '1' when ansid=256489 then '1' when ansid=256431 then '' when ansid=256433 then '' when ansid=256435 then '' when ansid=256437 then '' when ansid=256439 then '' when ansid=256441 then '' when ansid=256442 then '' when ansid=256443 then '' when ansid=256444 then '' when ansid=256445 then '' when ansid=256446 then '' when ansid=256447 then '' when ansid=256448 then '' when ansid=256449 then '' when ansid=256450 then '' when ansid=256451 then '' when ansid=256452 then '' when ansid=256453 then '' when ansid=256454 then '' when ansid=256455 then '' when ansid=256456 then '' when ansid=256457 then '' when ansid=256458 then '' when ansid=256459 then '' when ansid=256460 then '' when ansid=256461 then '' when ansid=256462 then '' when ansid=256463 then '' when ansid=256464 then '' when ansid=256465 then '' when ansid=256466 then '' when ansid=256467 then '' when ansid=256468 then '' when ansid=256469 then '' when ansid=256470 then '' when ansid=256471 then '' when ansid=256472 then '' when ansid=256473 then '' when ansid=256474 then '' when ansid=256475 then '' when ansid=256476 then '' when ansid=256477 then '' when ansid=256478 then '' when ansid=256479 then '' when ansid=256480 then '' when ansid=256481 then '' when ansid=256482 then '' when ansid=256483 then '' when ansid=256484 then '' when ansid=256485 then '' when ansid=256486 then '' when ansid=256487 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 12:51:17'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256382','256383','256384','256385','256386','256387','256388','256488','256489','256431','256433','256435','256437','256439','256441','256442','256443','256444','256445','256446','256447','256448','256449','256450','256451','256452','256453','256454','256455','256456','256457','256458','256459','256460','256461','256462','256463','256464','256465','256466','256467','256468','256469','256470','256471','256472','256473','256474','256475','256476','256477','256478','256479','256480','256481','256482','256483','256484','256485','256486','256487')"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE supvisstepid = '13409'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE visitfeedbackid = '13366'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE visitfeedbackid = '13367'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE visitfeedbackid = '13368'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE visitfeedbackid = '13369'"} {"userId":"660","date":"2023-01-26 12:51:17","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:51:17' WHERE visitfeedbackid = '13370'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE sitesupervision SET `siteid` = '423', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '116', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2718'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sunil Kumar Mondal', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE onssid = '11200'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE onsitestaffs SET `staffname` = 'Soma Mukherjee', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE onssid = '11201'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE onsitestaffs SET `staffname` = 'Abhijit Mukherjee', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE onssid = '11202'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE onssid = '11203'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256382 then '1' when ansid=256383 then '1' when ansid=256384 then '2' when ansid=256385 then '1' when ansid=256386 then '' when ansid=256387 then '105' when ansid=256388 then '1' when ansid=256488 then '1' when ansid=256489 then '1' when ansid=256431 then '' when ansid=256433 then '' when ansid=256435 then '' when ansid=256437 then '' when ansid=256439 then '' when ansid=256441 then '' when ansid=256442 then '' when ansid=256443 then '' when ansid=256444 then '' when ansid=256445 then '' when ansid=256446 then '' when ansid=256447 then '' when ansid=256448 then '' when ansid=256449 then '' when ansid=256450 then '' when ansid=256451 then '' when ansid=256452 then '' when ansid=256453 then '' when ansid=256454 then '' when ansid=256455 then '' when ansid=256456 then '' when ansid=256457 then '' when ansid=256458 then '' when ansid=256459 then '' when ansid=256460 then '' when ansid=256461 then '' when ansid=256462 then '' when ansid=256463 then '' when ansid=256464 then '' when ansid=256465 then '' when ansid=256466 then '' when ansid=256467 then '' when ansid=256468 then '' when ansid=256469 then '' when ansid=256470 then '' when ansid=256471 then '' when ansid=256472 then '' when ansid=256473 then '' when ansid=256474 then '' when ansid=256475 then '' when ansid=256476 then '' when ansid=256477 then '' when ansid=256478 then '' when ansid=256479 then '' when ansid=256480 then '' when ansid=256481 then '' when ansid=256482 then '' when ansid=256483 then '' when ansid=256484 then '' when ansid=256485 then '' when ansid=256486 then '' when ansid=256487 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '202.78.236.43',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 12:56:20'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256382','256383','256384','256385','256386','256387','256388','256488','256489','256431','256433','256435','256437','256439','256441','256442','256443','256444','256445','256446','256447','256448','256449','256450','256451','256452','256453','256454','256455','256456','256457','256458','256459','256460','256461','256462','256463','256464','256465','256466','256467','256468','256469','256470','256471','256472','256473','256474','256475','256476','256477','256478','256479','256480','256481','256482','256483','256484','256485','256486','256487')"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE supvisstepid = '13409'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE visitfeedbackid = '13366'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE visitfeedbackid = '13367'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE visitfeedbackid = '13368'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE visitfeedbackid = '13369'"} {"userId":"660","date":"2023-01-26 12:56:20","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '202.78.236.43', `modifiedby` = '660', `modifieddate` = '2023-01-26 12:56:20' WHERE visitfeedbackid = '13370'"} {"userId":"673","date":"2023-01-26 13:02:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('673', '183.83.208.18', '2023-01-26 13:02:05')"} {"userId":"673","date":"2023-01-26 14:56:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('673', '106.194.118.82', '2023-01-26 14:56:33')"} {"userId":null,"date":"2023-01-26 18:43:38","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('37', '205693', '0', '49.43.154.17', '', '2023-01-26 18:43:38')"} {"userId":null,"date":"2023-01-26 18:43:49","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('37', '679825', '0', '49.43.154.17', '', '2023-01-26 18:43:49')"} {"userId":null,"date":"2023-01-26 18:44:26","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('37', '583715', '0', '49.43.154.17', '', '2023-01-26 18:44:26')"} {"userId":"385","date":"2023-01-26 22:24:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('385', '49.37.64.22', '2023-01-26 22:24:33')"} {"userId":"673","date":"2023-01-26 23:43:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('673', '106.205.187.95', '2023-01-26 23:43:25')"} {"userId":"673","date":"2023-01-26 23:46:35","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('32', '2023-01-24', '673', '106.205.187.95', '673', '2023-01-26 23:46:35')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('32', '3179', '673', '2023-01-26', '0', '106.205.187.95', '673', '2023-01-26 23:46:51', '', '')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2720', '0', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2720', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2720', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2720', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2720', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:46:51","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2720', '106.205.187.95', '673', '2023-01-26 23:46:51')"} {"userId":"673","date":"2023-01-26 23:48:06","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('32', '2023-01-25', '673', '171.48.122.71', '673', '2023-01-26 23:48:06')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('32', '3180', '673', '2023-01-26', '1', '106.205.187.95', '673', '2023-01-26 23:48:13', '', '')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2721', '0', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2721', '1', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2721', '2', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2721', '3', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2721', '4', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2721', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2721', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2721', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2721', '', '', 'Array', '', 'Array', '', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"673","date":"2023-01-26 23:48:13","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2721', '106.205.187.95', '673', '2023-01-26 23:48:13')"} {"userId":"660","date":"2023-01-26 23:48:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '157.40.254.210', '2023-01-26 23:48:40')"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE sitesupervision SET `siteid` = '32', `userid` = '673', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '151', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2721'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Seema', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'assigned charge in HSS2023', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE onssid = '11212'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Anita Sangar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE onssid = '11213'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sunil Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE onssid = '11214'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE onssid = '11215'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256706 then '' when ansid=256707 then '' when ansid=256708 then '' when ansid=256709 then '' when ansid=256710 then '' when ansid=256711 then '' when ansid=256712 then '' when ansid=256812 then '' when ansid=256813 then '' when ansid=256755 then '' when ansid=256757 then '' when ansid=256759 then '' when ansid=256761 then '' when ansid=256763 then '' when ansid=256765 then '' when ansid=256766 then '' when ansid=256767 then '' when ansid=256768 then '' when ansid=256769 then '' when ansid=256770 then '' when ansid=256771 then '' when ansid=256772 then '' when ansid=256773 then '' when ansid=256774 then '' when ansid=256775 then '' when ansid=256776 then '' when ansid=256777 then '' when ansid=256778 then '' when ansid=256779 then '' when ansid=256780 then '' when ansid=256781 then '' when ansid=256782 then '' when ansid=256783 then '' when ansid=256784 then '' when ansid=256785 then '' when ansid=256786 then '' when ansid=256787 then '' when ansid=256788 then '' when ansid=256789 then '' when ansid=256790 then '' when ansid=256791 then '' when ansid=256792 then '' when ansid=256793 then '' when ansid=256794 then '' when ansid=256795 then '' when ansid=256796 then '' when ansid=256797 then '' when ansid=256798 then '' when ansid=256799 then '' when ansid=256800 then '' when ansid=256801 then '' when ansid=256802 then '' when ansid=256803 then '' when ansid=256804 then '' when ansid=256805 then '' when ansid=256806 then '' when ansid=256807 then '' when ansid=256808 then '' when ansid=256809 then '' when ansid=256810 then '' when ansid=256811 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.205.187.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =673,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 23:51:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256706','256707','256708','256709','256710','256711','256712','256812','256813','256755','256757','256759','256761','256763','256765','256766','256767','256768','256769','256770','256771','256772','256773','256774','256775','256776','256777','256778','256779','256780','256781','256782','256783','256784','256785','256786','256787','256788','256789','256790','256791','256792','256793','256794','256795','256796','256797','256798','256799','256800','256801','256802','256803','256804','256805','256806','256807','256808','256809','256810','256811')"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE supvisstepid = '13419'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE visitfeedbackid = '13381'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE visitfeedbackid = '13382'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE visitfeedbackid = '13383'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE visitfeedbackid = '13384'"} {"userId":"673","date":"2023-01-26 23:51:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:51:40' WHERE visitfeedbackid = '13385'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE sitesupervision SET `siteid` = '32', `userid` = '673', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '151', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2721'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Seema', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'assigned charge in HSS2023', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE onssid = '11212'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Anita Sangar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE onssid = '11213'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sunil Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE onssid = '11214'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE onssid = '11215'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256706 then '1' when ansid=256707 then '1' when ansid=256708 then '1' when ansid=256709 then '' when ansid=256710 then '' when ansid=256711 then '161' when ansid=256712 then '1' when ansid=256812 then '1' when ansid=256813 then '1' when ansid=256755 then '' when ansid=256757 then '' when ansid=256759 then '' when ansid=256761 then '' when ansid=256763 then '' when ansid=256765 then '' when ansid=256766 then '' when ansid=256767 then '' when ansid=256768 then '' when ansid=256769 then '' when ansid=256770 then '' when ansid=256771 then '' when ansid=256772 then '' when ansid=256773 then '' when ansid=256774 then '' when ansid=256775 then '' when ansid=256776 then '' when ansid=256777 then '' when ansid=256778 then '' when ansid=256779 then '' when ansid=256780 then '' when ansid=256781 then '' when ansid=256782 then '' when ansid=256783 then '' when ansid=256784 then '' when ansid=256785 then '' when ansid=256786 then '' when ansid=256787 then '' when ansid=256788 then '' when ansid=256789 then '' when ansid=256790 then '' when ansid=256791 then '' when ansid=256792 then '' when ansid=256793 then '' when ansid=256794 then '' when ansid=256795 then '' when ansid=256796 then '' when ansid=256797 then '' when ansid=256798 then '' when ansid=256799 then '' when ansid=256800 then '' when ansid=256801 then '' when ansid=256802 then '' when ansid=256803 then '' when ansid=256804 then '' when ansid=256805 then '' when ansid=256806 then '' when ansid=256807 then '' when ansid=256808 then '' when ansid=256809 then '' when ansid=256810 then '' when ansid=256811 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '106.205.187.95',\r\n\t\t\t\t\t\t\t\tmodifiedby =673,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 23:52:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256706','256707','256708','256709','256710','256711','256712','256812','256813','256755','256757','256759','256761','256763','256765','256766','256767','256768','256769','256770','256771','256772','256773','256774','256775','256776','256777','256778','256779','256780','256781','256782','256783','256784','256785','256786','256787','256788','256789','256790','256791','256792','256793','256794','256795','256796','256797','256798','256799','256800','256801','256802','256803','256804','256805','256806','256807','256808','256809','256810','256811')"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE supvisstepid = '13420'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE visitfeedbackid = '13381'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE visitfeedbackid = '13382'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE visitfeedbackid = '13383'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE visitfeedbackid = '13384'"} {"userId":"673","date":"2023-01-26 23:52:42","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '106.205.187.95', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:52:42' WHERE visitfeedbackid = '13385'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE sitesupervision SET `siteid` = '32', `userid` = '673', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-04', `numofsamplecollected` = '151', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21', `locationtype` = '1', `establishmentyear` = '2002', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2721'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Seema', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'assigned charge in HSS2023', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE onssid = '11212'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Anita Sangar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE onssid = '11213'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Sunil Kumar', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '20', `istrained` = '1', `remarks` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE onssid = '11214'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE onssid = '11215'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256706 then '1' when ansid=256707 then '1' when ansid=256708 then '1' when ansid=256709 then '' when ansid=256710 then '' when ansid=256711 then '161' when ansid=256712 then '1' when ansid=256812 then '1' when ansid=256813 then '1' when ansid=256755 then '1' when ansid=256757 then '1' when ansid=256759 then '1' when ansid=256761 then '3' when ansid=256763 then '1' when ansid=256765 then '' when ansid=256766 then '' when ansid=256767 then '' when ansid=256768 then '' when ansid=256769 then '' when ansid=256770 then '' when ansid=256771 then '' when ansid=256772 then '' when ansid=256773 then '' when ansid=256774 then '' when ansid=256775 then '' when ansid=256776 then '' when ansid=256777 then '' when ansid=256778 then '' when ansid=256779 then '' when ansid=256780 then '' when ansid=256781 then '' when ansid=256782 then '' when ansid=256783 then '' when ansid=256784 then '' when ansid=256785 then '' when ansid=256786 then '' when ansid=256787 then '' when ansid=256788 then '' when ansid=256789 then '' when ansid=256790 then '' when ansid=256791 then '' when ansid=256792 then '' when ansid=256793 then '' when ansid=256794 then '' when ansid=256795 then '' when ansid=256796 then '' when ansid=256797 then '' when ansid=256798 then '' when ansid=256799 then '' when ansid=256800 then '' when ansid=256801 then '' when ansid=256802 then '' when ansid=256803 then '' when ansid=256804 then '' when ansid=256805 then '' when ansid=256806 then '' when ansid=256807 then '' when ansid=256808 then '' when ansid=256809 then '' when ansid=256810 then '' when ansid=256811 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '171.48.122.71',\r\n\t\t\t\t\t\t\t\tmodifiedby =673,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 23:53:21'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256706','256707','256708','256709','256710','256711','256712','256812','256813','256755','256757','256759','256761','256763','256765','256766','256767','256768','256769','256770','256771','256772','256773','256774','256775','256776','256777','256778','256779','256780','256781','256782','256783','256784','256785','256786','256787','256788','256789','256790','256791','256792','256793','256794','256795','256796','256797','256798','256799','256800','256801','256802','256803','256804','256805','256806','256807','256808','256809','256810','256811')"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE supvisstepid = '13421'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE visitfeedbackid = '13381'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE visitfeedbackid = '13382'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE visitfeedbackid = '13383'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE visitfeedbackid = '13384'"} {"userId":"673","date":"2023-01-26 23:53:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '171.48.122.71', `modifiedby` = '673', `modifieddate` = '2023-01-26 23:53:21' WHERE visitfeedbackid = '13385'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '02' when ansid=256541 then '02' when ansid=256543 then '01' when ansid=256545 then '300' when ansid=256547 then '5' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.40.254.210',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 23:53:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE supvisstepid = '13413'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13375'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE sitesupervision SET `siteid` = '429', `userid` = '660', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '81', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32', `locationtype` = '1', `establishmentyear` = '2007', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2719'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Goutam Mukherjee', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11204'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Sanchali Pal', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '15', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11205'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = 'Monaki Majhi', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11206'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE onssid = '11207'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=256490 then '1' when ansid=256491 then '1' when ansid=256492 then '1' when ansid=256493 then '' when ansid=256494 then '' when ansid=256495 then '137' when ansid=256496 then '1' when ansid=256596 then '1' when ansid=256597 then '1' when ansid=256539 then '02' when ansid=256541 then '02' when ansid=256543 then '01' when ansid=256545 then '300' when ansid=256547 then '5' when ansid=256549 then '' when ansid=256550 then '' when ansid=256551 then '' when ansid=256552 then '' when ansid=256553 then '' when ansid=256554 then '' when ansid=256555 then '' when ansid=256556 then '' when ansid=256557 then '' when ansid=256558 then '' when ansid=256559 then '' when ansid=256560 then '' when ansid=256561 then '' when ansid=256562 then '' when ansid=256563 then '' when ansid=256564 then '' when ansid=256565 then '' when ansid=256566 then '' when ansid=256567 then '' when ansid=256568 then '' when ansid=256569 then '' when ansid=256570 then '' when ansid=256571 then '' when ansid=256572 then '' when ansid=256573 then '' when ansid=256574 then '' when ansid=256575 then '' when ansid=256576 then '' when ansid=256577 then '' when ansid=256578 then '' when ansid=256579 then '' when ansid=256580 then '' when ansid=256581 then '' when ansid=256582 then '' when ansid=256583 then '' when ansid=256584 then '' when ansid=256585 then '' when ansid=256586 then '' when ansid=256587 then '' when ansid=256588 then '' when ansid=256589 then '' when ansid=256590 then '' when ansid=256591 then '' when ansid=256592 then '' when ansid=256593 then '' when ansid=256594 then '' when ansid=256595 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '157.40.254.210',\r\n\t\t\t\t\t\t\t\tmodifiedby =660,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-26 23:53:32'\r\n\t\t\t\t\t\t\tWHERE ansid in ('256490','256491','256492','256493','256494','256495','256496','256596','256597','256539','256541','256543','256545','256547','256549','256550','256551','256552','256553','256554','256555','256556','256557','256558','256559','256560','256561','256562','256563','256564','256565','256566','256567','256568','256569','256570','256571','256572','256573','256574','256575','256576','256577','256578','256579','256580','256581','256582','256583','256584','256585','256586','256587','256588','256589','256590','256591','256592','256593','256594','256595')"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE supvisstepid = '13414'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13371'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13372'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13373'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13374'"} {"userId":"660","date":"2023-01-26 23:53:32","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '157.40.254.210', `modifiedby` = '660', `modifieddate` = '2023-01-26 23:53:32' WHERE visitfeedbackid = '13375'"}