{"userId":"7","date":"2022-12-30 09:22:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2022-12-30 09:22:01')"}
{"userId":"7","date":"2022-12-30 09:27:38","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('SDH Panvel', '1', '22', '5', '381', '27204012', '0', '400', '14.139.125.18', '7', '2022-12-30 09:27:38')"}
{"userId":"7","date":"2022-12-30 09:30:13","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('CHC Niwari', '1', '21', '5', '0', '23718011', '0', '400', '14.139.125.18', '7', '2022-12-30 09:30:13')"}
{"userId":"7","date":"2022-12-30 09:51:02","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Central Jail, Kota', '2', '33', '5', '509', '08565131', '0', '250', '14.139.125.18', '7', '2022-12-30 09:51:02')"}
{"userId":"7","date":"2022-12-30 09:51:03","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Central Jail, Kota', '2', '33', '5', '509', '08565131', '0', '250', '14.139.125.18', '7', '2022-12-30 09:51:03')"}
{"userId":"7","date":"2022-12-30 09:51:57","query":"UPDATE sitemst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 09:51:57', `isdeleted` = '1' WHERE siteid = '1798'"}
{"userId":"7","date":"2022-12-30 09:52:08","query":"UPDATE sitemst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 09:52:08', `isdeleted` = '1' WHERE siteid = '1801'"}
{"userId":"7","date":"2022-12-30 10:19:36","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Humsath Trust, Margao', '3', '11', '5', '145', '30122043', '0', '250', '14.139.125.18', '7', '2022-12-30 10:19:36')"}
{"userId":"7","date":"2022-12-30 10:20:43","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('All India Insitutute of Local Self Government', '3', '12', '5', '0', '24306062', '0', '250', '14.139.125.18', '7', '2022-12-30 10:20:43')"}
{"userId":"7","date":"2022-12-30 10:22:02","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('New Pratap Shiksha Samiti', '3', '21', '5', '337', '23288081', '0', '250', '14.139.125.18', '7', '2022-12-30 10:22:02')"}
{"userId":"7","date":"2022-12-30 10:22:48","query":"UPDATE sitemst SET `sitename` = 'All India Insitutute of Local Self Government', `sitetype` = '3', `stateid` = '12', `regionid` = '5', `districtid` = '146', `sitecode` = '24306062', `subsitecode` = '0', `samplesize` = '250', `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 10:22:48' WHERE siteid = '1804'"}
{"userId":"7","date":"2022-12-30 10:24:05","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Advance Information Management Society (AIMS)', '3', '21', '5', '318', '23277072', '0', '250', '14.139.125.18', '7', '2022-12-30 10:24:05')"}
{"userId":"7","date":"2022-12-30 10:24:56","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Abhudaya Sansthan', '', '21', '5', '312', '23286051', '0', '250', '14.139.125.18', '7', '2022-12-30 10:24:56')"}
{"userId":"7","date":"2022-12-30 10:25:46","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Aadarsh Janseva Sansthan Indore', '3', '21', '5', '326', '', '0', '250', '14.139.125.18', '7', '2022-12-30 10:25:46')"}
{"userId":"7","date":"2022-12-30 10:26:46","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Humsaya Welfare Sanstha', '3', '22', '5', '371', '27202052', '0', '250', '14.139.125.18', '7', '2022-12-30 10:26:46')"}
{"userId":"7","date":"2022-12-30 10:27:23","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('SRKPS', '3', '33', '5', '509', '08565061', '0', '250', '14.139.125.18', '7', '2022-12-30 10:27:23')"}
{"userId":"7","date":"2022-12-30 10:28:01","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Society For Conscious Overall Progress', '3', '33', '5', '502', '08547071', '0', '250', '14.139.125.18', '7', '2022-12-30 10:28:01')"}
{"userId":"7","date":"2022-12-30 11:14:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2022-12-30 11:14:59')"}
{"userId":"586","date":"2022-12-30 12:09:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('586', '117.236.175.50', '2022-12-30 12:09:23')"}
{"userId":"578","date":"2022-12-30 12:32:52","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('578', '112.133.207.122', '2022-12-30 12:32:52')"}
{"userId":"578","date":"2022-12-30 12:33:21","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1529', '2022-12-30', '578', '14.139.190.202', '578', '2022-12-30 12:33:21')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1529', '2829', '578', '2022-12-30', '1', '14.139.190.202', '578', '2022-12-30 12:33:43', '', '')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2426', '0', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2426', '1', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2426', '2', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2426', '3', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2426', '', '', 'Array', '', 'Array', '', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2426', '', '', 'Array', '', 'Array', '', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2426', '', '', 'Array', '', 'Array', '', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2426', '', '', 'Array', '', 'Array', '', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"578","date":"2022-12-30 12:33:43","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2426', '14.139.190.202', '578', '2022-12-30 12:33:43')"}
{"userId":"7","date":"2022-12-30 14:40:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2022-12-30 14:40:12')"}
{"userId":"7","date":"2022-12-30 14:41:37","query":"UPDATE sitemst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 14:41:37', `isdeleted` = '1' WHERE siteid = '1712'"}
{"userId":"539","date":"2022-12-30 15:57:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('539', '14.139.206.130', '2022-12-30 15:57:16')"}
{"userId":"7","date":"2022-12-30 16:16:43","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2022-12-30 16:16:43')"}
{"userId":"539","date":"2022-12-30 16:22:36","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('931', '2022-12-30', '539', '14.139.206.130', '539', '2022-12-30 16:22:36')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('931', '2830', '539', '2022-12-30', '1', '14.139.206.130', '539', '2022-12-30 16:23:12', '', '')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2427', '0', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2427', '1', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2427', '2', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2427', '3', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2427', '4', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2427', '', '', 'Array', '', 'Array', '', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2427', '', '', 'Array', '', 'Array', '', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2427', '', '', 'Array', '', 'Array', '', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2427', '', '', 'Array', '', 'Array', '', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:23:12","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2427', '14.139.206.130', '539', '2022-12-30 16:23:12')"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE sitesupervision SET `siteid` = '931', `userid` = '539', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-12-30', `numofsamplecollected` = '12', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2427'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE onsitestaffs SET `staffname` = 'ss', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE onssid = '10036'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE onssid = '10037'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE onssid = '10038'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE onssid = '10039'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225038 then '' when ansid=225039 then '' when ansid=225040 then '' when ansid=225041 then '' when ansid=225042 then ''  when ansid=225043 then ''   when ansid=225044 then ''  when ansid=225144 then '' when ansid=225145 then '' when ansid=225087 then '' when ansid=225089 then '' when ansid=225091 then '' when ansid=225093 then '' when ansid=225095 then '' when ansid=225097 then '' when ansid=225098 then '' when ansid=225099 then '' when ansid=225100 then ''  when ansid=225101 then ''   when ansid=225102 then ''  when ansid=225103 then ''  when ansid=225104 then ''   when ansid=225105 then ''   when ansid=225106 then ''   when ansid=225107 then ''  when ansid=225108 then '' when ansid=225109 then '' when ansid=225110 then ''  when ansid=225111 then ''   when ansid=225112 then ''   when ansid=225113 then ''   when ansid=225114 then ''  when ansid=225115 then ''  when ansid=225116 then ''   when ansid=225117 then ''  when ansid=225118 then '' when ansid=225119 then '' when ansid=225120 then '' when ansid=225121 then '' when ansid=225122 then '' when ansid=225123 then '' when ansid=225124 then '' when ansid=225125 then '' when ansid=225126 then ''  when ansid=225127 then ''   when ansid=225128 then ''   when ansid=225129 then ''   when ansid=225130 then ''  when ansid=225131 then '' when ansid=225132 then ''  when ansid=225133 then ''   when ansid=225134 then ''  when ansid=225135 then '' when ansid=225136 then '' when ansid=225137 then '' when ansid=225138 then '' when ansid=225139 then '' when ansid=225140 then '' when ansid=225141 then '' when ansid=225142 then '' when ansid=225143 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 =539,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-12-30 16:25:29'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225038','225039','225040','225041','225042','225043','225044','225144','225145','225087','225089','225091','225093','225095','225097','225098','225099','225100','225101','225102','225103','225104','225105','225106','225107','225108','225109','225110','225111','225112','225113','225114','225115','225116','225117','225118','225119','225120','225121','225122','225123','225124','225125','225126','225127','225128','225129','225130','225131','225132','225133','225134','225135','225136','225137','225138','225139','225140','225141','225142','225143')"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE supvisstepid = '12005'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE visitfeedbackid = '11911'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE visitfeedbackid = '11912'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE visitfeedbackid = '11913'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE visitfeedbackid = '11914'"}
{"userId":"539","date":"2022-12-30 16:25:29","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:25:29' WHERE visitfeedbackid = '11915'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE sitesupervision SET `siteid` = '931', `userid` = '539', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-12-30', `numofsamplecollected` = '12', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2427'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE onsitestaffs SET `staffname` = 'ss', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE onssid = '10036'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE onssid = '10037'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE onssid = '10038'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE onssid = '10039'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225038 then '1' when ansid=225039 then '1' when ansid=225040 then '1' when ansid=225041 then '' when ansid=225042 then ''  when ansid=225043 then ''   when ansid=225044 then '1'  when ansid=225144 then '1' when ansid=225145 then '1' when ansid=225087 then '' when ansid=225089 then '' when ansid=225091 then '' when ansid=225093 then '' when ansid=225095 then '' when ansid=225097 then '' when ansid=225098 then '' when ansid=225099 then '' when ansid=225100 then ''  when ansid=225101 then ''   when ansid=225102 then ''  when ansid=225103 then ''  when ansid=225104 then ''   when ansid=225105 then ''   when ansid=225106 then ''   when ansid=225107 then ''  when ansid=225108 then '' when ansid=225109 then '' when ansid=225110 then ''  when ansid=225111 then ''   when ansid=225112 then ''   when ansid=225113 then ''   when ansid=225114 then ''  when ansid=225115 then ''  when ansid=225116 then ''   when ansid=225117 then ''  when ansid=225118 then '' when ansid=225119 then '' when ansid=225120 then '' when ansid=225121 then '' when ansid=225122 then '' when ansid=225123 then '' when ansid=225124 then '' when ansid=225125 then '' when ansid=225126 then ''  when ansid=225127 then ''   when ansid=225128 then ''   when ansid=225129 then ''   when ansid=225130 then ''  when ansid=225131 then '' when ansid=225132 then ''  when ansid=225133 then ''   when ansid=225134 then ''  when ansid=225135 then '' when ansid=225136 then '' when ansid=225137 then '' when ansid=225138 then '' when ansid=225139 then '' when ansid=225140 then '' when ansid=225141 then '' when ansid=225142 then '' when ansid=225143 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 =539,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-12-30 16:26:33'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225038','225039','225040','225041','225042','225043','225044','225144','225145','225087','225089','225091','225093','225095','225097','225098','225099','225100','225101','225102','225103','225104','225105','225106','225107','225108','225109','225110','225111','225112','225113','225114','225115','225116','225117','225118','225119','225120','225121','225122','225123','225124','225125','225126','225127','225128','225129','225130','225131','225132','225133','225134','225135','225136','225137','225138','225139','225140','225141','225142','225143')"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE supvisstepid = '12006'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE visitfeedbackid = '11911'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE visitfeedbackid = '11912'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE visitfeedbackid = '11913'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE visitfeedbackid = '11914'"}
{"userId":"539","date":"2022-12-30 16:26:33","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:33' WHERE visitfeedbackid = '11915'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE sitesupervision SET `siteid` = '931', `userid` = '539', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-12-30', `numofsamplecollected` = '12', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2427'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE onsitestaffs SET `staffname` = 'ss', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE onssid = '10036'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE onssid = '10037'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE onssid = '10038'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE onssid = '10039'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225038 then '1' when ansid=225039 then '1' when ansid=225040 then '1' when ansid=225041 then '' when ansid=225042 then ''  when ansid=225043 then ''   when ansid=225044 then '1'  when ansid=225144 then '1' when ansid=225145 then '1' when ansid=225087 then '1' when ansid=225089 then '1' when ansid=225091 then '1' when ansid=225093 then '1' when ansid=225095 then '1' when ansid=225097 then '' when ansid=225098 then '' when ansid=225099 then '' when ansid=225100 then ''  when ansid=225101 then ''   when ansid=225102 then ''  when ansid=225103 then ''  when ansid=225104 then ''   when ansid=225105 then ''   when ansid=225106 then ''   when ansid=225107 then ''  when ansid=225108 then '' when ansid=225109 then '' when ansid=225110 then ''  when ansid=225111 then ''   when ansid=225112 then ''   when ansid=225113 then ''   when ansid=225114 then ''  when ansid=225115 then ''  when ansid=225116 then ''   when ansid=225117 then ''  when ansid=225118 then '' when ansid=225119 then '' when ansid=225120 then '' when ansid=225121 then '' when ansid=225122 then '' when ansid=225123 then '' when ansid=225124 then '' when ansid=225125 then '' when ansid=225126 then ''  when ansid=225127 then ''   when ansid=225128 then ''   when ansid=225129 then ''   when ansid=225130 then ''  when ansid=225131 then '' when ansid=225132 then ''  when ansid=225133 then ''   when ansid=225134 then ''  when ansid=225135 then '' when ansid=225136 then '' when ansid=225137 then '' when ansid=225138 then '' when ansid=225139 then '' when ansid=225140 then '' when ansid=225141 then '' when ansid=225142 then '' when ansid=225143 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 =539,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-12-30 16:26:57'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225038','225039','225040','225041','225042','225043','225044','225144','225145','225087','225089','225091','225093','225095','225097','225098','225099','225100','225101','225102','225103','225104','225105','225106','225107','225108','225109','225110','225111','225112','225113','225114','225115','225116','225117','225118','225119','225120','225121','225122','225123','225124','225125','225126','225127','225128','225129','225130','225131','225132','225133','225134','225135','225136','225137','225138','225139','225140','225141','225142','225143')"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE supvisstepid = '12007'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE visitfeedbackid = '11911'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE visitfeedbackid = '11912'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE visitfeedbackid = '11913'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE visitfeedbackid = '11914'"}
{"userId":"539","date":"2022-12-30 16:26:57","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:26:57' WHERE visitfeedbackid = '11915'"}
{"userId":"7","date":"2022-12-30 16:30:43","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 16:30:43', `isdeleted` = '1' WHERE userid = '250'"}
{"userId":"544","date":"2022-12-30 16:30:59","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 16:30:59')"}
{"userId":"7","date":"2022-12-30 16:31:02","query":"UPDATE usermst SET `ipaddress` = '14.139.125.18', `modifiedby` = '7', `modifieddate` = '2022-12-30 16:31:02', `isdeleted` = '1' WHERE userid = '251'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE sitesupervision SET `siteid` = '931', `userid` = '539', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2022-12-30', `numofsamplecollected` = '12', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2427'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE onsitestaffs SET `staffname` = 'ss', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '01', `istrained` = '1', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE onssid = '10036'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE onssid = '10037'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE onssid = '10038'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE onssid = '10039'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225038 then '1' when ansid=225039 then '1' when ansid=225040 then '1' when ansid=225041 then '' when ansid=225042 then ''  when ansid=225043 then ''   when ansid=225044 then '1'  when ansid=225144 then '1' when ansid=225145 then '1' when ansid=225087 then '1' when ansid=225089 then '1' when ansid=225091 then '1' when ansid=225093 then '1' when ansid=225095 then '1' when ansid=225097 then '1' when ansid=225098 then '2' when ansid=225099 then '2' when ansid=225100 then '2'  when ansid=225101 then ''   when ansid=225102 then '1'  when ansid=225103 then '1'  when ansid=225104 then ''   when ansid=225105 then '1'   when ansid=225106 then ''   when ansid=225107 then '1'  when ansid=225108 then '3' when ansid=225109 then '1' when ansid=225110 then '1'  when ansid=225111 then ''   when ansid=225112 then '1'   when ansid=225113 then ''   when ansid=225114 then '1'  when ansid=225115 then '1'  when ansid=225116 then ''   when ansid=225117 then '1'  when ansid=225118 then '2' when ansid=225119 then '1' when ansid=225120 then '1' when ansid=225121 then '1' when ansid=225122 then '2' when ansid=225123 then '3' when ansid=225124 then '1' when ansid=225125 then '1' when ansid=225126 then '1'  when ansid=225127 then ''   when ansid=225128 then '3'   when ansid=225129 then ''   when ansid=225130 then '1'  when ansid=225131 then '1' when ansid=225132 then '1'  when ansid=225133 then ''   when ansid=225134 then '1'  when ansid=225135 then '1' when ansid=225136 then '1' when ansid=225137 then '1' when ansid=225138 then '1' when ansid=225139 then '1' when ansid=225140 then 'no' when ansid=225141 then 'yes' when ansid=225142 then 'nmn,m' when ansid=225143 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 =539,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2022-12-30 16:32:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225038','225039','225040','225041','225042','225043','225044','225144','225145','225087','225089','225091','225093','225095','225097','225098','225099','225100','225101','225102','225103','225104','225105','225106','225107','225108','225109','225110','225111','225112','225113','225114','225115','225116','225117','225118','225119','225120','225121','225122','225123','225124','225125','225126','225127','225128','225129','225130','225131','225132','225133','225134','225135','225136','225137','225138','225139','225140','225141','225142','225143')"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE supvisstepid = '12008'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE visitfeedbackid = '11911'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE visitfeedbackid = '11912'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE visitfeedbackid = '11913'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE visitfeedbackid = '11914'"}
{"userId":"539","date":"2022-12-30 16:32:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '14.139.206.130', `modifiedby` = '539', `modifieddate` = '2022-12-30 16:32:19' WHERE visitfeedbackid = '11915'"}
{"userId":"544","date":"2022-12-30 16:35:48","query":"UPDATE sitemst SET `sitename` = 'Area Hospital, Guntakal', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '4', `sitecode` = '28092021', `subsitecode` = '0', `samplesize` = '400', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 16:35:48' WHERE siteid = '715'"}
{"userId":"544","date":"2022-12-30 16:36:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 16:36:26')"}
{"userId":"544","date":"2022-12-30 16:56:29","query":"UPDATE sitemst SET `sitename` = 'CHC – MADAKASIRA (ANC-PHC\/CHC)-New10', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '4', `sitecode` = '28729011', `subsitecode` = '1', `samplesize` = '150', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 16:56:29' WHERE siteid = '716'"}
{"userId":"544","date":"2022-12-30 16:58:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 16:58:12')"}
{"userId":"544","date":"2022-12-30 16:58:53","query":"UPDATE sitemst SET `sitename` = 'CHC – MADAKASIRA (ANC-PHC\/CHC)-New10', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '4', `sitecode` = '28729011', `subsitecode` = '1', `samplesize` = '150', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 16:58:53' WHERE siteid = '716'"}
{"userId":"544","date":"2022-12-30 16:59:05","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 16:59:05')"}
{"userId":"544","date":"2022-12-30 17:03:16","query":"UPDATE sitemst SET `sitename` = 'Ananthapur_Medical College', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '4', `sitecode` = '28092011', `subsitecode` = '0', `samplesize` = '400', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 17:03:16' WHERE siteid = '717'"}
{"userId":"544","date":"2022-12-30 17:03:29","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 17:03:29')"}
{"userId":"544","date":"2022-12-30 17:06:14","query":"UPDATE sitemst SET `sitename` = 'Rural Development Trust -(RDT) PPP FI ICTC, Kalyandurg', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '4', `sitecode` = '28092012', `subsitecode` = '0', `samplesize` = '400', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 17:06:14' WHERE siteid = '718'"}
{"userId":"252","date":"2022-12-30 17:08:19","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('252', '14.139.125.18', '2022-12-30 17:08:19')"}
{"userId":"254","date":"2022-12-30 17:08:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('254', '14.139.125.18', '2022-12-30 17:08:34')"}
{"userId":"255","date":"2022-12-30 17:08:46","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('255', '14.139.125.18', '2022-12-30 17:08:46')"}
{"userId":"256","date":"2022-12-30 17:09:01","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('256', '14.139.125.18', '2022-12-30 17:09:01')"}
{"userId":"258","date":"2022-12-30 17:09:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('258', '14.139.125.18', '2022-12-30 17:09:22')"}
{"userId":"544","date":"2022-12-30 17:10:54","query":"UPDATE sitemst SET `sitename` = 'Area Hospital, Srikalahasti', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '5', `sitecode` = '28731011', `subsitecode` = '0', `samplesize` = '400', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 17:10:54' WHERE siteid = '719'"}
{"userId":"544","date":"2022-12-30 17:12:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('544', '14.139.206.130', '2022-12-30 17:12:06')"}
{"userId":"571","date":"2022-12-30 17:13:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('571', '14.139.125.18', '2022-12-30 17:13:16')"}
{"userId":"7","date":"2022-12-30 17:13:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('7', '14.139.125.18', '2022-12-30 17:13:42')"}
{"userId":"544","date":"2022-12-30 17:14:32","query":"UPDATE sitemst SET `sitename` = 'DESAI HOSPITAL, MADANAPALLY (ANC-Pvt)-New10', `sitetype` = '1', `stateid` = '2', `regionid` = '6', `districtid` = '5', `sitecode` = '28720012', `subsitecode` = '0', `samplesize` = '400', `ipaddress` = '14.139.206.130', `modifiedby` = '544', `modifieddate` = '2022-12-30 17:14:32' WHERE siteid = '720'"}
{"userId":"7","date":"2022-12-30 17:15:57","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr. Somya', 'Mullapudi', 'hssseniorconsultantepi@gmail.com', '7674819807', 'Sr. Consultant Epidemiologist', 'NARI', '81d43edec510ca4fdce2ab21596c7ba7', '4', '14.139.125.18', '7', '2022-12-30 17:15:57')"}
{"userId":"7","date":"2022-12-30 17:15:57","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('617', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2022-12-30 17:15:57')"}
{"userId":"7","date":"2022-12-30 17:17:47","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', '2022-12-30 17:17:47')"}
{"userId":"7","date":"2022-12-30 17:17:47","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('618', '101', '22', '0', '5', '0', '14.139.125.18', '7', '2022-12-30 17:17:47')"}