{"userId":"521","date":"2023-01-02 09:32:53","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-01-02 09:32:53')"}
{"userId":"521","date":"2023-01-02 09:34:32","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('xyz', '1', '2', '7', '7', '12345678', '1', '123', '14.139.206.130', '521', '2023-01-02 09:34:32')"}
{"userId":"521","date":"2023-01-02 09:37:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-01-02 09:37:24')"}
{"userId":"7","date":"2023-01-02 09:39:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-01-02 09:39:32')"}
{"userId":"521","date":"2023-01-02 10:00:55","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1851', '2023-01-02', '521', '14.139.206.130', '521', '2023-01-02 10:00:55')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1851', '2836', '521', '2023-01-02', '1', '14.139.206.130', '521', '2023-01-02 10:00:59', '', '')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2429', '0', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2429', '1', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2429', '2', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2429', '3', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2429', '4', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2429', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2429', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2429', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2429', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:00:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2429', '14.139.206.130', '521', '2023-01-02 10:00:59')"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE sitesupervision SET `siteid` = '1851', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '8', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2429'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE onsitestaffs SET `staffname` = 'amrit', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE onssid = '10044'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE onssid = '10045'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE onssid = '10046'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE onssid = '10047'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225254 then '' when ansid=225255 then '' when ansid=225256 then '' when ansid=225257 then '' when ansid=225258 then ''  when ansid=225259 then ''   when ansid=225260 then ''  when ansid=225360 then '' when ansid=225361 then '' when ansid=225303 then '' when ansid=225305 then '' when ansid=225307 then '' when ansid=225309 then '' when ansid=225311 then '' when ansid=225313 then '' when ansid=225314 then '' when ansid=225315 then '' when ansid=225316 then ''  when ansid=225317 then ''   when ansid=225318 then ''  when ansid=225319 then ''  when ansid=225320 then ''   when ansid=225321 then ''   when ansid=225322 then ''   when ansid=225323 then ''  when ansid=225324 then '' when ansid=225325 then '' when ansid=225326 then ''  when ansid=225327 then ''   when ansid=225328 then ''   when ansid=225329 then ''   when ansid=225330 then ''  when ansid=225331 then ''  when ansid=225332 then ''   when ansid=225333 then ''  when ansid=225334 then '' when ansid=225335 then '' when ansid=225336 then '' when ansid=225337 then '' when ansid=225338 then '' when ansid=225339 then '' when ansid=225340 then '' when ansid=225341 then '' when ansid=225342 then ''  when ansid=225343 then ''   when ansid=225344 then ''   when ansid=225345 then ''   when ansid=225346 then ''  when ansid=225347 then '' when ansid=225348 then ''  when ansid=225349 then ''   when ansid=225350 then ''  when ansid=225351 then '' when ansid=225352 then '' when ansid=225353 then '' when ansid=225354 then '' when ansid=225355 then '' when ansid=225356 then '' when ansid=225357 then '' when ansid=225358 then '' when ansid=225359 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 10:02:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225254','225255','225256','225257','225258','225259','225260','225360','225361','225303','225305','225307','225309','225311','225313','225314','225315','225316','225317','225318','225319','225320','225321','225322','225323','225324','225325','225326','225327','225328','225329','225330','225331','225332','225333','225334','225335','225336','225337','225338','225339','225340','225341','225342','225343','225344','225345','225346','225347','225348','225349','225350','225351','225352','225353','225354','225355','225356','225357','225358','225359')"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE supvisstepid = '12015'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE visitfeedbackid = '11921'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE visitfeedbackid = '11922'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE visitfeedbackid = '11923'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE visitfeedbackid = '11924'"}
{"userId":"521","date":"2023-01-02 10:02:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:02:19' WHERE visitfeedbackid = '11925'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE sitesupervision SET `siteid` = '1851', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '8', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2429'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE onsitestaffs SET `staffname` = 'amrit', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE onssid = '10044'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE onssid = '10045'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE onssid = '10046'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE onssid = '10047'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225254 then '1' when ansid=225255 then '1' when ansid=225256 then '1' when ansid=225257 then '' when ansid=225258 then ''  when ansid=225259 then ''   when ansid=225260 then '2'  when ansid=225360 then '1' when ansid=225361 then '1' when ansid=225303 then '' when ansid=225305 then '' when ansid=225307 then '' when ansid=225309 then '' when ansid=225311 then '' when ansid=225313 then '' when ansid=225314 then '' when ansid=225315 then '' when ansid=225316 then ''  when ansid=225317 then ''   when ansid=225318 then ''  when ansid=225319 then ''  when ansid=225320 then ''   when ansid=225321 then ''   when ansid=225322 then ''   when ansid=225323 then ''  when ansid=225324 then '' when ansid=225325 then '' when ansid=225326 then ''  when ansid=225327 then ''   when ansid=225328 then ''   when ansid=225329 then ''   when ansid=225330 then ''  when ansid=225331 then ''  when ansid=225332 then ''   when ansid=225333 then ''  when ansid=225334 then '' when ansid=225335 then '' when ansid=225336 then '' when ansid=225337 then '' when ansid=225338 then '' when ansid=225339 then '' when ansid=225340 then '' when ansid=225341 then '' when ansid=225342 then ''  when ansid=225343 then ''   when ansid=225344 then ''   when ansid=225345 then ''   when ansid=225346 then ''  when ansid=225347 then '' when ansid=225348 then ''  when ansid=225349 then ''   when ansid=225350 then ''  when ansid=225351 then '' when ansid=225352 then '' when ansid=225353 then '' when ansid=225354 then '' when ansid=225355 then '' when ansid=225356 then '' when ansid=225357 then '' when ansid=225358 then '' when ansid=225359 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 10:03:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225254','225255','225256','225257','225258','225259','225260','225360','225361','225303','225305','225307','225309','225311','225313','225314','225315','225316','225317','225318','225319','225320','225321','225322','225323','225324','225325','225326','225327','225328','225329','225330','225331','225332','225333','225334','225335','225336','225337','225338','225339','225340','225341','225342','225343','225344','225345','225346','225347','225348','225349','225350','225351','225352','225353','225354','225355','225356','225357','225358','225359')"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE supvisstepid = '12016'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE visitfeedbackid = '11921'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE visitfeedbackid = '11922'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE visitfeedbackid = '11923'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE visitfeedbackid = '11924'"}
{"userId":"521","date":"2023-01-02 10:03:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:29' WHERE visitfeedbackid = '11925'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE sitesupervision SET `siteid` = '1851', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '8', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2429'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE onsitestaffs SET `staffname` = 'amrit', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE onssid = '10044'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE onssid = '10045'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE onssid = '10046'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE onssid = '10047'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225254 then '1' when ansid=225255 then '1' when ansid=225256 then '1' when ansid=225257 then '' when ansid=225258 then ''  when ansid=225259 then ''   when ansid=225260 then '2'  when ansid=225360 then '1' when ansid=225361 then '1' when ansid=225303 then '1' when ansid=225305 then '1' when ansid=225307 then '1' when ansid=225309 then '1' when ansid=225311 then '1' when ansid=225313 then '' when ansid=225314 then '' when ansid=225315 then '' when ansid=225316 then ''  when ansid=225317 then ''   when ansid=225318 then ''  when ansid=225319 then ''  when ansid=225320 then ''   when ansid=225321 then ''   when ansid=225322 then ''   when ansid=225323 then ''  when ansid=225324 then '' when ansid=225325 then '' when ansid=225326 then ''  when ansid=225327 then ''   when ansid=225328 then ''   when ansid=225329 then ''   when ansid=225330 then ''  when ansid=225331 then ''  when ansid=225332 then ''   when ansid=225333 then ''  when ansid=225334 then '' when ansid=225335 then '' when ansid=225336 then '' when ansid=225337 then '' when ansid=225338 then '' when ansid=225339 then '' when ansid=225340 then '' when ansid=225341 then '' when ansid=225342 then ''  when ansid=225343 then ''   when ansid=225344 then ''   when ansid=225345 then ''   when ansid=225346 then ''  when ansid=225347 then '' when ansid=225348 then ''  when ansid=225349 then ''   when ansid=225350 then ''  when ansid=225351 then '' when ansid=225352 then '' when ansid=225353 then '' when ansid=225354 then '' when ansid=225355 then '' when ansid=225356 then '' when ansid=225357 then '' when ansid=225358 then '' when ansid=225359 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 10:03:46'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225254','225255','225256','225257','225258','225259','225260','225360','225361','225303','225305','225307','225309','225311','225313','225314','225315','225316','225317','225318','225319','225320','225321','225322','225323','225324','225325','225326','225327','225328','225329','225330','225331','225332','225333','225334','225335','225336','225337','225338','225339','225340','225341','225342','225343','225344','225345','225346','225347','225348','225349','225350','225351','225352','225353','225354','225355','225356','225357','225358','225359')"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE supvisstepid = '12017'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE visitfeedbackid = '11921'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE visitfeedbackid = '11922'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE visitfeedbackid = '11923'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE visitfeedbackid = '11924'"}
{"userId":"521","date":"2023-01-02 10:03:46","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 10:03:46' WHERE visitfeedbackid = '11925'"}
{"userId":"544","date":"2023-01-02 10:11:20","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2023-01-02 10:11:20')"}
{"userId":"574","date":"2023-01-02 10:37:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.179', '2023-01-02 10:37:34')"}
{"userId":"544","date":"2023-01-02 11:08:38","query":"UPDATE usermst SET `firstname` = 'Dr Arun Kumar', `lastname` = 'Padhi', `email` = 'drarunkpadhi@gmail.com', `mobilenum` = '9439990496', `designation` = 'DPHO, Koraput', `organization` = 'Office of the CDM&PHO, Koraput', `roleid` = '4', `ipaddress` = '14.139.206.130', `createdby` = '544', `createddate` = '2023-01-02 11:08:38' WHERE userid = '207'"}
{"userId":"544","date":"2023-01-02 11:08:38","query":"UPDATE userlocation SET `userid` = '207', `countryid` = '101', `stateid` = '29', `riid` = '6', `cityid` = '3039', `districtid` = '449', `ipaddress` = '14.139.206.130', `createdby` = '544', `createddate` = '2023-01-02 11:08:38' WHERE userid = '207'"}
{"userId":"574","date":"2023-01-02 11:14:35","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Rajan Kumar', 'Barnwal', 'dr.rajanbarnwal@gmail.com', '7631190942', '', '', '25d55ad283aa400af464c76d713c07ad', '4', '110.235.232.179', '574', '2023-01-02 11:14:35')"}
{"userId":"574","date":"2023-01-02 11:14:35","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('619', '101', '16', '240', '3', '1425', '110.235.232.179', '574', '2023-01-02 11:14:35')"}
{"userId":"521","date":"2023-01-02 11:36:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('521', '14.139.206.130', '2023-01-02 11:36:25')"}
{"userId":"522","date":"2023-01-02 11:37:30","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('522', '103.112.27.11', '2023-01-02 11:37:30')"}
{"userId":"522","date":"2023-01-02 11:38:50","query":"UPDATE usermst SET `password` = 'acb6d9396403eab4d3aed67c70b0d661', `modifiedby` = '522', `modifieddate` = '2023-01-02 11:38:50', `ipaddress` = '103.112.27.11' WHERE userid = '522'"}
{"userId":"530","date":"2023-01-02 11:39:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('530', '14.139.216.43', '2023-01-02 11:39:06')"}
{"userId":"521","date":"2023-01-02 11:39:22","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1846', '2023-01-02', '521', '14.139.206.130', '521', '2023-01-02 11:39:22')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1846', '2837', '521', '2023-01-02', '1', '14.139.206.130', '521', '2023-01-02 11:39:56', '', '')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2430', '0', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2430', '1', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2430', '2', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2430', '3', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2430', '4', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2430', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2430', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2430', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2430', '', '', 'Array', '', 'Array', '', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"521","date":"2023-01-02 11:39:56","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2430', '14.139.206.130', '521', '2023-01-02 11:39:56')"}
{"userId":"530","date":"2023-01-02 11:40:15","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1732', '2023-01-09', '530', '14.139.216.43', '530', '2023-01-02 11:40:15')"}
{"userId":"530","date":"2023-01-02 11:41:03","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '14.139.216.43', `modifiedby` = '530', `modifieddate` = '2023-01-02 11:41:03' WHERE plansiteid = '2838'"}
{"userId":"530","date":"2023-01-02 11:41:03","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '14.139.216.43', `modifiedby` = '530', `modifieddate` = '2023-01-02 11:41:03' WHERE ssid = ''"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE sitesupervision SET `siteid` = '1846', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '2', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18', `locationtype` = '1', `establishmentyear` = '2022', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2430'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE onsitestaffs SET `staffname` = 'hrushikesh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE onssid = '10048'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE onssid = '10049'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE onssid = '10050'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE onssid = '10051'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225362 then '' when ansid=225363 then '' when ansid=225364 then '' when ansid=225365 then '' when ansid=225366 then ''  when ansid=225367 then ''   when ansid=225368 then ''  when ansid=225468 then '' when ansid=225469 then '' when ansid=225411 then '' when ansid=225413 then '' when ansid=225415 then '' when ansid=225417 then '' when ansid=225419 then '' when ansid=225421 then '' when ansid=225422 then '' when ansid=225423 then '' when ansid=225424 then ''  when ansid=225425 then ''   when ansid=225426 then ''  when ansid=225427 then ''  when ansid=225428 then ''   when ansid=225429 then ''   when ansid=225430 then ''   when ansid=225431 then ''  when ansid=225432 then '' when ansid=225433 then '' when ansid=225434 then ''  when ansid=225435 then ''   when ansid=225436 then ''   when ansid=225437 then ''   when ansid=225438 then ''  when ansid=225439 then ''  when ansid=225440 then ''   when ansid=225441 then ''  when ansid=225442 then '' when ansid=225443 then '' when ansid=225444 then '' when ansid=225445 then '' when ansid=225446 then '' when ansid=225447 then '' when ansid=225448 then '' when ansid=225449 then '' when ansid=225450 then ''  when ansid=225451 then ''   when ansid=225452 then ''   when ansid=225453 then ''   when ansid=225454 then ''  when ansid=225455 then '' when ansid=225456 then ''  when ansid=225457 then ''   when ansid=225458 then ''  when ansid=225459 then '' when ansid=225460 then '' when ansid=225461 then '' when ansid=225462 then '' when ansid=225463 then '' when ansid=225464 then '' when ansid=225465 then '' when ansid=225466 then '' when ansid=225467 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 11:42:18'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225362','225363','225364','225365','225366','225367','225368','225468','225469','225411','225413','225415','225417','225419','225421','225422','225423','225424','225425','225426','225427','225428','225429','225430','225431','225432','225433','225434','225435','225436','225437','225438','225439','225440','225441','225442','225443','225444','225445','225446','225447','225448','225449','225450','225451','225452','225453','225454','225455','225456','225457','225458','225459','225460','225461','225462','225463','225464','225465','225466','225467')"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE supvisstepid = '12020'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE visitfeedbackid = '11926'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE visitfeedbackid = '11927'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE visitfeedbackid = '11928'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE visitfeedbackid = '11929'"}
{"userId":"521","date":"2023-01-02 11:42:18","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:18' WHERE visitfeedbackid = '11930'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE sitesupervision SET `siteid` = '1846', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '2', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53', `locationtype` = '1', `establishmentyear` = '2022', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2430'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE onsitestaffs SET `staffname` = 'hrushikesh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE onssid = '10048'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE onssid = '10049'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE onssid = '10050'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE onssid = '10051'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225362 then '1' when ansid=225363 then '1' when ansid=225364 then '1' when ansid=225365 then '' when ansid=225366 then ''  when ansid=225367 then ''   when ansid=225368 then '1'  when ansid=225468 then '1' when ansid=225469 then '1' when ansid=225411 then '' when ansid=225413 then '' when ansid=225415 then '' when ansid=225417 then '' when ansid=225419 then '' when ansid=225421 then '' when ansid=225422 then '' when ansid=225423 then '' when ansid=225424 then ''  when ansid=225425 then ''   when ansid=225426 then ''  when ansid=225427 then ''  when ansid=225428 then ''   when ansid=225429 then ''   when ansid=225430 then ''   when ansid=225431 then ''  when ansid=225432 then '' when ansid=225433 then '' when ansid=225434 then ''  when ansid=225435 then ''   when ansid=225436 then ''   when ansid=225437 then ''   when ansid=225438 then ''  when ansid=225439 then ''  when ansid=225440 then ''   when ansid=225441 then ''  when ansid=225442 then '' when ansid=225443 then '' when ansid=225444 then '' when ansid=225445 then '' when ansid=225446 then '' when ansid=225447 then '' when ansid=225448 then '' when ansid=225449 then '' when ansid=225450 then ''  when ansid=225451 then ''   when ansid=225452 then ''   when ansid=225453 then ''   when ansid=225454 then ''  when ansid=225455 then '' when ansid=225456 then ''  when ansid=225457 then ''   when ansid=225458 then ''  when ansid=225459 then '' when ansid=225460 then '' when ansid=225461 then '' when ansid=225462 then '' when ansid=225463 then '' when ansid=225464 then '' when ansid=225465 then '' when ansid=225466 then '' when ansid=225467 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 11:42:53'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225362','225363','225364','225365','225366','225367','225368','225468','225469','225411','225413','225415','225417','225419','225421','225422','225423','225424','225425','225426','225427','225428','225429','225430','225431','225432','225433','225434','225435','225436','225437','225438','225439','225440','225441','225442','225443','225444','225445','225446','225447','225448','225449','225450','225451','225452','225453','225454','225455','225456','225457','225458','225459','225460','225461','225462','225463','225464','225465','225466','225467')"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE supvisstepid = '12021'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE visitfeedbackid = '11926'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE visitfeedbackid = '11927'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE visitfeedbackid = '11928'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE visitfeedbackid = '11929'"}
{"userId":"521","date":"2023-01-02 11:42:53","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:42:53' WHERE visitfeedbackid = '11930'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE sitesupervision SET `siteid` = '1846', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '2', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51', `locationtype` = '1', `establishmentyear` = '2022', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2430'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE onsitestaffs SET `staffname` = 'hrushikesh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE onssid = '10048'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE onssid = '10049'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE onssid = '10050'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE onssid = '10051'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225362 then '1' when ansid=225363 then '1' when ansid=225364 then '1' when ansid=225365 then '' when ansid=225366 then ''  when ansid=225367 then ''   when ansid=225368 then '1'  when ansid=225468 then '1' when ansid=225469 then '1' when ansid=225411 then '1' when ansid=225413 then '1' when ansid=225415 then '1' when ansid=225417 then '100' when ansid=225419 then '10' when ansid=225421 then '' when ansid=225422 then '' when ansid=225423 then '' when ansid=225424 then ''  when ansid=225425 then ''   when ansid=225426 then ''  when ansid=225427 then ''  when ansid=225428 then ''   when ansid=225429 then ''   when ansid=225430 then ''   when ansid=225431 then ''  when ansid=225432 then '' when ansid=225433 then '' when ansid=225434 then ''  when ansid=225435 then ''   when ansid=225436 then ''   when ansid=225437 then ''   when ansid=225438 then ''  when ansid=225439 then ''  when ansid=225440 then ''   when ansid=225441 then ''  when ansid=225442 then '' when ansid=225443 then '' when ansid=225444 then '' when ansid=225445 then '' when ansid=225446 then '' when ansid=225447 then '' when ansid=225448 then '' when ansid=225449 then '' when ansid=225450 then ''  when ansid=225451 then ''   when ansid=225452 then ''   when ansid=225453 then ''   when ansid=225454 then ''  when ansid=225455 then '' when ansid=225456 then ''  when ansid=225457 then ''   when ansid=225458 then ''  when ansid=225459 then '' when ansid=225460 then '' when ansid=225461 then '' when ansid=225462 then '' when ansid=225463 then '' when ansid=225464 then '' when ansid=225465 then '' when ansid=225466 then '' when ansid=225467 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 11:43:51'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225362','225363','225364','225365','225366','225367','225368','225468','225469','225411','225413','225415','225417','225419','225421','225422','225423','225424','225425','225426','225427','225428','225429','225430','225431','225432','225433','225434','225435','225436','225437','225438','225439','225440','225441','225442','225443','225444','225445','225446','225447','225448','225449','225450','225451','225452','225453','225454','225455','225456','225457','225458','225459','225460','225461','225462','225463','225464','225465','225466','225467')"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE supvisstepid = '12022'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE visitfeedbackid = '11926'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE visitfeedbackid = '11927'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE visitfeedbackid = '11928'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE visitfeedbackid = '11929'"}
{"userId":"521","date":"2023-01-02 11:43:51","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:43:51' WHERE visitfeedbackid = '11930'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE sitesupervision SET `siteid` = '1846', `userid` = '521', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '2', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43', `locationtype` = '1', `establishmentyear` = '2022', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2430'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE onsitestaffs SET `staffname` = 'hrushikesh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE onssid = '10048'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE onssid = '10049'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE onssid = '10050'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE onssid = '10051'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225362 then '1' when ansid=225363 then '1' when ansid=225364 then '1' when ansid=225365 then '' when ansid=225366 then ''  when ansid=225367 then ''   when ansid=225368 then '1'  when ansid=225468 then '1' when ansid=225469 then '1' when ansid=225411 then '1' when ansid=225413 then '1' when ansid=225415 then '1' when ansid=225417 then '100' when ansid=225419 then '10' when ansid=225421 then '2' when ansid=225422 then '3' when ansid=225423 then '3' when ansid=225424 then '3'  when ansid=225425 then ''   when ansid=225426 then '1'  when ansid=225427 then '1'  when ansid=225428 then ''   when ansid=225429 then '1'   when ansid=225430 then ''   when ansid=225431 then '1'  when ansid=225432 then '4' when ansid=225433 then '1' when ansid=225434 then '2'  when ansid=225435 then ''   when ansid=225436 then '1'   when ansid=225437 then ''   when ansid=225438 then '1'  when ansid=225439 then '1'  when ansid=225440 then ''   when ansid=225441 then '1'  when ansid=225442 then '1' when ansid=225443 then '1' when ansid=225444 then '2' when ansid=225445 then '1' when ansid=225446 then '1' when ansid=225447 then '1' when ansid=225448 then '1' when ansid=225449 then '1' when ansid=225450 then '1'  when ansid=225451 then ''   when ansid=225452 then '1'   when ansid=225453 then ''   when ansid=225454 then '1'  when ansid=225455 then '1' when ansid=225456 then '1'  when ansid=225457 then ''   when ansid=225458 then '1'  when ansid=225459 then '1' when ansid=225460 then '1' when ansid=225461 then '1' when ansid=225462 then '1' when ansid=225463 then '0' when ansid=225464 then 'xnxn' when ansid=225465 then 'n n' when ansid=225466 then 'jnk' when ansid=225467 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '14.139.206.130',\r\n\t\t\t\t\t\t\t\tmodifiedby =521,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-02 11:50:43'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225362','225363','225364','225365','225366','225367','225368','225468','225469','225411','225413','225415','225417','225419','225421','225422','225423','225424','225425','225426','225427','225428','225429','225430','225431','225432','225433','225434','225435','225436','225437','225438','225439','225440','225441','225442','225443','225444','225445','225446','225447','225448','225449','225450','225451','225452','225453','225454','225455','225456','225457','225458','225459','225460','225461','225462','225463','225464','225465','225466','225467')"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE supvisstepid = '12023'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE visitfeedbackid = '11926'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE visitfeedbackid = '11927'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE visitfeedbackid = '11928'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE visitfeedbackid = '11929'"}
{"userId":"521","date":"2023-01-02 11:50:43","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '521', `modifieddate` = '2023-01-02 11:50:43' WHERE visitfeedbackid = '11930'"}
{"userId":"544","date":"2023-01-02 11:50:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2023-01-02 11:50:50')"}
{"userId":"570","date":"2023-01-02 13:13:09","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('570', '152.58.177.221', '2023-01-02 13:13:09')"}
{"userId":"86","date":"2023-01-02 13:14:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('86', '14.139.220.222', '2023-01-02 13:14:58')"}
{"userId":"7","date":"2023-01-02 13:50:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-01-02 13:50:15')"}
{"userId":null,"date":"2023-01-02 13:53:53","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('502', '728542', '0', '152.58.182.220', '', '2023-01-02 13:53:53')"}
{"userId":"77","date":"2023-01-02 13:54:11","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('77', '14.139.220.222', '2023-01-02 13:54:11')"}
{"userId":null,"date":"2023-01-02 13:54:48","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('502', '823340', '0', '152.58.182.220', '', '2023-01-02 13:54:48')"}
{"userId":null,"date":"2023-01-02 13:56:11","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('502', '233247', '0', '152.58.182.220', '', '2023-01-02 13:56:11')"}
{"userId":"86","date":"2023-01-02 14:04:15","query":"UPDATE usermst SET `ipaddress` = '14.139.220.222', `modifiedby` = '86', `modifieddate` = '2023-01-02 14:04:15', `isdeleted` = '1' WHERE userid = '502'"}
{"userId":"86","date":"2023-01-02 14:06:20","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Subrata', 'Biswas', 'sai_brata@yahoo.com', '8777580239', 'Project Cordinator', 'ICMR-NICED', '964f6e5e3e4d06e60ea42862b1296843', '4', '14.139.220.222', '86', '2023-01-02 14:06:20')"}
{"userId":"86","date":"2023-01-02 14:06:20","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('620', '101', '41', '695', '4', '0', '14.139.220.222', '86', '2023-01-02 14:06:20')"}
{"userId":"620","date":"2023-01-02 14:06:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('620', '152.58.182.220', '2023-01-02 14:06:40')"}
{"userId":"86","date":"2023-01-02 14:07:16","query":"UPDATE usermst SET `ipaddress` = '14.139.220.222', `modifiedby` = '86', `modifieddate` = '2023-01-02 14:07:16', `isdeleted` = '1' WHERE userid = '77'"}
{"userId":"7","date":"2023-01-02 14:08:38","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2023-01-02 14:08:38', `isdeleted` = '1' WHERE userid = '248'"}
{"userId":"86","date":"2023-01-02 14:08:44","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('86', '14.139.220.222', '2023-01-02 14:08:44')"}
{"userId":"86","date":"2023-01-02 14:10:57","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Piyali', 'Ghosh', 'piyali1ster@gmail.com', '9433312360', 'Research Officer', 'ICMR-NICED', '5f4ed4ea2193bfd81ce845dd7e6b3904', '4', '14.139.220.222', '86', '2023-01-02 14:10:57')"}
{"userId":"86","date":"2023-01-02 14:10:57","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('621', '101', '41', '695', '4', '0', '14.139.220.222', '86', '2023-01-02 14:10:57')"}
{"userId":"7","date":"2023-01-02 14:11:05","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr. Kedar', 'Padhye', 'researchofficerhss@gmail.com', '8882350793', 'Research Officer', 'NARI', 'a41be83cc1a0f48d1cd71ea27519ec4a', '4', '14.139.125.18', '7', '2023-01-02 14:11:05')"}
{"userId":"7","date":"2023-01-02 14:11:05","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('622', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:11:05')"}
{"userId":"621","date":"2023-01-02 14:11:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('621', '14.139.220.222', '2023-01-02 14:11:14')"}
{"userId":"7","date":"2023-01-02 14:11:59","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2023-01-02 14:11:59', `isdeleted` = '1' WHERE userid = '618'"}
{"userId":"7","date":"2023-01-02 14:15:26","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr. Prachi', 'Phadke', 'hss.resofficer@gmail.com', '9022875883', 'Research Officer (Field)', 'NARI', '626557a7af4b2d4e839466b75a81afa8', '4', '14.139.125.18', '7', '2023-01-02 14:15:26')"}
{"userId":"7","date":"2023-01-02 14:15:26","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('623', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:15:26')"}
{"userId":"7","date":"2023-01-02 14:15:51","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2023-01-02 14:15:51', `isdeleted` = '1' WHERE userid = '259'"}
{"userId":"7","date":"2023-01-02 14:17:53","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Garima', 'Meena', 'projectcoordinator.hss@gmail.com', '8882350793', 'Project Coordinator', 'NARI', '64485f6f0f0e7726ad67d4b02be66501', '4', '14.139.125.18', '7', '2023-01-02 14:17:53')"}
{"userId":"7","date":"2023-01-02 14:17:53","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('624', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:17:53')"}
{"userId":"624","date":"2023-01-02 14:18:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('624', '14.139.125.18', '2023-01-02 14:18:21')"}
{"userId":"617","date":"2023-01-02 14:18:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('617', '14.139.125.18', '2023-01-02 14:18:40')"}
{"userId":"622","date":"2023-01-02 14:18:58","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('622', '14.139.125.18', '2023-01-02 14:18:58')"}
{"userId":"623","date":"2023-01-02 14:19:24","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('623', '14.139.125.18', '2023-01-02 14:19:24')"}
{"userId":"571","date":"2023-01-02 14:19:43","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('571', '14.139.125.18', '2023-01-02 14:19:43')"}
{"userId":"7","date":"2023-01-02 14:20:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-01-02 14:20:08')"}
{"userId":"7","date":"2023-01-02 14:20:28","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2023-01-02 14:20:28', `isdeleted` = '1' WHERE userid = '520'"}
{"userId":"7","date":"2023-01-02 14:23:39","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr. Aditi', 'Kulkarni', 'juniorconsultant.hss@gmail.com', '9538245885', 'Jr. Consultant Epidemiologist', 'NARI', '4cbd72fb804cc9cdb72c20a1c6d57c42', '4', '14.139.125.18', '7', '2023-01-02 14:23:39')"}
{"userId":"7","date":"2023-01-02 14:23:39","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('625', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:23:39')"}
{"userId":"625","date":"2023-01-02 14:24:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('625', '14.139.125.18', '2023-01-02 14:24:00')"}
{"userId":"7","date":"2023-01-02 14:24:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-01-02 14:24:25')"}
{"userId":"7","date":"2023-01-02 14:26:50","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr. Prasad', 'Patil', 'hss.deo02@gmail.com', '9890092939', 'Data Entry Operator', 'NARI', 'c772a4f734104424ec25b124e0338e93', '4', '14.139.125.18', '7', '2023-01-02 14:26:50')"}
{"userId":"7","date":"2023-01-02 14:26:50","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('626', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:26:50')"}
{"userId":"7","date":"2023-01-02 14:29:31","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Mr. Kiran', 'Walikar', 'kiran.hss.deo@gmail.com', '7350004605', 'Data Entry Operator', 'NARI', 'fcf8483b6082f0a86776f0a868753f1f', '4', '14.139.125.18', '7', '2023-01-02 14:29:31')"}
{"userId":"7","date":"2023-01-02 14:29:31","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('627', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2023-01-02 14:29:31')"}
{"userId":"626","date":"2023-01-02 14:29:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('626', '14.139.125.18', '2023-01-02 14:29:59')"}
{"userId":"627","date":"2023-01-02 14:30:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('627', '14.139.125.18', '2023-01-02 14:30:12')"}
{"userId":"543","date":"2023-01-02 15:05:39","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('543', '14.139.206.130', '2023-01-02 15:05:39')"}
{"userId":"543","date":"2023-01-02 15:06:37","query":"UPDATE usermst SET `password` = '1cbbdd7f68f0f242c854a02532938daf', `modifiedby` = '543', `modifieddate` = '2023-01-02 15:06:37', `ipaddress` = '14.139.206.130' WHERE userid = '543'"}
{"userId":"541","date":"2023-01-02 15:13:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('541', '14.139.206.130', '2023-01-02 15:13:04')"}
{"userId":"542","date":"2023-01-02 15:19:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('542', '14.139.206.130', '2023-01-02 15:19:25')"}
{"userId":"542","date":"2023-01-02 15:20:05","query":"UPDATE usermst SET `password` = 'e4392e61866ab845cda2000dd15049cf', `modifiedby` = '542', `modifieddate` = '2023-01-02 15:20:05', `ipaddress` = '14.139.206.130' WHERE userid = '542'"}
{"userId":"541","date":"2023-01-02 15:23:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('541', '14.139.206.130', '2023-01-02 15:23:07')"}
{"userId":"542","date":"2023-01-02 15:23:21","query":"UPDATE usermst SET `password` = 'e4392e61866ab845cda2000dd15049cf', `modifiedby` = '542', `modifieddate` = '2023-01-02 15:23:21', `ipaddress` = '14.139.206.130' WHERE userid = '542'"}
{"userId":"541","date":"2023-01-02 15:23:46","query":"UPDATE usermst SET `password` = 'fef6ab90774a0ddeef754ee0c8fd41cc', `modifiedby` = '541', `modifieddate` = '2023-01-02 15:23:46', `ipaddress` = '14.139.206.130' WHERE userid = '541'"}
{"userId":"541","date":"2023-01-02 15:24:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('541', '14.139.206.130', '2023-01-02 15:24:13')"}
{"userId":"542","date":"2023-01-02 15:24:14","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('542', '14.139.206.130', '2023-01-02 15:24:14')"}
{"userId":"541","date":"2023-01-02 15:28:14","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('950', '2023-01-09', '541', '14.139.206.130', '541', '2023-01-02 15:28:14')"}
{"userId":"541","date":"2023-01-02 15:28:29","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('951', '2023-01-09', '541', '14.139.206.130', '541', '2023-01-02 15:28:29')"}
{"userId":"541","date":"2023-01-02 15:30:25","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('952', '2023-01-10', '541', '14.139.206.130', '541', '2023-01-02 15:30:25')"}
{"userId":"541","date":"2023-01-02 15:30:42","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('954', '2023-01-11', '541', '14.139.206.130', '541', '2023-01-02 15:30:42')"}
{"userId":"541","date":"2023-01-02 15:31:30","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('956', '2023-01-13', '541', '14.139.206.130', '541', '2023-01-02 15:31:30')"}
{"userId":"541","date":"2023-01-02 15:31:58","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('945', '2023-01-14', '541', '14.139.206.130', '541', '2023-01-02 15:31:58')"}
{"userId":"7","date":"2023-01-02 16:19:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2023-01-02 16:19:13')"}