{"userId":"574","date":"2023-02-06 10:06:11","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 10:06:11')"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE sitesupervision SET `siteid` = '182', `userid` = '574', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '1970-01-01', `numofsamplecollected` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2751'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE onssid = '11332'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE onssid = '11333'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE onssid = '11334'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '', `istrained` = '0', `remarks` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE onssid = '11335'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE supvisstepid = '13571'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE visitfeedback SET `feedback` = 'consent forms were signed after completion of data collection', `recommendation` = 'counsellor is advised to take signatures on consent forms before starting the data form.', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE visitfeedbackid = '13531'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE visitfeedback SET `feedback` = 'ANC attendees going from PPTCT to the labs by themselves, this increases the chance of missing participants while going from PPTCT to the lab.', `recommendation` = 'advised LT to co-ordinate with the counsellor for the movement of participants from PPTCT to the Lab.', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE visitfeedbackid = '13532'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE visitfeedbackid = '13533'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE visitfeedbackid = '13534'"}
{"userId":"574","date":"2023-02-06 10:36:06","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '110.235.232.63', `modifiedby` = '574', `modifieddate` = '2023-02-06 10:36:06' WHERE visitfeedbackid = '13535'"}
{"userId":"574","date":"2023-02-06 10:36:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 10:36:28')"}
{"userId":"643","date":"2023-02-06 10:42:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('643', '103.151.38.117', '2023-02-06 10:42:56')"}
{"userId":"643","date":"2023-02-06 10:44:53","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('932', '2023-02-06', '643', '103.151.38.117', '643', '2023-02-06 10:44:53')"}
{"userId":"574","date":"2023-02-06 10:55:36","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 10:55:36')"}
{"userId":"575","date":"2023-02-06 11:50:08","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-06 11:50:08')"}
{"userId":"575","date":"2023-02-06 11:51:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('908', '2023-02-03', '575', '110.235.232.63', '575', '2023-02-06 11:51:01')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('908', '3226', '575', '2023-02-06', '1', '110.235.232.63', '575', '2023-02-06 11:51:06', '', '')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2761', '0', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2761', '1', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2761', '2', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2761', '3', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2761', '4', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2761', '', '', 'Array', '', 'Array', '', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2761', '', '', 'Array', '', 'Array', '', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2761', '', '', 'Array', '', 'Array', '', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2761', '', '', 'Array', '', 'Array', '', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"575","date":"2023-02-06 11:51:06","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2761', '110.235.232.63', '575', '2023-02-06 11:51:06')"}
{"userId":"632","date":"2023-02-06 11:51:41","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('632', '103.146.223.19', '2023-02-06 11:51:41')"}
{"userId":"575","date":"2023-02-06 11:52:10","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '110.235.232.63', `modifiedby` = '575', `modifieddate` = '2023-02-06 11:52:10' WHERE plansiteid = '3226'"}
{"userId":"575","date":"2023-02-06 11:52:10","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '110.235.232.63', `modifiedby` = '575', `modifieddate` = '2023-02-06 11:52:10' WHERE ssid = '2761'"}
{"userId":"632","date":"2023-02-06 11:55:04","query":"UPDATE usermst SET `firstname` = 'Susanta', `lastname` = 'Jana', `email` = 'susanta_jana1970@yahoo.co.in', `mobilenum` = '8240445372', `designation` = 'Programme Officer', `organization` = 'JASCS-TSU', `roleid` = '4', `ipaddress` = '103.146.223.19', `createdby` = '632', `createddate` = '2023-02-06 11:55:04' WHERE userid = '679'"}
{"userId":"632","date":"2023-02-06 11:55:04","query":"UPDATE userlocation SET `userid` = '679', `countryid` = '101', `stateid` = '16', `riid` = '3', `cityid` = '1492', `districtid` = '254', `ipaddress` = '103.146.223.19', `createdby` = '632', `createddate` = '2023-02-06 11:55:04' WHERE userid = '679'"}
{"userId":"632","date":"2023-02-06 12:09:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('632', '103.146.223.19', '2023-02-06 12:09:13')"}
{"userId":"575","date":"2023-02-06 12:10:00","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-06 12:10:00')"}
{"userId":"632","date":"2023-02-06 12:12:12","query":"UPDATE usermst SET `firstname` = 'Susanta', `lastname` = 'Jana', `email` = 'susanta_jana1970@yahoo.co.in', `mobilenum` = '8240445372', `designation` = 'Programme Officer', `organization` = 'JASCS-TSU', `roleid` = '4', `ipaddress` = '103.146.223.19', `createdby` = '632', `createddate` = '2023-02-06 12:12:12' WHERE userid = '679'"}
{"userId":"632","date":"2023-02-06 12:12:12","query":"UPDATE userlocation SET `userid` = '679', `countryid` = '101', `stateid` = '16', `riid` = '3', `cityid` = '1492', `districtid` = '254', `ipaddress` = '103.146.223.19', `createdby` = '632', `createddate` = '2023-02-06 12:12:12' WHERE userid = '679'"}
{"userId":"575","date":"2023-02-06 12:18:16","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('575', '110.235.232.63', '2023-02-06 12:18:16')"}
{"userId":"2","date":"2023-02-06 12:18:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '110.235.232.63', '2023-02-06 12:18:56')"}
{"userId":"632","date":"2023-02-06 13:19:15","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('632', '103.146.223.19', '2023-02-06 13:19:15')"}
{"userId":"574","date":"2023-02-06 15:42:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 15:42:50')"}
{"userId":"574","date":"2023-02-06 16:07:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 16:07:40')"}
{"userId":"379","date":"2023-02-06 16:09:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('379', '110.235.232.63', '2023-02-06 16:09:56')"}
{"userId":"574","date":"2023-02-06 16:20:40","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.63', '2023-02-06 16:20:40')"}
{"userId":"574","date":"2023-02-06 16:22:11","query":"UPDATE usermst SET `firstname` = 'Rajesh', `lastname` = 'Sinha', `email` = 'drrajeshsinhadr@gmail.com', `mobilenum` = '7857913255', `designation` = 'Focal person', `organization` = 'Bihar SACS', `roleid` = '5', `ipaddress` = '110.235.232.63', `createdby` = '574', `createddate` = '2023-02-06 16:22:11' WHERE userid = '379'"}
{"userId":"574","date":"2023-02-06 16:22:11","query":"UPDATE userlocation SET `userid` = '379', `countryid` = '101', `stateid` = '5', `riid` = '3', `cityid` = '', `districtid` = '89', `ipaddress` = '110.235.232.63', `createdby` = '574', `createddate` = '2023-02-06 16:22:11' WHERE userid = '379'"}
{"userId":"379","date":"2023-02-06 16:22:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('379', '110.235.232.63', '2023-02-06 16:22:33')"}
{"userId":"379","date":"2023-02-06 16:28:03","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('379', '117.247.66.206', '2023-02-06 16:28:03')"}
{"userId":"379","date":"2023-02-06 16:28:04","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('379', '117.247.66.206', '2023-02-06 16:28:04')"}
{"userId":"379","date":"2023-02-06 16:35:22","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('346', '2023-02-04', '379', '117.247.66.206', '379', '2023-02-06 16:35:22')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('346', '3227', '379', '2023-02-06', '0', '117.247.66.206', '379', '2023-02-06 16:35:45', '', '')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2762', '0', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2762', '', '', 'Array', '', 'Array', '', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2762', '', '', 'Array', '', 'Array', '', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2762', '', '', 'Array', '', 'Array', '', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2762', '', '', 'Array', '', 'Array', '', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"379","date":"2023-02-06 16:35:45","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2762', '117.247.66.206', '379', '2023-02-06 16:35:45')"}
{"userId":"660","date":"2023-02-06 20:59:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '157.40.211.247', '2023-02-06 20:59:12')"}
{"userId":"660","date":"2023-02-06 21:11:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '103.102.116.152', '2023-02-06 21:11:12')"}
{"userId":"660","date":"2023-02-06 21:23:33","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('660', '103.102.116.152', '2023-02-06 21:23:33')"}
{"userId":"660","date":"2023-02-06 21:24:18","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('419', '2023-02-08', '660', '103.102.116.152', '660', '2023-02-06 21:24:18')"}
{"userId":"643","date":"2023-02-06 22:02:13","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('643', '103.151.38.178', '2023-02-06 22:02:13')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('932', '3225', '643', '2023-02-06', '1', '103.151.38.178', '643', '2023-02-06 22:02:47', '', '')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2763', '0', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2763', '1', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2763', '2', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2763', '3', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2763', '4', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2763', '', '', 'Array', '', 'Array', '', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2763', '', '', 'Array', '', 'Array', '', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2763', '', '', 'Array', '', 'Array', '', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2763', '', '', 'Array', '', 'Array', '', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:02:47","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2763', '103.151.38.178', '643', '2023-02-06 22:02:47')"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE sitesupervision SET `siteid` = '932', `userid` = '643', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '174', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34', `locationtype` = '1', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2763'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE onsitestaffs SET `staffname` = 'Hemangini Mishra', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE onssid = '11380'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE onsitestaffs SET `staffname` = 'Laxmi dhara Sahu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE onssid = '11381'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE onsitestaffs SET `staffname` = 'Dr R N Patel', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE onssid = '11382'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE onssid = '11383'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261214 then '' when ansid=261215 then '' when ansid=261216 then '' when ansid=261217 then '' when ansid=261218 then ''  when ansid=261219 then ''   when ansid=261220 then ''  when ansid=261320 then '' when ansid=261321 then '' when ansid=261263 then '' when ansid=261265 then '' when ansid=261267 then '' when ansid=261269 then '' when ansid=261271 then '' when ansid=261273 then '' when ansid=261274 then '' when ansid=261275 then '' when ansid=261276 then ''  when ansid=261277 then ''   when ansid=261278 then ''  when ansid=261279 then ''  when ansid=261280 then ''   when ansid=261281 then ''   when ansid=261282 then ''   when ansid=261283 then ''  when ansid=261284 then '' when ansid=261285 then '' when ansid=261286 then ''  when ansid=261287 then ''   when ansid=261288 then ''   when ansid=261289 then ''   when ansid=261290 then ''  when ansid=261291 then ''  when ansid=261292 then ''   when ansid=261293 then ''  when ansid=261294 then '' when ansid=261295 then '' when ansid=261296 then '' when ansid=261297 then '' when ansid=261298 then '' when ansid=261299 then '' when ansid=261300 then '' when ansid=261301 then '' when ansid=261302 then ''  when ansid=261303 then ''   when ansid=261304 then ''   when ansid=261305 then ''   when ansid=261306 then ''  when ansid=261307 then '' when ansid=261308 then ''  when ansid=261309 then ''   when ansid=261310 then ''  when ansid=261311 then '' when ansid=261312 then '' when ansid=261313 then '' when ansid=261314 then '' when ansid=261315 then '' when ansid=261316 then '' when ansid=261317 then '' when ansid=261318 then '' when ansid=261319 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.151.38.178',\r\n\t\t\t\t\t\t\t\tmodifiedby =643,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-06 22:05:34'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261214','261215','261216','261217','261218','261219','261220','261320','261321','261263','261265','261267','261269','261271','261273','261274','261275','261276','261277','261278','261279','261280','261281','261282','261283','261284','261285','261286','261287','261288','261289','261290','261291','261292','261293','261294','261295','261296','261297','261298','261299','261300','261301','261302','261303','261304','261305','261306','261307','261308','261309','261310','261311','261312','261313','261314','261315','261316','261317','261318','261319')"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE supvisstepid = '13625'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE visitfeedbackid = '13591'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE visitfeedbackid = '13592'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE visitfeedbackid = '13593'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE visitfeedbackid = '13594'"}
{"userId":"643","date":"2023-02-06 22:05:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:34' WHERE visitfeedbackid = '13595'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE sitesupervision SET `siteid` = '932', `userid` = '643', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '174', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59', `locationtype` = '1', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2763'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE onsitestaffs SET `staffname` = 'Hemangini Mishra', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE onssid = '11380'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE onsitestaffs SET `staffname` = 'Laxmi dhara Sahu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE onssid = '11381'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE onsitestaffs SET `staffname` = 'Dr R N Patel', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE onssid = '11382'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE onssid = '11383'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261214 then '1' when ansid=261215 then '1' when ansid=261216 then '1' when ansid=261217 then '' when ansid=261218 then ''  when ansid=261219 then ''   when ansid=261220 then '1'  when ansid=261320 then '1' when ansid=261321 then '1' when ansid=261263 then '' when ansid=261265 then '' when ansid=261267 then '' when ansid=261269 then '' when ansid=261271 then '' when ansid=261273 then '' when ansid=261274 then '' when ansid=261275 then '' when ansid=261276 then ''  when ansid=261277 then ''   when ansid=261278 then ''  when ansid=261279 then ''  when ansid=261280 then ''   when ansid=261281 then ''   when ansid=261282 then ''   when ansid=261283 then ''  when ansid=261284 then '' when ansid=261285 then '' when ansid=261286 then ''  when ansid=261287 then ''   when ansid=261288 then ''   when ansid=261289 then ''   when ansid=261290 then ''  when ansid=261291 then ''  when ansid=261292 then ''   when ansid=261293 then ''  when ansid=261294 then '' when ansid=261295 then '' when ansid=261296 then '' when ansid=261297 then '' when ansid=261298 then '' when ansid=261299 then '' when ansid=261300 then '' when ansid=261301 then '' when ansid=261302 then ''  when ansid=261303 then ''   when ansid=261304 then ''   when ansid=261305 then ''   when ansid=261306 then ''  when ansid=261307 then '' when ansid=261308 then ''  when ansid=261309 then ''   when ansid=261310 then ''  when ansid=261311 then '' when ansid=261312 then '' when ansid=261313 then '' when ansid=261314 then '' when ansid=261315 then '' when ansid=261316 then '' when ansid=261317 then '' when ansid=261318 then '' when ansid=261319 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.151.38.178',\r\n\t\t\t\t\t\t\t\tmodifiedby =643,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-06 22:05:59'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261214','261215','261216','261217','261218','261219','261220','261320','261321','261263','261265','261267','261269','261271','261273','261274','261275','261276','261277','261278','261279','261280','261281','261282','261283','261284','261285','261286','261287','261288','261289','261290','261291','261292','261293','261294','261295','261296','261297','261298','261299','261300','261301','261302','261303','261304','261305','261306','261307','261308','261309','261310','261311','261312','261313','261314','261315','261316','261317','261318','261319')"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE supvisstepid = '13626'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE visitfeedbackid = '13591'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE visitfeedbackid = '13592'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE visitfeedbackid = '13593'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE visitfeedbackid = '13594'"}
{"userId":"643","date":"2023-02-06 22:05:59","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:05:59' WHERE visitfeedbackid = '13595'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE sitesupervision SET `siteid` = '932', `userid` = '643', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '174', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40', `locationtype` = '1', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2763'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE onsitestaffs SET `staffname` = 'Hemangini Mishra', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE onssid = '11380'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE onsitestaffs SET `staffname` = 'Laxmi dhara Sahu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE onssid = '11381'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE onsitestaffs SET `staffname` = 'Dr R N Patel', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE onssid = '11382'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE onssid = '11383'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261214 then '1' when ansid=261215 then '1' when ansid=261216 then '1' when ansid=261217 then '' when ansid=261218 then ''  when ansid=261219 then ''   when ansid=261220 then '1'  when ansid=261320 then '1' when ansid=261321 then '1' when ansid=261263 then '0' when ansid=261265 then '0' when ansid=261267 then '0' when ansid=261269 then '0' when ansid=261271 then '1' when ansid=261273 then '' when ansid=261274 then '' when ansid=261275 then '' when ansid=261276 then ''  when ansid=261277 then ''   when ansid=261278 then ''  when ansid=261279 then ''  when ansid=261280 then ''   when ansid=261281 then ''   when ansid=261282 then ''   when ansid=261283 then ''  when ansid=261284 then '' when ansid=261285 then '' when ansid=261286 then ''  when ansid=261287 then ''   when ansid=261288 then ''   when ansid=261289 then ''   when ansid=261290 then ''  when ansid=261291 then ''  when ansid=261292 then ''   when ansid=261293 then ''  when ansid=261294 then '' when ansid=261295 then '' when ansid=261296 then '' when ansid=261297 then '' when ansid=261298 then '' when ansid=261299 then '' when ansid=261300 then '' when ansid=261301 then '' when ansid=261302 then ''  when ansid=261303 then ''   when ansid=261304 then ''   when ansid=261305 then ''   when ansid=261306 then ''  when ansid=261307 then '' when ansid=261308 then ''  when ansid=261309 then ''   when ansid=261310 then ''  when ansid=261311 then '' when ansid=261312 then '' when ansid=261313 then '' when ansid=261314 then '' when ansid=261315 then '' when ansid=261316 then '' when ansid=261317 then '' when ansid=261318 then '' when ansid=261319 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.151.38.178',\r\n\t\t\t\t\t\t\t\tmodifiedby =643,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-06 22:06:40'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261214','261215','261216','261217','261218','261219','261220','261320','261321','261263','261265','261267','261269','261271','261273','261274','261275','261276','261277','261278','261279','261280','261281','261282','261283','261284','261285','261286','261287','261288','261289','261290','261291','261292','261293','261294','261295','261296','261297','261298','261299','261300','261301','261302','261303','261304','261305','261306','261307','261308','261309','261310','261311','261312','261313','261314','261315','261316','261317','261318','261319')"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE supvisstepid = '13627'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE visitfeedbackid = '13591'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE visitfeedbackid = '13592'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE visitfeedbackid = '13593'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE visitfeedbackid = '13594'"}
{"userId":"643","date":"2023-02-06 22:06:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:06:40' WHERE visitfeedbackid = '13595'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE sitesupervision SET `siteid` = '932', `userid` = '643', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '174', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23', `locationtype` = '1', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2763'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE onsitestaffs SET `staffname` = 'Hemangini Mishra', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE onssid = '11380'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE onsitestaffs SET `staffname` = 'Laxmi dhara Sahu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE onssid = '11381'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr R N Patel', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE onssid = '11382'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE onssid = '11383'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261214 then '1' when ansid=261215 then '1' when ansid=261216 then '1' when ansid=261217 then '' when ansid=261218 then ''  when ansid=261219 then ''   when ansid=261220 then '1'  when ansid=261320 then '1' when ansid=261321 then '1' when ansid=261263 then '0' when ansid=261265 then '0' when ansid=261267 then '0' when ansid=261269 then '0' when ansid=261271 then '1' when ansid=261273 then '8' when ansid=261274 then '0' when ansid=261275 then '256' when ansid=261276 then '101'  when ansid=261277 then ''   when ansid=261278 then '1'  when ansid=261279 then '1'  when ansid=261280 then ''   when ansid=261281 then '1'   when ansid=261282 then ''   when ansid=261283 then '1'  when ansid=261284 then '8' when ansid=261285 then '1' when ansid=261286 then '1'  when ansid=261287 then 'councellar'   when ansid=261288 then '1'   when ansid=261289 then ''   when ansid=261290 then '1'  when ansid=261291 then '1'  when ansid=261292 then ''   when ansid=261293 then '1'  when ansid=261294 then '3' when ansid=261295 then '1' when ansid=261296 then '1' when ansid=261297 then '1' when ansid=261298 then '1' when ansid=261299 then '2' when ansid=261300 then '1' when ansid=261301 then '1' when ansid=261302 then '1'  when ansid=261303 then ''   when ansid=261304 then '3'   when ansid=261305 then ''   when ansid=261306 then '1'  when ansid=261307 then '1' when ansid=261308 then '1'  when ansid=261309 then ''   when ansid=261310 then '1'  when ansid=261311 then '1' when ansid=261312 then '1' when ansid=261313 then '2' when ansid=261314 then '1' when ansid=261315 then '0' when ansid=261316 then 'They have not received any acknowledgment  after receiving signed data transportation sheet from the Regional Institute for the data forms sent .They had not received needle destroyer this round . They are using one which is old one . also they have not received any puncture proof container,blue coloured card board box  or colour coded bags. Last time though he had told me that he had received blue coloured card board ,he hadn\\'t. For proper biomedical waste management coloured bins were provided .Also no recapping done in the site after blood collection .' when ansid=261317 then 'I had visited earlier . At that time no consecutive sampling done , hence requested the councellar to inform the person maintaining the register at ANC site to send the Consecutive Pregnant women to her attending first time . As per the version of the councellar daily morning she is informing the person at ANC site about this.' when ansid=261318 then 'In my last visit there was no proper biomedical waste management in the site . But it has improved this time .This time during my visit  today, already blood collection was completed for the 8 th pregnant woman and she was in a hurry . So I could not cross check .Lab technician wanted a new needle destroyer .' when ansid=261319 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.151.38.178',\r\n\t\t\t\t\t\t\t\tmodifiedby =643,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-06 22:24:23'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261214','261215','261216','261217','261218','261219','261220','261320','261321','261263','261265','261267','261269','261271','261273','261274','261275','261276','261277','261278','261279','261280','261281','261282','261283','261284','261285','261286','261287','261288','261289','261290','261291','261292','261293','261294','261295','261296','261297','261298','261299','261300','261301','261302','261303','261304','261305','261306','261307','261308','261309','261310','261311','261312','261313','261314','261315','261316','261317','261318','261319')"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE supvisstepid = '13628'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE visitfeedbackid = '13591'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE visitfeedbackid = '13592'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE visitfeedbackid = '13593'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE visitfeedbackid = '13594'"}
{"userId":"643","date":"2023-02-06 22:24:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:24:23' WHERE visitfeedbackid = '13595'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE sitesupervision SET `siteid` = '932', `userid` = '643', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '174', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03', `locationtype` = '1', `establishmentyear` = '2006', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2763'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE onsitestaffs SET `staffname` = 'Hemangini Mishra', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '14', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE onssid = '11380'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE onsitestaffs SET `staffname` = 'Laxmi dhara Sahu', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '16', `istrained` = '1', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE onssid = '11381'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE onsitestaffs SET `staffname` = 'Dr R N Patel', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE onssid = '11382'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE onssid = '11383'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=261214 then '1' when ansid=261215 then '1' when ansid=261216 then '1' when ansid=261217 then '' when ansid=261218 then ''  when ansid=261219 then ''   when ansid=261220 then '1'  when ansid=261320 then '1' when ansid=261321 then '1' when ansid=261263 then '0' when ansid=261265 then '0' when ansid=261267 then '0' when ansid=261269 then '0' when ansid=261271 then '1' when ansid=261273 then '8' when ansid=261274 then '0' when ansid=261275 then '256' when ansid=261276 then '101'  when ansid=261277 then ''   when ansid=261278 then '1'  when ansid=261279 then '1'  when ansid=261280 then ''   when ansid=261281 then '1'   when ansid=261282 then ''   when ansid=261283 then '1'  when ansid=261284 then '8' when ansid=261285 then '1' when ansid=261286 then '1'  when ansid=261287 then 'councellar'   when ansid=261288 then '1'   when ansid=261289 then ''   when ansid=261290 then '1'  when ansid=261291 then '1'  when ansid=261292 then ''   when ansid=261293 then '1'  when ansid=261294 then '3' when ansid=261295 then '1' when ansid=261296 then '1' when ansid=261297 then '1' when ansid=261298 then '1' when ansid=261299 then '2' when ansid=261300 then '1' when ansid=261301 then '1' when ansid=261302 then '1'  when ansid=261303 then ''   when ansid=261304 then '3'   when ansid=261305 then ''   when ansid=261306 then '1'  when ansid=261307 then '1' when ansid=261308 then '1'  when ansid=261309 then ''   when ansid=261310 then '1'  when ansid=261311 then '1' when ansid=261312 then '1' when ansid=261313 then '2' when ansid=261314 then '1' when ansid=261315 then '0' when ansid=261316 then 'They have not received any acknowledgment  after receiving signed data transportation sheet from the Regional Institute for the data forms sent .They had not received needle destroyer this round . They are using one which is old one . also they have not received any puncture proof container,blue coloured card board box  or colour coded bags. Last time though he had told me that he had received blue coloured card board ,he hadn\\'t. For proper biomedical waste management coloured bins were provided .Also no recapping done in the site after blood collection .' when ansid=261317 then 'I had visited earlier . At that time no consecutive sampling done , hence requested the councellar to inform the person maintaining the register at ANC site to send the Consecutive Pregnant women to her attending first time . As per the version of the councellar daily morning she is informing the person at ANC site about this.' when ansid=261318 then 'In my last visit there was no proper biomedical waste management in the site . But it has improved this time .This time during my visit  today, already blood collection was completed for the 8 th pregnant woman and she was in a hurry . So I could not cross check .Lab technician wanted a new needle destroyer .' when ansid=261319 then '1' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '103.151.38.178',\r\n\t\t\t\t\t\t\t\tmodifiedby =643,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-02-06 22:26:03'\r\n\t\t\t\t\t\t\tWHERE ansid in ('261214','261215','261216','261217','261218','261219','261220','261320','261321','261263','261265','261267','261269','261271','261273','261274','261275','261276','261277','261278','261279','261280','261281','261282','261283','261284','261285','261286','261287','261288','261289','261290','261291','261292','261293','261294','261295','261296','261297','261298','261299','261300','261301','261302','261303','261304','261305','261306','261307','261308','261309','261310','261311','261312','261313','261314','261315','261316','261317','261318','261319')"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE supvisstepid = '13629'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE visitfeedback SET `feedback` = 'No issue identified this time .', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE visitfeedbackid = '13591'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE visitfeedbackid = '13592'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE visitfeedbackid = '13593'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE visitfeedbackid = '13594'"}
{"userId":"643","date":"2023-02-06 22:26:03","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.151.38.178', `modifiedby` = '643', `modifieddate` = '2023-02-06 22:26:03' WHERE visitfeedbackid = '13595'"}
{"userId":"13","date":"2023-02-06 22:45:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('13', '103.212.147.159', '2023-02-06 22:45:48')"}