{"userId":"647","date":"2023-02-10 01:26:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('647', '125.62.193.108', '2023-02-10 01:26:01')"} {"userId":"647","date":"2023-02-10 01:27:10","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('749', '2023-02-09', '647', '125.62.193.108', '647', '2023-02-10 01:27:10')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('749', '3248', '647', '2023-02-10', '1', '125.62.193.108', '647', '2023-02-10 01:27:38', '', '')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2783', '0', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2783', '1', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2783', '2', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2783', '3', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2783', '4', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2783', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2783', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2783', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2783', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:27:39","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2783', '125.62.193.108', '647', '2023-02-10 01:27:38')"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE sitesupervision SET `siteid` = '749', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '85', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02', `locationtype` = '2', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2783'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Alekhya', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE onssid = '11460'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE onsitestaffs SET `staffname` = 'Ch. PushpaRao', `staffdesigid` = '', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = 'counselor', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE onssid = '11461'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE onsitestaffs SET `staffname` = 'K.Ramkrisna', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE onssid = '11462'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE onssid = '11463'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263348 then '' when ansid=263349 then '' when ansid=263350 then '' when ansid=263351 then '' when ansid=263352 then '' when ansid=263353 then '' when ansid=263354 then '' when ansid=263454 then '' when ansid=263455 then '' when ansid=263397 then '' when ansid=263399 then '' when ansid=263401 then '' when ansid=263403 then '' when ansid=263405 then '' when ansid=263407 then '' when ansid=263408 then '' when ansid=263409 then '' when ansid=263410 then '' when ansid=263411 then '' when ansid=263412 then '' when ansid=263413 then '' when ansid=263414 then '' when ansid=263415 then '' when ansid=263416 then '' when ansid=263417 then '' when ansid=263418 then '' when ansid=263419 then '' when ansid=263420 then '' when ansid=263421 then '' when ansid=263422 then '' when ansid=263423 then '' when ansid=263424 then '' when ansid=263425 then '' when ansid=263426 then '' when ansid=263427 then '' when ansid=263428 then '' when ansid=263429 then '' when ansid=263430 then '' when ansid=263431 then '' when ansid=263432 then '' when ansid=263433 then '' when ansid=263434 then '' when ansid=263435 then '' when ansid=263436 then '' when ansid=263437 then '' when ansid=263438 then '' when ansid=263439 then '' when ansid=263440 then '' when ansid=263441 then '' when ansid=263442 then '' when ansid=263443 then '' when ansid=263444 then '' when ansid=263445 then '' when ansid=263446 then '' when ansid=263447 then '' when ansid=263448 then '' when ansid=263449 then '' when ansid=263450 then '' when ansid=263451 then '' when ansid=263452 then '' when ansid=263453 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 01:31:02'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263348','263349','263350','263351','263352','263353','263354','263454','263455','263397','263399','263401','263403','263405','263407','263408','263409','263410','263411','263412','263413','263414','263415','263416','263417','263418','263419','263420','263421','263422','263423','263424','263425','263426','263427','263428','263429','263430','263431','263432','263433','263434','263435','263436','263437','263438','263439','263440','263441','263442','263443','263444','263445','263446','263447','263448','263449','263450','263451','263452','263453')"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE supvisstepid = '13723'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE visitfeedbackid = '13691'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE visitfeedbackid = '13692'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE visitfeedbackid = '13693'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE visitfeedbackid = '13694'"} {"userId":"647","date":"2023-02-10 01:31:02","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:02' WHERE visitfeedbackid = '13695'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE sitesupervision SET `siteid` = '749', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '85', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56', `locationtype` = '2', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2783'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Alekhya', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE onssid = '11460'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE onsitestaffs SET `staffname` = 'Ch. PushpaRao', `staffdesigid` = '', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = 'counselor', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE onssid = '11461'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE onsitestaffs SET `staffname` = 'K.Ramkrisna', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE onssid = '11462'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE onssid = '11463'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263348 then '1' when ansid=263349 then '1' when ansid=263350 then '1' when ansid=263351 then '' when ansid=263352 then '' when ansid=263353 then '55' when ansid=263354 then '1' when ansid=263454 then '1' when ansid=263455 then '1' when ansid=263397 then '' when ansid=263399 then '' when ansid=263401 then '' when ansid=263403 then '' when ansid=263405 then '' when ansid=263407 then '' when ansid=263408 then '' when ansid=263409 then '' when ansid=263410 then '' when ansid=263411 then '' when ansid=263412 then '' when ansid=263413 then '' when ansid=263414 then '' when ansid=263415 then '' when ansid=263416 then '' when ansid=263417 then '' when ansid=263418 then '' when ansid=263419 then '' when ansid=263420 then '' when ansid=263421 then '' when ansid=263422 then '' when ansid=263423 then '' when ansid=263424 then '' when ansid=263425 then '' when ansid=263426 then '' when ansid=263427 then '' when ansid=263428 then '' when ansid=263429 then '' when ansid=263430 then '' when ansid=263431 then '' when ansid=263432 then '' when ansid=263433 then '' when ansid=263434 then '' when ansid=263435 then '' when ansid=263436 then '' when ansid=263437 then '' when ansid=263438 then '' when ansid=263439 then '' when ansid=263440 then '' when ansid=263441 then '' when ansid=263442 then '' when ansid=263443 then '' when ansid=263444 then '' when ansid=263445 then '' when ansid=263446 then '' when ansid=263447 then '' when ansid=263448 then '' when ansid=263449 then '' when ansid=263450 then '' when ansid=263451 then '' when ansid=263452 then '' when ansid=263453 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 01:31:56'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263348','263349','263350','263351','263352','263353','263354','263454','263455','263397','263399','263401','263403','263405','263407','263408','263409','263410','263411','263412','263413','263414','263415','263416','263417','263418','263419','263420','263421','263422','263423','263424','263425','263426','263427','263428','263429','263430','263431','263432','263433','263434','263435','263436','263437','263438','263439','263440','263441','263442','263443','263444','263445','263446','263447','263448','263449','263450','263451','263452','263453')"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE supvisstepid = '13724'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE visitfeedbackid = '13691'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE visitfeedbackid = '13692'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE visitfeedbackid = '13693'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE visitfeedbackid = '13694'"} {"userId":"647","date":"2023-02-10 01:31:56","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:31:56' WHERE visitfeedbackid = '13695'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE sitesupervision SET `siteid` = '749', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '85', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29', `locationtype` = '2', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2783'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Alekhya', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE onssid = '11460'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE onsitestaffs SET `staffname` = 'Ch. PushpaRao', `staffdesigid` = '', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = 'counselor', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE onssid = '11461'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE onsitestaffs SET `staffname` = 'K.Ramkrisna', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE onssid = '11462'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE onssid = '11463'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263348 then '1' when ansid=263349 then '1' when ansid=263350 then '1' when ansid=263351 then '' when ansid=263352 then '' when ansid=263353 then '55' when ansid=263354 then '1' when ansid=263454 then '1' when ansid=263455 then '1' when ansid=263397 then '1' when ansid=263399 then '1' when ansid=263401 then '1' when ansid=263403 then '90' when ansid=263405 then '1' when ansid=263407 then '' when ansid=263408 then '' when ansid=263409 then '' when ansid=263410 then '' when ansid=263411 then '' when ansid=263412 then '' when ansid=263413 then '' when ansid=263414 then '' when ansid=263415 then '' when ansid=263416 then '' when ansid=263417 then '' when ansid=263418 then '' when ansid=263419 then '' when ansid=263420 then '' when ansid=263421 then '' when ansid=263422 then '' when ansid=263423 then '' when ansid=263424 then '' when ansid=263425 then '' when ansid=263426 then '' when ansid=263427 then '' when ansid=263428 then '' when ansid=263429 then '' when ansid=263430 then '' when ansid=263431 then '' when ansid=263432 then '' when ansid=263433 then '' when ansid=263434 then '' when ansid=263435 then '' when ansid=263436 then '' when ansid=263437 then '' when ansid=263438 then '' when ansid=263439 then '' when ansid=263440 then '' when ansid=263441 then '' when ansid=263442 then '' when ansid=263443 then '' when ansid=263444 then '' when ansid=263445 then '' when ansid=263446 then '' when ansid=263447 then '' when ansid=263448 then '' when ansid=263449 then '' when ansid=263450 then '' when ansid=263451 then '' when ansid=263452 then '' when ansid=263453 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 01:32:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263348','263349','263350','263351','263352','263353','263354','263454','263455','263397','263399','263401','263403','263405','263407','263408','263409','263410','263411','263412','263413','263414','263415','263416','263417','263418','263419','263420','263421','263422','263423','263424','263425','263426','263427','263428','263429','263430','263431','263432','263433','263434','263435','263436','263437','263438','263439','263440','263441','263442','263443','263444','263445','263446','263447','263448','263449','263450','263451','263452','263453')"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE supvisstepid = '13725'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE visitfeedbackid = '13691'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE visitfeedbackid = '13692'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE visitfeedbackid = '13693'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE visitfeedbackid = '13694'"} {"userId":"647","date":"2023-02-10 01:32:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:32:29' WHERE visitfeedbackid = '13695'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE sitesupervision SET `siteid` = '749', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '85', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33', `locationtype` = '2', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2783'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Alekhya', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE onssid = '11460'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'Ch. PushpaRao', `staffdesigid` = '', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = 'counselor', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE onssid = '11461'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE onsitestaffs SET `staffname` = 'K.Ramkrisna', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE onssid = '11462'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE onssid = '11463'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263348 then '1' when ansid=263349 then '1' when ansid=263350 then '1' when ansid=263351 then '' when ansid=263352 then '' when ansid=263353 then '55' when ansid=263354 then '1' when ansid=263454 then '1' when ansid=263455 then '1' when ansid=263397 then '1' when ansid=263399 then '1' when ansid=263401 then '1' when ansid=263403 then '90' when ansid=263405 then '1' when ansid=263407 then '11' when ansid=263408 then '2' when ansid=263409 then '85' when ansid=263410 then '25' when ansid=263411 then '' when ansid=263412 then '1' when ansid=263413 then '1' when ansid=263414 then '' when ansid=263415 then '1' when ansid=263416 then '' when ansid=263417 then '1' when ansid=263418 then '4' when ansid=263419 then '1' when ansid=263420 then '1' when ansid=263421 then 'counselor' when ansid=263422 then '1' when ansid=263423 then '' when ansid=263424 then '1' when ansid=263425 then '1' when ansid=263426 then '' when ansid=263427 then '1' when ansid=263428 then '2' when ansid=263429 then '1' when ansid=263430 then '1' when ansid=263431 then '1' when ansid=263432 then '1' when ansid=263433 then '2' when ansid=263434 then '1' when ansid=263435 then '1' when ansid=263436 then '1' when ansid=263437 then '' when ansid=263438 then '3' when ansid=263439 then '' when ansid=263440 then '1' when ansid=263441 then '1' when ansid=263442 then '1' when ansid=263443 then '' when ansid=263444 then '1' when ansid=263445 then '1' when ansid=263446 then '1' when ansid=263447 then '2' when ansid=263448 then '1' when ansid=263449 then '0' when ansid=263450 then 'NO' when ansid=263451 then 'on 6\/1\/2023 Dr. K.K. L. Prasadon 11\/1\/2023 D. Balajee DPMand on 19\/1\/2023 N. SakhiGopala DAPCU visited the facility. No action points suggested as both Lab tecnician and councelor have long years of experience in HSS and dedicated to the work' when ansid=263452 then 'HSS is being smoothly following all HSS guidelines' when ansid=263453 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 01:44:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263348','263349','263350','263351','263352','263353','263354','263454','263455','263397','263399','263401','263403','263405','263407','263408','263409','263410','263411','263412','263413','263414','263415','263416','263417','263418','263419','263420','263421','263422','263423','263424','263425','263426','263427','263428','263429','263430','263431','263432','263433','263434','263435','263436','263437','263438','263439','263440','263441','263442','263443','263444','263445','263446','263447','263448','263449','263450','263451','263452','263453')"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE supvisstepid = '13726'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE visitfeedbackid = '13691'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE visitfeedbackid = '13692'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE visitfeedbackid = '13693'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE visitfeedbackid = '13694'"} {"userId":"647","date":"2023-02-10 01:44:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:33' WHERE visitfeedbackid = '13695'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE sitesupervision SET `siteid` = '749', `userid` = '647', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '85', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58', `locationtype` = '2', `establishmentyear` = '2010', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '17.7269676', `endlongitude` = '83.3023728' WHERE ssid = '2783'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr. Alekhya', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE onssid = '11460'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE onsitestaffs SET `staffname` = 'Ch. PushpaRao', `staffdesigid` = '', `isavailable` = '1', `exphss` = '06', `istrained` = '1', `remarks` = 'counselor', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE onssid = '11461'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE onsitestaffs SET `staffname` = 'K.Ramkrisna', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE onssid = '11462'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE onssid = '11463'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263348 then '1' when ansid=263349 then '1' when ansid=263350 then '1' when ansid=263351 then '' when ansid=263352 then '' when ansid=263353 then '55' when ansid=263354 then '1' when ansid=263454 then '1' when ansid=263455 then '1' when ansid=263397 then '1' when ansid=263399 then '1' when ansid=263401 then '1' when ansid=263403 then '90' when ansid=263405 then '1' when ansid=263407 then '11' when ansid=263408 then '2' when ansid=263409 then '85' when ansid=263410 then '25' when ansid=263411 then '' when ansid=263412 then '1' when ansid=263413 then '1' when ansid=263414 then '' when ansid=263415 then '1' when ansid=263416 then '' when ansid=263417 then '1' when ansid=263418 then '4' when ansid=263419 then '1' when ansid=263420 then '1' when ansid=263421 then 'counselor' when ansid=263422 then '1' when ansid=263423 then '' when ansid=263424 then '1' when ansid=263425 then '1' when ansid=263426 then '' when ansid=263427 then '1' when ansid=263428 then '2' when ansid=263429 then '1' when ansid=263430 then '1' when ansid=263431 then '1' when ansid=263432 then '1' when ansid=263433 then '2' when ansid=263434 then '1' when ansid=263435 then '1' when ansid=263436 then '1' when ansid=263437 then '' when ansid=263438 then '3' when ansid=263439 then '' when ansid=263440 then '1' when ansid=263441 then '1' when ansid=263442 then '1' when ansid=263443 then '' when ansid=263444 then '1' when ansid=263445 then '1' when ansid=263446 then '1' when ansid=263447 then '2' when ansid=263448 then '1' when ansid=263449 then '0' when ansid=263450 then 'NO' when ansid=263451 then 'on 6\/1\/2023 Dr. K.K. L. Prasadon 11\/1\/2023 D. Balajee DPMand on 19\/1\/2023 N. SakhiGopala DAPCU visited the facility. No action points suggested as both Lab tecnician and councelor have long years of experience in HSS and dedicated to the work' when ansid=263452 then 'HSS is being smoothly following all HSS guidelines' when ansid=263453 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 01:44:58'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263348','263349','263350','263351','263352','263353','263354','263454','263455','263397','263399','263401','263403','263405','263407','263408','263409','263410','263411','263412','263413','263414','263415','263416','263417','263418','263419','263420','263421','263422','263423','263424','263425','263426','263427','263428','263429','263430','263431','263432','263433','263434','263435','263436','263437','263438','263439','263440','263441','263442','263443','263444','263445','263446','263447','263448','263449','263450','263451','263452','263453')"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE supvisstepid = '13727'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE visitfeedback SET `feedback` = 'Nothing adverse found from this site', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE visitfeedbackid = '13691'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE visitfeedbackid = '13692'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE visitfeedbackid = '13693'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE visitfeedbackid = '13694'"} {"userId":"647","date":"2023-02-10 01:44:58","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 01:44:58' WHERE visitfeedbackid = '13695'"} {"userId":"647","date":"2023-02-10 01:48:00","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1865', '2023-02-09', '647', '125.62.193.108', '647', '2023-02-10 01:48:00')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1865', '3249', '647', '2023-02-10', '1', '125.62.193.108', '647', '2023-02-10 01:48:42', '', '')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '0', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '1', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '2', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '3', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '4', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '5', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2784', '6', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2784', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2784', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2784', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2784', '', '', 'Array', '', 'Array', '', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('184', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('185', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('186', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('187', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('188', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('189', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('190', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('191', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('192', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('193', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('194', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('195', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('196', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('197', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('198', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('199', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('200', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('201', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('202', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('203', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('204', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('205', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('206', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('207', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('208', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('209', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('210', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('211', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('212', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('213', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('214', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('215', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('216', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('217', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('218', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('219', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('220', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('221', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('222', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('223', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('224', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('225', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('226', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('227', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('228', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('229', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('230', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('231', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('232', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('233', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('234', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('235', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('236', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('237', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('238', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('239', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('240', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('241', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('242', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('243', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('244', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('245', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('246', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('247', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('248', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('249', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('250', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('251', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('252', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('253', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('254', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('255', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('256', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('257', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('258', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('259', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('260', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('261', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('262', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('263', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('264', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('265', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('266', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('267', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('268', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('269', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('270', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('271', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('272', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('273', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('274', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('275', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('276', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('277', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('280', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('281', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('282', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('283', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('284', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('285', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('286', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('287', '2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 01:48:42","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2784', '125.62.193.108', '647', '2023-02-10 01:48:42')"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '' when ansid=263475 then '' when ansid=263476 then '' when ansid=263477 then '' when ansid=263478 then '' when ansid=263479 then '' when ansid=263480 then '' when ansid=263481 then '' when ansid=263482 then '' when ansid=263483 then '' when ansid=263484 then '' when ansid=263485 then '' when ansid=263486 then '' when ansid=263487 then '' when ansid=263550 then '' when ansid=263551 then '' when ansid=263552 then '' when ansid=263553 then '' when ansid=263554 then '' when ansid=263555 then '' when ansid=263488 then '' when ansid=263489 then '' when ansid=263490 then '' when ansid=263491 then '' when ansid=263492 then '' when ansid=263493 then '' when ansid=263494 then '' when ansid=263495 then '' when ansid=263496 then '' when ansid=263497 then '' when ansid=263498 then '' when ansid=263499 then '' when ansid=263500 then '' when ansid=263501 then '' when ansid=263502 then '' when ansid=263503 then '' when ansid=263504 then '' when ansid=263505 then '' when ansid=263506 then '' when ansid=263507 then '' when ansid=263508 then '' when ansid=263509 then '' when ansid=263510 then '' when ansid=263511 then '' when ansid=263512 then '' when ansid=263513 then '' when ansid=263514 then '' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 02:00:06'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE supvisstepid = '13728'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-10 02:00:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:06' WHERE visitfeedbackid = '13700'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then '' when ansid=263477 then '' when ansid=263478 then '' when ansid=263479 then '' when ansid=263480 then '' when ansid=263481 then '' when ansid=263482 then '' when ansid=263483 then '' when ansid=263484 then '' when ansid=263485 then '' when ansid=263486 then '' when ansid=263487 then '' when ansid=263550 then '' when ansid=263551 then '' when ansid=263552 then '' when ansid=263553 then '' when ansid=263554 then '' when ansid=263555 then '' when ansid=263488 then '' when ansid=263489 then '' when ansid=263490 then '' when ansid=263491 then '' when ansid=263492 then '' when ansid=263493 then '' when ansid=263494 then '' when ansid=263495 then '' when ansid=263496 then '' when ansid=263497 then '' when ansid=263498 then '' when ansid=263499 then '' when ansid=263500 then '' when ansid=263501 then '' when ansid=263502 then '' when ansid=263503 then '' when ansid=263504 then '' when ansid=263505 then '' when ansid=263506 then '' when ansid=263507 then '' when ansid=263508 then '' when ansid=263509 then '' when ansid=263510 then '' when ansid=263511 then '' when ansid=263512 then '' when ansid=263513 then '' when ansid=263514 then '' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 02:00:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE supvisstepid = '13729'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-10 02:00:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:00:29' WHERE visitfeedbackid = '13700'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE sitesupervision SET `siteid` = '1865', `userid` = '647', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '1600', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2784'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'Dr, N. Sujatha', `staffdesigid` = '', `isavailable` = '1', `exphss` = '02', `istrained` = '1', `remarks` = 'Nodal officer', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE onssid = '11464'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'K. Sateesh', `staffdesigid` = '12', `isavailable` = '1', `exphss` = '12', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE onssid = '11465'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE onsitestaffs SET `staffname` = 'R. Raghu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE onssid = '11466'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE onssid = '11467'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=263456 then '177' when ansid=263457 then '2011' when ansid=263458 then '177' when ansid=263459 then 'GGH-SKLM' when ansid=263460 then '168' when ansid=263461 then '' when ansid=263462 then 'Anakapalli' when ansid=263463 then '128' when ansid=263464 then '' when ansid=263465 then 'Agnampudi' when ansid=263466 then '176' when ansid=263467 then '' when ansid=263468 then 'Sujatha Hospital' when ansid=263469 then '101' when ansid=263470 then '' when ansid=263471 then 'Ramarao Hospital' when ansid=263472 then '19' when ansid=263473 then '' when ansid=263474 then '1' when ansid=263475 then '1' when ansid=263476 then 'CoombAids' when ansid=263477 then 'ARKRAY- Prv.ltd' when ansid=263478 then '3792' when ansid=263479 then '27670' when ansid=263480 then '10\/9\/24' when ansid=263481 then '2-8 degree' when ansid=263482 then 'Standard' when ansid=263483 then 'ARKRAY PVT.LTD' when ansid=263484 then '50' when ansid=263485 then '57088' when ansid=263486 then '8\/24' when ansid=263487 then '2-8 degree' when ansid=263550 then 'Not available, procurement under process' when ansid=263551 then '-' when ansid=263552 then '0' when ansid=263553 then '0' when ansid=263554 then '-' when ansid=263555 then '-' when ansid=263488 then '-' when ansid=263489 then '-' when ansid=263490 then '0' when ansid=263491 then '0' when ansid=263492 then '-' when ansid=263493 then '-' when ansid=263494 then 'NACO' when ansid=263495 then 'Avauter' when ansid=263496 then '3800' when ansid=263497 then '0122' when ansid=263498 then '8\/24' when ansid=263499 then '2-8degree' when ansid=263500 then 'Q.Line' when ansid=263501 then 'Q-Line Bio tech Prv.ltd' when ansid=263502 then '3775' when ansid=263503 then '016' when ansid=263504 then '11\/2024' when ansid=263505 then '2-8 degree' when ansid=263506 then '' when ansid=263507 then '' when ansid=263508 then '' when ansid=263509 then '' when ansid=263510 then '' when ansid=263511 then '' when ansid=263512 then '' when ansid=263513 then '' when ansid=263514 then '' when ansid=263515 then '' when ansid=263516 then '' when ansid=263517 then '' when ansid=263518 then '' when ansid=263519 then '' when ansid=263520 then '' when ansid=263521 then '' when ansid=263522 then '' when ansid=263523 then '' when ansid=263524 then '' when ansid=263525 then '' when ansid=263526 then '' when ansid=263527 then '' when ansid=263528 then '' when ansid=263529 then '' when ansid=263530 then '' when ansid=263531 then '' when ansid=263532 then '' when ansid=263533 then '' when ansid=263534 then '' when ansid=263535 then '' when ansid=263536 then '' when ansid=263537 then '' when ansid=263556 then '' when ansid=263557 then '' when ansid=263538 then '' when ansid=263539 then '' when ansid=263540 then '' when ansid=263541 then '' when ansid=263542 then '' when ansid=263543 then '' when ansid=263544 then '' when ansid=263545 then '' when ansid=263546 then '' when ansid=263547 then '' when ansid=263548 then '' when ansid=263549 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '125.62.193.108',\r\n\t\t\t\t\t\t\t\tmodifiedby =647,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 02:17:53'\r\n\t\t\t\t\t\t\tWHERE ansid in ('263456','263457','263458','263459','263460','263461','263462','263463','263464','263465','263466','263467','263468','263469','263470','263471','263472','263473','263474','263475','263476','263477','263478','263479','263480','263481','263482','263483','263484','263485','263486','263487','263550','263551','263552','263553','263554','263555','263488','263489','263490','263491','263492','263493','263494','263495','263496','263497','263498','263499','263500','263501','263502','263503','263504','263505','263506','263507','263508','263509','263510','263511','263512','263513','263514','263515','263516','263517','263518','263519','263520','263521','263522','263523','263524','263525','263526','263527','263528','263529','263530','263531','263532','263533','263534','263535','263536','263537','263556','263557','263538','263539','263540','263541','263542','263543','263544','263545','263546','263547','263548','263549')"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE supvisstepid = '13730'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE visitfeedbackid = '13696'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE visitfeedbackid = '13697'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE visitfeedbackid = '13698'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE visitfeedbackid = '13699'"} {"userId":"647","date":"2023-02-10 02:17:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '125.62.193.108', `modifiedby` = '647', `modifieddate` = '2023-02-10 02:17:53' WHERE visitfeedbackid = '13700'"} {"userId":"2","date":"2023-02-10 11:34:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '110.235.232.37', '2023-02-10 11:34:33')"} {"userId":"575","date":"2023-02-10 11:44:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.37', '2023-02-10 11:44:08')"} {"userId":"673","date":"2023-02-10 12:14:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('673', '106.192.140.158', '2023-02-10 12:14:29')"} {"userId":"574","date":"2023-02-10 13:53:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.37', '2023-02-10 13:53:31')"} {"userId":"1","date":"2023-02-10 14:06:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '103.119.246.138', '2023-02-10 14:06:14')"} {"userId":"680","date":"2023-02-10 14:55:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '14.139.218.146', '2023-02-10 14:55:16')"} {"userId":"680","date":"2023-02-10 14:56:16","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1065', '2023-02-10', '680', '14.139.218.146', '680', '2023-02-10 14:56:16')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1065', '3250', '680', '2023-02-10', '0', '14.139.218.146', '680', '2023-02-10 14:56:19', '', '')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2785', '0', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2785', '', '', 'Array', '', 'Array', '', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2785', '', '', 'Array', '', 'Array', '', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2785', '', '', 'Array', '', 'Array', '', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2785', '', '', 'Array', '', 'Array', '', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('80', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('81', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('82', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('83', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('84', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('85', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('86', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('87', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('88', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('89', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('90', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('91', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('92', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('93', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('94', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('95', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('96', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('97', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('98', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('99', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('100', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('101', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('102', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('103', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('104', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('105', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('106', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('107', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('108', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('109', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('110', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('111', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('112', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('113', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('114', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('115', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('116', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('117', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('118', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('119', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('120', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('121', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('122', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('123', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('124', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('125', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('126', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('127', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('128', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('129', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('130', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('131', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('132', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('133', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('134', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('135', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('136', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('137', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('138', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('139', '2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"680","date":"2023-02-10 14:56:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2785', '14.139.218.146', '680', '2023-02-10 14:56:19')"} {"userId":"648","date":"2023-02-10 16:08:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('648', '157.50.33.207', '2023-02-10 16:08:46')"} {"userId":"1","date":"2023-02-10 16:11:37","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('1', '103.119.246.138', '2023-02-10 16:11:37')"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:19' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:19' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:19' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:19' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:12:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:12:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:49', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:49' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:49' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:49' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:12:49' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:12:49","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:12:49'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:18:51', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:18:51' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:18:51' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:18:51' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:18:51' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:18:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:18:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:19:42', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:19:42' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:19:42' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:19:42' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:19:42' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:19:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:19:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:20:26', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:20:26' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:20:26' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:20:26' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:20:26' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:20:26","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:20:26'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:42:22', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:42:22' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:42:22' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:42:22' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:42:22' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:42:22","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:42:22'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:43:24', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:43:24' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:43:24' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:43:24' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:43:24' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:43:24","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:43:24'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:05', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:05' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:05' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:05' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:05' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:50:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid= then '' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:50:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:22', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:22' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:22' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:22' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:50:22' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:50:22","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:50:22'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:39', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:39' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:39' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:39' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:39' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:51:39","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:51:39'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:42', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:42' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:42' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:42' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:51:42' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:51:42","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:51:42'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE sitesupervision SET `siteid` = '1792', `userid` = '1', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2023-02-07', `numofsamplecollected` = '5', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:55:19', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2767'"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE onsitestaffs SET `staffname` = '5', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:55:19' WHERE onssid = '11396'"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:55:19' WHERE onssid = '11397'"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:55:19' WHERE onssid = '11398'"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:55:19' WHERE onssid = '11399'"} {"userId":"1","date":"2023-02-10 16:55:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=261646 then '5' when ansid=261647 then '5' when ansid=261648 then '5' when ansid=261649 then '5' when ansid=261650 then '5' when ansid=261651 then '5' when ansid=261652 then '5' when ansid=261653 then '5' when ansid=261654 then '5' when ansid=261655 then '5' when ansid=261656 then '5' when ansid=261657 then '5' when ansid=261658 then '5' when ansid=261659 then '5' when ansid=261660 then '5' when ansid=261661 then '5' when ansid=261662 then '5' when ansid=261663 then '5' when ansid=261664 then '1' when ansid=261665 then '1' when ansid=261666 then '7' when ansid=261667 then '7' when ansid=261668 then '7' when ansid=261669 then '7' when ansid=261670 then '7' when ansid=261671 then '7' when ansid=261672 then '7' when ansid=261673 then '7' when ansid=261674 then '4' when ansid=261675 then '4' when ansid=261676 then '3' when ansid=261677 then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid= then '5' when ansid=261678 then '5' when ansid=261679 then '5' when ansid=261680 then '5' when ansid=261681 then '5' when ansid=261682 then '5' when ansid=261683 then '5' when ansid=261684 then '5' when ansid=261685 then '5' when ansid=261686 then '6' when ansid=261687 then '6' when ansid=261688 then '6' when ansid=261689 then '6' when ansid=261690 then '6' when ansid=261691 then '6' when ansid=261692 then '6' when ansid=261693 then '6' when ansid=261694 then '6' when ansid=261695 then '6' when ansid=261696 then 'sc' when ansid=261697 then '1' when ansid=261698 then '1' when ansid=261699 then '1' when ansid=261700 then '1' when ansid=261701 then '1' when ansid=261702 then '1' when ansid=261703 then '1' when ansid=261704 then 'sds' when ansid=261705 then '56' when ansid=261706 then '5' when ansid=261707 then '5' when ansid=261708 then '6' when ansid=261709 then '5' when ansid=261710 then '5' when ansid=261711 then '5' when ansid=261712 then '55' when ansid=261713 then '5' when ansid=261714 then '5' when ansid=261715 then '5' when ansid=261716 then '5' when ansid=261717 then '5' when ansid=261718 then '5' when ansid=261719 then '5' when ansid=261720 then '5' when ansid=261721 then '5' when ansid=261722 then '5' when ansid=261723 then '5' when ansid=261724 then '5' when ansid=261725 then '2' when ansid=261726 then '' when ansid=261727 then '' when ansid= then '' when ansid= then '' when ansid=261728 then '' when ansid=261729 then '' when ansid=261730 then '' when ansid=261731 then '' when ansid=261732 then '' when ansid=261733 then '' when ansid=261734 then '' when ansid=261735 then '' when ansid=261736 then '' when ansid=261737 then '' when ansid=261738 then '' when ansid=261739 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:55:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261646','261647','261648','261649','261650','261651','261652','261653','261654','261655','261656','261657','261658','261659','261660','261661','261662','261663','261664','261665','261666','261667','261668','261669','261670','261671','261672','261673','261674','261675','261676','261677','','','','','','','261678','261679','261680','261681','261682','261683','261684','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261697','261698','261699','261700','261701','261702','261703','261704','261705','261706','261707','261708','261709','261710','261711','261712','261713','261714','261715','261716','261717','261718','261719','261720','261721','261722','261723','261724','261725','261726','261727','','','261728','261729','261730','261731','261732','261733','261734','261735','261736','261737','261738','261739')"} {"userId":"680","date":"2023-02-10 16:55:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('680', '14.139.218.146', '2023-02-10 16:55:56')"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE sitesupervision SET `siteid` = '181', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-09', `numofsamplecollected` = '120', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2776'"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE onssid = '11432'"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE onssid = '11433'"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE onssid = '11434'"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE onssid = '11435'"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=262598 then '1' when ansid=262599 then '1' when ansid=262600 then '1' when ansid=262601 then '' when ansid=262602 then '' when ansid=262603 then '00' when ansid=262604 then '1' when ansid=262704 then '2' when ansid=262705 then '1' when ansid=262647 then '1' when ansid=262649 then '1' when ansid=262651 then '0' when ansid=262653 then '3' when ansid=262655 then '1' when ansid=262657 then '3' when ansid=262658 then '' when ansid=262659 then '1600' when ansid=262660 then '300' when ansid=262661 then '' when ansid=262662 then '1' when ansid=262663 then '1' when ansid=262664 then '' when ansid=262665 then '1' when ansid=262666 then '' when ansid=262667 then '1' when ansid=262668 then '20' when ansid=262669 then '1' when ansid=262670 then '1' when ansid=262671 then 'counsellor' when ansid=262672 then '1' when ansid=262673 then '' when ansid=262674 then '1' when ansid=262675 then '1' when ansid=262676 then '' when ansid=262677 then '1' when ansid=262678 then '2' when ansid=262679 then '1' when ansid=262680 then '1' when ansid=262681 then '1' when ansid=262682 then '1' when ansid=262683 then '1' when ansid=262684 then '1' when ansid=262685 then '1' when ansid=262686 then '1' when ansid=262687 then '' when ansid=262688 then '2' when ansid=262689 then '' when ansid=262690 then '1' when ansid=262691 then '1' when ansid=262692 then '1' when ansid=262693 then '' when ansid=262694 then '1' when ansid=262695 then '1' when ansid=262696 then '1' when ansid=262697 then '1' when ansid=262698 then '1' when ansid=262699 then '' when ansid=262700 then 'none' when ansid=262701 then 'none' when ansid=262702 then 'nonenone' when ansid=262703 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:59:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('262598','262599','262600','262601','262602','262603','262604','262704','262705','262647','262649','262651','262653','262655','262657','262658','262659','262660','262661','262662','262663','262664','262665','262666','262667','262668','262669','262670','262671','262672','262673','262674','262675','262676','262677','262678','262679','262680','262681','262682','262683','262684','262685','262686','262687','262688','262689','262690','262691','262692','262693','262694','262695','262696','262697','262698','262699','262700','262701','262702','262703')"} {"userId":"1","date":"2023-02-10 16:59:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE supvisstepid = '13689'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE visitfeedbackid = '13656'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE visitfeedbackid = '13657'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE visitfeedbackid = '13658'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE visitfeedbackid = '13659'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:05' WHERE visitfeedbackid = '13660'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE sitesupervision SET `siteid` = '181', `userid` = '1', `ancservicedays` = '0', `samplecollectiondays` = '4', `samplecollectionstartdate` = '2023-02-09', `numofsamplecollected` = '120', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06', `locationtype` = '1', `establishmentyear` = '2009', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2776'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE onssid = '11432'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE onssid = '11433'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '9', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE onssid = '11434'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE onsitestaffs SET `staffname` = 'hh', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE onssid = '11435'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=262598 then '1' when ansid=262599 then '1' when ansid=262600 then '1' when ansid=262601 then '' when ansid=262602 then '' when ansid=262603 then '00' when ansid=262604 then '1' when ansid=262704 then '2' when ansid=262705 then '1' when ansid=262647 then '1' when ansid=262649 then '1' when ansid=262651 then '0' when ansid=262653 then '3' when ansid=262655 then '1' when ansid=262657 then '3' when ansid=262658 then '' when ansid=262659 then '1600' when ansid=262660 then '300' when ansid=262661 then '' when ansid=262662 then '1' when ansid=262663 then '1' when ansid=262664 then '' when ansid=262665 then '1' when ansid=262666 then '' when ansid=262667 then '1' when ansid=262668 then '20' when ansid=262669 then '1' when ansid=262670 then '1' when ansid=262671 then 'counsellor' when ansid=262672 then '1' when ansid=262673 then '' when ansid=262674 then '1' when ansid=262675 then '1' when ansid=262676 then '' when ansid=262677 then '1' when ansid=262678 then '2' when ansid=262679 then '1' when ansid=262680 then '1' when ansid=262681 then '1' when ansid=262682 then '1' when ansid=262683 then '1' when ansid=262684 then '1' when ansid=262685 then '1' when ansid=262686 then '1' when ansid=262687 then '' when ansid=262688 then '2' when ansid=262689 then '' when ansid=262690 then '1' when ansid=262691 then '1' when ansid=262692 then '1' when ansid=262693 then '' when ansid=262694 then '1' when ansid=262695 then '1' when ansid=262696 then '1' when ansid=262697 then '1' when ansid=262698 then '1' when ansid=262699 then '' when ansid=262700 then 'none' when ansid=262701 then 'none' when ansid=262702 then 'nonenone' when ansid=262703 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.119.246.138',\r\n\t\t\t\t\t\t\t\tmodifiedby =1,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-10 16:59:06'\r\n\t\t\t\t\t\t\tWHERE ansid in ('262598','262599','262600','262601','262602','262603','262604','262704','262705','262647','262649','262651','262653','262655','262657','262658','262659','262660','262661','262662','262663','262664','262665','262666','262667','262668','262669','262670','262671','262672','262673','262674','262675','262676','262677','262678','262679','262680','262681','262682','262683','262684','262685','262686','262687','262688','262689','262690','262691','262692','262693','262694','262695','262696','262697','262698','262699','262700','262701','262702','262703')"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE supvisstepid = '13687'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE visitfeedbackid = '13656'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE visitfeedbackid = '13657'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE visitfeedbackid = '13658'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE visitfeedbackid = '13659'"} {"userId":"1","date":"2023-02-10 16:59:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.119.246.138', `modifiedby` = '1', `modifieddate` = '2023-02-10 16:59:06' WHERE visitfeedbackid = '13660'"} {"userId":"651","date":"2023-02-10 21:36:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('651', '162.216.141.29', '2023-02-10 21:36:25')"} {"userId":"651","date":"2023-02-10 21:37:32","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('963', '2023-02-11', '651', '162.216.141.29', '651', '2023-02-10 21:37:32')"} {"userId":"651","date":"2023-02-10 21:48:26","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1794', '2023-02-11', '651', '162.216.141.29', '651', '2023-02-10 21:48:26')"}