{"userId":"384","date":"2021-04-10 14:36:26","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('384', '59.89.57.2', '2021-04-10 14:36:26')"}
{"userId":"383","date":"2021-04-10 14:36:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('383', '59.89.57.2', '2021-04-10 14:36:27')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1100', '2032', '383', '2021-04-10', '1', '59.89.57.2', '383', '2021-04-10 14:36:49', '', '')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2301', '0', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2301', '1', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2301', '2', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2301', '3', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2301', '', '', 'Array', '', 'Array', '', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2301', '', '', 'Array', '', 'Array', '', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2301', '', '', 'Array', '', 'Array', '', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2301', '', '', 'Array', '', 'Array', '', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"383","date":"2021-04-10 14:36:49","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2301', '59.89.57.2', '383', '2021-04-10 14:36:49')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1117', '2697', '384', '2021-04-10', '1', '59.89.57.2', '384', '2021-04-10 14:37:19', '', '')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2302', '0', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2302', '1', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2302', '2', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2302', '3', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2302', '', '', 'Array', '', 'Array', '', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2302', '', '', 'Array', '', 'Array', '', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2302', '', '', 'Array', '', 'Array', '', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2302', '', '', 'Array', '', 'Array', '', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('183', '2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:37:19","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2302', '59.89.57.2', '384', '2021-04-10 14:37:19')"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE sitesupervision SET `siteid` = '1117', `userid` = '384', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '205', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2302'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kundan Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE onssid = '9536'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Priyanka Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE onssid = '9537'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Pradyuman Shrivastava', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE onssid = '9538'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE onssid = '9539'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213999 then '2' when ansid=214000 then '3' when ansid=214001 then '1' when ansid=214002 then '0' when ansid=214003 then '0' when ansid=214004 then '2' when ansid=214005 then '3' when ansid=214006 then '' when ansid=214007 then '' when ansid=214008 then '' when ansid=214009 then '' when ansid=214010 then '' when ansid=214011 then '' when ansid=214012 then '' when ansid=214013 then '' when ansid=214014 then '' when ansid=214015 then '' when ansid=214016 then '' when ansid=214017 then '' when ansid=214018 then ''  when ansid=214019 then ''   when ansid=214020 then ''   when ansid=214021 then ''   when ansid=214022 then ''   when ansid=214023 then ''   when ansid=214024 then ''   when ansid=214025 then ''   when ansid=214026 then ''   when ansid=214027 then ''   when ansid=214028 then ''  when ansid=214029 then '' when ansid=214030 then '' when ansid=214031 then ''  when ansid=214032 then ''   when ansid=214033 then ''   when ansid=214034 then ''   when ansid=214035 then ''   when ansid=214036 then ''   when ansid=214037 then ''   when ansid=214038 then ''   when ansid=214039 then ''   when ansid=214040 then ''   when ansid=214041 then ''   when ansid=214042 then ''   when ansid=214043 then ''   when ansid=214044 then ''   when ansid=214045 then ''  when ansid=214046 then '' when ansid=214047 then '' when ansid=214048 then '' when ansid=214049 then '' when ansid=214050 then '' when ansid=214051 then '' when ansid=214052 then '' when ansid=214053 then '' when ansid=214054 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =384,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:42:12'\n\t\t\t\t\t\t\tWHERE ansid in ('213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214023','214024','214025','214026','214027','214028','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054')"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE supvisstepid = '11444'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE visitfeedbackid = '11286'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE visitfeedbackid = '11287'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE visitfeedbackid = '11288'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE visitfeedbackid = '11289'"}
{"userId":"384","date":"2021-04-10 14:42:12","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:42:12' WHERE visitfeedbackid = '11290'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE sitesupervision SET `siteid` = '1100', `userid` = '383', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '188', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2301'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE onsitestaffs SET `staffname` = 'Aswani Chatuvedi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'joined on 1st April', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE onssid = '9532'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE onsitestaffs SET `staffname` = 'Priyanka Chaturvedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE onssid = '9533'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE onsitestaffs SET `staffname` = 'Shrinkhla Srivastawa', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE onssid = '9534'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE onssid = '9535'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213943 then '2' when ansid=213944 then '1' when ansid=213945 then '1' when ansid=213946 then '0' when ansid=213947 then '0' when ansid=213948 then '2' when ansid=213949 then '2' when ansid=213950 then '' when ansid=213951 then '' when ansid=213952 then '' when ansid=213953 then '' when ansid=213954 then '' when ansid=213955 then '' when ansid=213956 then '' when ansid=213957 then '' when ansid=213958 then '' when ansid=213959 then '' when ansid=213960 then '' when ansid=213961 then '' when ansid=213962 then ''  when ansid=213963 then ''   when ansid=213964 then ''   when ansid=213965 then ''   when ansid=213966 then ''   when ansid=213967 then ''   when ansid=213968 then ''   when ansid=213969 then ''   when ansid=213970 then ''   when ansid=213971 then ''   when ansid=213972 then ''  when ansid=213973 then '' when ansid=213974 then '' when ansid=213975 then ''  when ansid=213976 then ''   when ansid=213977 then ''   when ansid=213978 then ''   when ansid=213979 then ''   when ansid=213980 then ''   when ansid=213981 then ''   when ansid=213982 then ''   when ansid=213983 then ''   when ansid=213984 then ''   when ansid=213985 then ''   when ansid=213986 then ''   when ansid=213987 then ''   when ansid=213988 then ''   when ansid=213989 then ''  when ansid=213990 then '' when ansid=213991 then '' when ansid=213992 then '' when ansid=213993 then '' when ansid=213994 then '' when ansid=213995 then '' when ansid=213996 then '' when ansid=213997 then '' when ansid=213998 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =383,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:42:54'\n\t\t\t\t\t\t\tWHERE ansid in ('213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213988','213989','213990','213991','213992','213993','213994','213995','213996','213997','213998')"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE supvisstepid = '11440'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE visitfeedbackid = '11281'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE visitfeedbackid = '11282'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE visitfeedbackid = '11283'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE visitfeedbackid = '11284'"}
{"userId":"383","date":"2021-04-10 14:42:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:42:54' WHERE visitfeedbackid = '11285'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE sitesupervision SET `siteid` = '1100', `userid` = '383', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '188', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2301'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE onsitestaffs SET `staffname` = 'Aswani Chatuvedi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'joined on 1st April', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE onssid = '9532'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE onsitestaffs SET `staffname` = 'Priyanka Chaturvedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE onssid = '9533'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE onsitestaffs SET `staffname` = 'Shrinkhla Srivastawa', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE onssid = '9534'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE onssid = '9535'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213943 then '2' when ansid=213944 then '1' when ansid=213945 then '1' when ansid=213946 then '0' when ansid=213947 then '0' when ansid=213948 then '2' when ansid=213949 then '2' when ansid=213950 then '1' when ansid=213951 then '2' when ansid=213952 then '1' when ansid=213953 then '1' when ansid=213954 then '1' when ansid=213955 then '1' when ansid=213956 then '1' when ansid=213957 then '1' when ansid=213958 then '1' when ansid=213959 then '' when ansid=213960 then '' when ansid=213961 then '' when ansid=213962 then ''  when ansid=213963 then ''   when ansid=213964 then ''   when ansid=213965 then ''   when ansid=213966 then ''   when ansid=213967 then ''   when ansid=213968 then ''   when ansid=213969 then ''   when ansid=213970 then ''   when ansid=213971 then ''   when ansid=213972 then ''  when ansid=213973 then '' when ansid=213974 then '' when ansid=213975 then ''  when ansid=213976 then ''   when ansid=213977 then ''   when ansid=213978 then ''   when ansid=213979 then ''   when ansid=213980 then ''   when ansid=213981 then ''   when ansid=213982 then ''   when ansid=213983 then ''   when ansid=213984 then ''   when ansid=213985 then ''   when ansid=213986 then ''   when ansid=213987 then ''   when ansid=213988 then ''   when ansid=213989 then ''  when ansid=213990 then '' when ansid=213991 then '' when ansid=213992 then '' when ansid=213993 then '' when ansid=213994 then '' when ansid=213995 then '' when ansid=213996 then '' when ansid=213997 then '' when ansid=213998 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =383,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:43:28'\n\t\t\t\t\t\t\tWHERE ansid in ('213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213988','213989','213990','213991','213992','213993','213994','213995','213996','213997','213998')"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE supvisstepid = '11441'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE visitfeedbackid = '11281'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE visitfeedbackid = '11282'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE visitfeedbackid = '11283'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE visitfeedbackid = '11284'"}
{"userId":"383","date":"2021-04-10 14:43:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:43:28' WHERE visitfeedbackid = '11285'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE sitesupervision SET `siteid` = '1117', `userid` = '384', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '205', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2302'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kundan Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE onssid = '9536'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Priyanka Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE onssid = '9537'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Pradyuman Shrivastava', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE onssid = '9538'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE onssid = '9539'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213999 then '2' when ansid=214000 then '3' when ansid=214001 then '1' when ansid=214002 then '0' when ansid=214003 then '0' when ansid=214004 then '2' when ansid=214005 then '3' when ansid=214006 then '1' when ansid=214007 then '1' when ansid=214008 then '1' when ansid=214009 then '1' when ansid=214010 then '1' when ansid=214011 then '1' when ansid=214012 then '1' when ansid=214013 then '1' when ansid=214014 then '1' when ansid=214015 then '' when ansid=214016 then '' when ansid=214017 then '' when ansid=214018 then ''  when ansid=214019 then ''   when ansid=214020 then ''   when ansid=214021 then ''   when ansid=214022 then ''   when ansid=214023 then ''   when ansid=214024 then ''   when ansid=214025 then ''   when ansid=214026 then ''   when ansid=214027 then ''   when ansid=214028 then ''  when ansid=214029 then '' when ansid=214030 then '' when ansid=214031 then ''  when ansid=214032 then ''   when ansid=214033 then ''   when ansid=214034 then ''   when ansid=214035 then ''   when ansid=214036 then ''   when ansid=214037 then ''   when ansid=214038 then ''   when ansid=214039 then ''   when ansid=214040 then ''   when ansid=214041 then ''   when ansid=214042 then ''   when ansid=214043 then ''   when ansid=214044 then ''   when ansid=214045 then ''  when ansid=214046 then '' when ansid=214047 then '' when ansid=214048 then '' when ansid=214049 then '' when ansid=214050 then '' when ansid=214051 then '' when ansid=214052 then '' when ansid=214053 then '' when ansid=214054 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =384,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:43:40'\n\t\t\t\t\t\t\tWHERE ansid in ('213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214023','214024','214025','214026','214027','214028','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054')"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE supvisstepid = '11445'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE visitfeedbackid = '11286'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE visitfeedbackid = '11287'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE visitfeedbackid = '11288'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE visitfeedbackid = '11289'"}
{"userId":"384","date":"2021-04-10 14:43:40","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:43:40' WHERE visitfeedbackid = '11290'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE sitesupervision SET `siteid` = '1100', `userid` = '383', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '188', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2301'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE onsitestaffs SET `staffname` = 'Aswani Chatuvedi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'joined on 1st April', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE onssid = '9532'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE onsitestaffs SET `staffname` = 'Priyanka Chaturvedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE onssid = '9533'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE onsitestaffs SET `staffname` = 'Shrinkhla Srivastawa', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE onssid = '9534'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE onssid = '9535'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213943 then '2' when ansid=213944 then '1' when ansid=213945 then '1' when ansid=213946 then '0' when ansid=213947 then '0' when ansid=213948 then '2' when ansid=213949 then '2' when ansid=213950 then '1' when ansid=213951 then '2' when ansid=213952 then '1' when ansid=213953 then '1' when ansid=213954 then '1' when ansid=213955 then '1' when ansid=213956 then '1' when ansid=213957 then '1' when ansid=213958 then '1' when ansid=213959 then '1' when ansid=213960 then '10' when ansid=213961 then '5' when ansid=213962 then '1'  when ansid=213963 then ''   when ansid=213964 then '1'   when ansid=213965 then ''   when ansid=213966 then '1'   when ansid=213967 then ''   when ansid=213968 then '1'   when ansid=213969 then ''   when ansid=213970 then '1'   when ansid=213971 then ''   when ansid=213972 then '1'  when ansid=213973 then '1' when ansid=213974 then '1' when ansid=213975 then '1'  when ansid=213976 then ''   when ansid=213977 then '1'   when ansid=213978 then ''   when ansid=213979 then '1'   when ansid=213980 then ''   when ansid=213981 then '1'   when ansid=213982 then ''   when ansid=213983 then '1'   when ansid=213984 then ''   when ansid=213985 then '1'   when ansid=213986 then ''   when ansid=213987 then '2'   when ansid=213988 then ''   when ansid=213989 then '2'  when ansid=213990 then '1' when ansid=213991 then '1' when ansid=213992 then '1' when ansid=213993 then '1' when ansid=213994 then '1' when ansid=213995 then 'no' when ansid=213996 then 'UPSACS' when ansid=213997 then 'doing satisfactory work' when ansid=213998 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =383,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:47:36'\n\t\t\t\t\t\t\tWHERE ansid in ('213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213988','213989','213990','213991','213992','213993','213994','213995','213996','213997','213998')"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE supvisstepid = '11442'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE visitfeedbackid = '11281'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE visitfeedbackid = '11282'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE visitfeedbackid = '11283'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE visitfeedbackid = '11284'"}
{"userId":"383","date":"2021-04-10 14:47:36","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:47:36' WHERE visitfeedbackid = '11285'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE sitesupervision SET `siteid` = '1100', `userid` = '383', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '188', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2301'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE onsitestaffs SET `staffname` = 'Aswani Chatuvedi', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '0', `remarks` = 'joined on 1st April', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE onssid = '9532'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE onsitestaffs SET `staffname` = 'Priyanka Chaturvedi', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE onssid = '9533'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE onsitestaffs SET `staffname` = 'Shrinkhla Srivastawa', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE onssid = '9534'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE onssid = '9535'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213943 then '2' when ansid=213944 then '1' when ansid=213945 then '1' when ansid=213946 then '0' when ansid=213947 then '0' when ansid=213948 then '2' when ansid=213949 then '2' when ansid=213950 then '1' when ansid=213951 then '2' when ansid=213952 then '1' when ansid=213953 then '1' when ansid=213954 then '1' when ansid=213955 then '1' when ansid=213956 then '1' when ansid=213957 then '1' when ansid=213958 then '1' when ansid=213959 then '1' when ansid=213960 then '10' when ansid=213961 then '5' when ansid=213962 then '1'  when ansid=213963 then ''   when ansid=213964 then '1'   when ansid=213965 then ''   when ansid=213966 then '1'   when ansid=213967 then ''   when ansid=213968 then '1'   when ansid=213969 then ''   when ansid=213970 then '1'   when ansid=213971 then ''   when ansid=213972 then '1'  when ansid=213973 then '1' when ansid=213974 then '1' when ansid=213975 then '1'  when ansid=213976 then ''   when ansid=213977 then '1'   when ansid=213978 then ''   when ansid=213979 then '1'   when ansid=213980 then ''   when ansid=213981 then '1'   when ansid=213982 then ''   when ansid=213983 then '1'   when ansid=213984 then ''   when ansid=213985 then '1'   when ansid=213986 then ''   when ansid=213987 then '2'   when ansid=213988 then ''   when ansid=213989 then '2'  when ansid=213990 then '1' when ansid=213991 then '1' when ansid=213992 then '1' when ansid=213993 then '1' when ansid=213994 then '1' when ansid=213995 then 'no' when ansid=213996 then 'UPSACS' when ansid=213997 then 'doing satisfactory work' when ansid=213998 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =383,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:49:11'\n\t\t\t\t\t\t\tWHERE ansid in ('213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213988','213989','213990','213991','213992','213993','213994','213995','213996','213997','213998')"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE supvisstepid = '11443'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE visitfeedback SET `feedback` = 'they are sharing same room for lab as well as counselling purpose', `recommendation` = 'Discussed   and they said will replace counselling room', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE visitfeedbackid = '11281'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE visitfeedbackid = '11282'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE visitfeedbackid = '11283'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE visitfeedbackid = '11284'"}
{"userId":"383","date":"2021-04-10 14:49:11","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '383', `modifieddate` = '2021-04-10 14:49:11' WHERE visitfeedbackid = '11285'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE sitesupervision SET `siteid` = '1117', `userid` = '384', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '205', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2302'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kundan Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE onssid = '9536'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Priyanka Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE onssid = '9537'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Pradyuman Shrivastava', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE onssid = '9538'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE onssid = '9539'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213999 then '2' when ansid=214000 then '3' when ansid=214001 then '1' when ansid=214002 then '0' when ansid=214003 then '0' when ansid=214004 then '2' when ansid=214005 then '3' when ansid=214006 then '1' when ansid=214007 then '1' when ansid=214008 then '1' when ansid=214009 then '1' when ansid=214010 then '1' when ansid=214011 then '1' when ansid=214012 then '1' when ansid=214013 then '1' when ansid=214014 then '1' when ansid=214015 then '2' when ansid=214016 then '6' when ansid=214017 then '5' when ansid=214018 then '1'  when ansid=214019 then ''   when ansid=214020 then '1'   when ansid=214021 then ''   when ansid=214022 then '1'   when ansid=214023 then ''   when ansid=214024 then '1'   when ansid=214025 then ''   when ansid=214026 then '1'   when ansid=214027 then ''   when ansid=214028 then '1'  when ansid=214029 then '1' when ansid=214030 then '1' when ansid=214031 then '1'  when ansid=214032 then ''   when ansid=214033 then '1'   when ansid=214034 then ''   when ansid=214035 then '1'   when ansid=214036 then ''   when ansid=214037 then '1'   when ansid=214038 then ''   when ansid=214039 then '1'   when ansid=214040 then ''   when ansid=214041 then '1'   when ansid=214042 then ''   when ansid=214043 then '2'   when ansid=214044 then ''   when ansid=214045 then '2'  when ansid=214046 then '2' when ansid=214047 then '2' when ansid=214048 then '2' when ansid=214049 then '1' when ansid=214050 then '1' when ansid=214051 then '1. No acknowledgement from RI regarding forms and sample not available' when ansid=214052 then 'Yes, Mr. Satyajeet Shrivatava, UPSACS' when ansid=214053 then 'no' when ansid=214054 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =384,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:52:23'\n\t\t\t\t\t\t\tWHERE ansid in ('213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214023','214024','214025','214026','214027','214028','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054')"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE supvisstepid = '11446'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE visitfeedbackid = '11286'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE visitfeedbackid = '11287'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE visitfeedbackid = '11288'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE visitfeedbackid = '11289'"}
{"userId":"384","date":"2021-04-10 14:52:23","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:52:23' WHERE visitfeedbackid = '11290'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE sitesupervision SET `siteid` = '1117', `userid` = '384', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-02-05', `numofsamplecollected` = '205', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2302'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Kundan Singh', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE onssid = '9536'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mrs. Priyanka Singh', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '2', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE onssid = '9537'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE onsitestaffs SET `staffname` = 'Mr. Pradyuman Shrivastava', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE onssid = '9538'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE onssid = '9539'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=213999 then '2' when ansid=214000 then '3' when ansid=214001 then '1' when ansid=214002 then '0' when ansid=214003 then '0' when ansid=214004 then '2' when ansid=214005 then '3' when ansid=214006 then '1' when ansid=214007 then '1' when ansid=214008 then '1' when ansid=214009 then '1' when ansid=214010 then '1' when ansid=214011 then '1' when ansid=214012 then '1' when ansid=214013 then '1' when ansid=214014 then '1' when ansid=214015 then '2' when ansid=214016 then '6' when ansid=214017 then '5' when ansid=214018 then '1'  when ansid=214019 then ''   when ansid=214020 then '1'   when ansid=214021 then ''   when ansid=214022 then '1'   when ansid=214023 then ''   when ansid=214024 then '1'   when ansid=214025 then ''   when ansid=214026 then '1'   when ansid=214027 then ''   when ansid=214028 then '1'  when ansid=214029 then '1' when ansid=214030 then '1' when ansid=214031 then '1'  when ansid=214032 then ''   when ansid=214033 then '1'   when ansid=214034 then ''   when ansid=214035 then '1'   when ansid=214036 then ''   when ansid=214037 then '1'   when ansid=214038 then ''   when ansid=214039 then '1'   when ansid=214040 then ''   when ansid=214041 then '1'   when ansid=214042 then ''   when ansid=214043 then '2'   when ansid=214044 then ''   when ansid=214045 then '2'  when ansid=214046 then '2' when ansid=214047 then '2' when ansid=214048 then '2' when ansid=214049 then '1' when ansid=214050 then '1' when ansid=214051 then '1. No acknowledgement from RI regarding forms and sample not available' when ansid=214052 then 'Yes, Mr. Satyajeet Shrivatava, UPSACS' when ansid=214053 then 'no' when ansid=214054 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.89.57.2',\n\t\t\t\t\t\t\t\tmodifiedby =384,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-04-10 14:56:34'\n\t\t\t\t\t\t\tWHERE ansid in ('213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214023','214024','214025','214026','214027','214028','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054')"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE supvisstepid = '11447'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE visitfeedback SET `feedback` = 'Sample and data transport acknowledgement forms not available. Coordinated with RI to provide the same.', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE visitfeedbackid = '11286'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE visitfeedbackid = '11287'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE visitfeedbackid = '11288'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE visitfeedbackid = '11289'"}
{"userId":"384","date":"2021-04-10 14:56:34","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.89.57.2', `modifiedby` = '384', `modifieddate` = '2021-04-10 14:56:34' WHERE visitfeedbackid = '11290'"}
{"userId":"384","date":"2021-04-10 20:53:03","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('384', '103.81.182.141', '2021-04-10 20:53:03')"}