{"userId":"5","date":"2021-01-18 12:04:23","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '59.93.139.208', '2021-01-18 12:04:23')"}
{"userId":"5","date":"2021-01-18 12:05:30","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1428', '2021-01-18', '5', '59.93.139.208', '5', '2021-01-18 12:05:30')"}
{"userId":"5","date":"2021-01-18 12:05:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1425', '2021-01-18', '5', '59.93.139.208', '5', '2021-01-18 12:05:51')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('1425', '947', '5', '2021-01-18', '1', '59.93.139.208', '5', '2021-01-18 12:05:59', '', '')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('758', '0', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('758', '1', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('758', '2', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('758', '3', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('758', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('758', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('758', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('758', '', '', 'Array', '', 'Array', '', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('140', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('141', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('142', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('143', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('144', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('145', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('146', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('147', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('148', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('149', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('150', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('151', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('152', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('153', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('154', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('155', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('156', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('157', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('158', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('159', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('160', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('161', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('162', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('163', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('164', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('165', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('166', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('167', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('168', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('169', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('170', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('171', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('172', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('173', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('174', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('175', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('176', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('177', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('178', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('179', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('180', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('181', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('182', '758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:05:59","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('758', '59.93.139.208', '5', '2021-01-18 12:05:59')"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE onssid = '3360'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE onssid = '3361'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE onssid = '3362'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE onssid = '3363'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '0' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '' when ansid=79230 then '' when ansid=79231 then '' when ansid=79232 then '' when ansid=79233 then '' when ansid=79234 then '' when ansid=79235 then '' when ansid=79236 then '' when ansid=79237 then '' when ansid=79238 then '' when ansid=79239 then '' when ansid=79240 then '' when ansid=79241 then ''  when ansid=79242 then ''   when ansid=79243 then ''  when ansid=79244 then ''  when ansid=79245 then ''   when ansid=79246 then ''   when ansid=79247 then ''   when ansid=79248 then ''   when ansid=79249 then ''   when ansid=79250 then ''  when ansid=79251 then '' when ansid=79252 then '' when ansid=79253 then ''  when ansid=79254 then ''   when ansid=79255 then ''   when ansid=79256 then ''   when ansid=79257 then ''   when ansid=79258 then ''   when ansid=79259 then ''   when ansid=79260 then ''   when ansid=79261 then ''   when ansid=79262 then ''   when ansid=79263 then ''   when ansid=79264 then ''   when ansid=79265 then ''   when ansid=79266 then ''   when ansid=79267 then ''  when ansid=79268 then '' when ansid=79269 then '' when ansid=79270 then '' when ansid=79271 then '' when ansid=79272 then '' when ansid=79273 then '' when ansid=79274 then '' when ansid=79275 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.93.139.208',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-18 12:25:38'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE supvisstepid = '4844'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE visitfeedbackid = '3566'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE visitfeedbackid = '3567'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE visitfeedbackid = '3568'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE visitfeedbackid = '3569'"}
{"userId":"5","date":"2021-01-18 12:25:38","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:25:38' WHERE visitfeedbackid = '3570'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE onssid = '3360'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE onssid = '3361'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE onssid = '3362'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE onssid = '3363'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '0' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '' when ansid=79239 then '' when ansid=79240 then '' when ansid=79241 then ''  when ansid=79242 then ''   when ansid=79243 then ''  when ansid=79244 then ''  when ansid=79245 then ''   when ansid=79246 then ''   when ansid=79247 then ''   when ansid=79248 then ''   when ansid=79249 then ''   when ansid=79250 then ''  when ansid=79251 then '' when ansid=79252 then '' when ansid=79253 then ''  when ansid=79254 then ''   when ansid=79255 then ''   when ansid=79256 then ''   when ansid=79257 then ''   when ansid=79258 then ''   when ansid=79259 then ''   when ansid=79260 then ''   when ansid=79261 then ''   when ansid=79262 then ''   when ansid=79263 then ''   when ansid=79264 then ''   when ansid=79265 then ''   when ansid=79266 then ''   when ansid=79267 then ''  when ansid=79268 then '' when ansid=79269 then '' when ansid=79270 then '' when ansid=79271 then '' when ansid=79272 then '' when ansid=79273 then '' when ansid=79274 then '' when ansid=79275 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.93.139.208',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-18 12:35:13'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE supvisstepid = '4845'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE visitfeedbackid = '3566'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE visitfeedbackid = '3567'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE visitfeedbackid = '3568'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE visitfeedbackid = '3569'"}
{"userId":"5","date":"2021-01-18 12:35:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:35:13' WHERE visitfeedbackid = '3570'"}
{"userId":"5","date":"2021-01-18 12:36:22","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('5', '59.93.139.208', '2021-01-18 12:36:22')"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE sitesupervision SET `siteid` = '1425', `userid` = '5', `ancservicedays` = '', `samplecollectiondays` = '', `samplecollectionstartdate` = '2021-01-18', `numofsamplecollected` = '3', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15', `locationtype` = '', `establishmentyear` = '', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '758'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE onssid = '3360'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE onssid = '3361'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '0', `istrained` = '1', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE onssid = '3362'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE onssid = '3363'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=79222 then '2' when ansid=79223 then '1' when ansid=79224 then '1' when ansid=79225 then '0' when ansid=79226 then '1' when ansid=79227 then '1' when ansid=79228 then '1' when ansid=79229 then '1' when ansid=79230 then '1' when ansid=79231 then '1' when ansid=79232 then '1' when ansid=79233 then '1' when ansid=79234 then '1' when ansid=79235 then '1' when ansid=79236 then '1' when ansid=79237 then '1' when ansid=79238 then '3' when ansid=79239 then '3' when ansid=79240 then '3' when ansid=79241 then '1'  when ansid=79242 then ''   when ansid=79243 then '1'  when ansid=79244 then '1'  when ansid=79245 then ''   when ansid=79246 then '1'   when ansid=79247 then ''   when ansid=79248 then '1'   when ansid=79249 then ''   when ansid=79250 then '1'  when ansid=79251 then '1' when ansid=79252 then '1' when ansid=79253 then '1'  when ansid=79254 then ''   when ansid=79255 then '1'   when ansid=79256 then ''   when ansid=79257 then '1'   when ansid=79258 then ''   when ansid=79259 then '1'   when ansid=79260 then ''   when ansid=79261 then '1'   when ansid=79262 then ''   when ansid=79263 then '1'   when ansid=79264 then ''   when ansid=79265 then '1'   when ansid=79266 then ''   when ansid=79267 then '1'  when ansid=79268 then '1' when ansid=79269 then '1' when ansid=79270 then '1' when ansid=79271 then '1' when ansid=79272 then '1' when ansid=79273 then 'NO' when ansid=79274 then 'NO' when ansid=79275 then 'NO' end),\n\t\t\t\t\t\t\t\t ipaddress = '59.93.139.208',\n\t\t\t\t\t\t\t\tmodifiedby =5,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-18 12:56:15'\n\t\t\t\t\t\t\tWHERE ansid in ('79222','79223','79224','79225','79226','79227','79228','79229','79230','79231','79232','79233','79234','79235','79236','79237','79238','79239','79240','79241','79242','79243','79244','79245','79246','79247','79248','79249','79250','79251','79252','79253','79254','79255','79256','79257','79258','79259','79260','79261','79262','79263','79264','79265','79266','79267','79268','79269','79270','79271','79272','79273','79274','79275')"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE supvisstepid = '4846'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE visitfeedbackid = '3566'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE visitfeedbackid = '3567'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE visitfeedbackid = '3568'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE visitfeedbackid = '3569'"}
{"userId":"5","date":"2021-01-18 12:56:15","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '59.93.139.208', `modifiedby` = '5', `modifieddate` = '2021-01-18 12:56:15' WHERE visitfeedbackid = '3570'"}
{"userId":"243","date":"2021-01-18 15:45:49","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.211.54.122', '2021-01-18 15:45:49')"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE sitesupervision SET `siteid` = '381', `userid` = '243', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2021-01-17', `numofsamplecollected` = '100', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28', `locationtype` = '1', `establishmentyear` = '2008', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '757'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE onssid = '3356'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE onssid = '3357'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE onssid = '3358'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE onssid = '3359'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=79116 then '' when ansid=79117 then '' when ansid=79118 then '' when ansid=79119 then '' when ansid=79120 then ''  when ansid=79121 then ''   when ansid=79122 then ''  when ansid=79123 then '' when ansid=79125 then '' when ansid=79127 then '' when ansid=79129 then '' when ansid=79131 then '' when ansid=79133 then '' when ansid=79135 then '' when ansid=79137 then '' when ansid=79139 then '' when ansid=79141 then '' when ansid=79143 then '' when ansid=79145 then '' when ansid=79147 then '' when ansid=79149 then '' when ansid=79151 then '' when ansid=79153 then '' when ansid=79155 then '' when ansid=79157 then '' when ansid=79159 then '' when ansid=79161 then '' when ansid=79163 then '' when ansid=79165 then '' when ansid=79167 then '' when ansid=79169 then '' when ansid=79171 then '' when ansid=79173 then '' when ansid=79175 then '' when ansid=79176 then '' when ansid=79177 then '' when ansid=79178 then ''  when ansid=79179 then ''   when ansid=79180 then ''  when ansid=79181 then ''  when ansid=79182 then ''   when ansid=79183 then ''   when ansid=79184 then ''   when ansid=79185 then ''  when ansid=79186 then '' when ansid=79187 then '' when ansid=79188 then ''  when ansid=79189 then ''   when ansid=79190 then ''   when ansid=79191 then ''   when ansid=79192 then ''  when ansid=79193 then ''  when ansid=79194 then ''   when ansid=79195 then ''  when ansid=79196 then '' when ansid=79197 then '' when ansid=79198 then '' when ansid=79199 then '' when ansid=79200 then '' when ansid=79201 then '' when ansid=79202 then '' when ansid=79203 then '' when ansid=79204 then ''  when ansid=79205 then ''   when ansid=79206 then ''   when ansid=79207 then ''   when ansid=79208 then ''  when ansid=79209 then '' when ansid=79210 then ''  when ansid=79211 then ''   when ansid=79212 then ''  when ansid=79213 then '' when ansid=79214 then '' when ansid=79215 then '' when ansid=79216 then '' when ansid=79217 then '' when ansid=79218 then '' when ansid=79219 then '' when ansid=79220 then '' when ansid=79221 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '103.211.54.122',\n\t\t\t\t\t\t\t\tmodifiedby =243,\n\t\t\t\t\t\t\t\tmodifieddate = '2021-01-18 15:54:28'\n\t\t\t\t\t\t\tWHERE ansid in ('79116','79117','79118','79119','79120','79121','79122','79123','79125','79127','79129','79131','79133','79135','79137','79139','79141','79143','79145','79147','79149','79151','79153','79155','79157','79159','79161','79163','79165','79167','79169','79171','79173','79175','79176','79177','79178','79179','79180','79181','79182','79183','79184','79185','79186','79187','79188','79189','79190','79191','79192','79193','79194','79195','79196','79197','79198','79199','79200','79201','79202','79203','79204','79205','79206','79207','79208','79209','79210','79211','79212','79213','79214','79215','79216','79217','79218','79219','79220','79221')"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE supvisstepid = '4837'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE visitfeedbackid = '3561'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE visitfeedbackid = '3562'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE visitfeedbackid = '3563'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE visitfeedbackid = '3564'"}
{"userId":"243","date":"2021-01-18 15:54:28","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '103.211.54.122', `modifiedby` = '243', `modifieddate` = '2021-01-18 15:54:28' WHERE visitfeedbackid = '3565'"}
{"userId":"243","date":"2021-01-18 16:14:32","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.211.54.122', '2021-01-18 16:14:32')"}
{"userId":"2","date":"2021-01-18 16:15:28","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '103.211.54.122', '2021-01-18 16:15:28')"}
{"userId":"243","date":"2021-01-18 16:16:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('243', '103.211.54.122', '2021-01-18 16:16:06')"}
{"userId":"2","date":"2021-01-18 16:17:38","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('2', '103.211.54.122', '2021-01-18 16:17:38')"}
{"userId":"2","date":"2021-01-18 16:18:54","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:18:54', `isdeleted` = '1' WHERE userid = '73'"}
{"userId":"2","date":"2021-01-18 16:19:09","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:19:09', `isdeleted` = '1' WHERE userid = '118'"}
{"userId":"2","date":"2021-01-18 16:19:23","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:19:23', `isdeleted` = '1' WHERE userid = '116'"}
{"userId":"2","date":"2021-01-18 16:19:54","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:19:54', `isdeleted` = '1' WHERE userid = '242'"}
{"userId":"2","date":"2021-01-18 16:20:15","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:20:15', `isdeleted` = '1' WHERE userid = '117'"}
{"userId":"2","date":"2021-01-18 16:27:08","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Preety', 'Pathak', 'preetypathak@yahoo.co.in', '9415409772', '', '', '44adfb51408c40192fc041d2cc053df6', '5', '103.211.54.122', '2', '2021-01-18 16:27:08')"}
{"userId":"2","date":"2021-01-18 16:27:08","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('375', '101', '38', '656', '3', '0', '103.211.54.122', '2', '2021-01-18 16:27:08')"}
{"userId":"2","date":"2021-01-18 16:28:04","query":"UPDATE usermst SET `ipaddress` = '103.211.54.122', `modifiedby` = '2', `modifieddate` = '2021-01-18 16:28:04', `isdeleted` = '1' WHERE userid = '375'"}
{"userId":"2","date":"2021-01-18 16:29:01","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Preety', 'Pathak', 'preetypathak@yahoo.co.in', '9415409772', '', '', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.122', '2', '2021-01-18 16:29:01')"}
{"userId":"2","date":"2021-01-18 16:29:01","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('376', '101', '38', '656', '3', '0', '103.211.54.122', '2', '2021-01-18 16:29:01')"}
{"userId":"2","date":"2021-01-18 16:31:37","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Gagan', 'Doon', 'gagandoon2020@gmail.com', '9897604375', '', '', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.122', '2', '2021-01-18 16:31:37')"}
{"userId":"2","date":"2021-01-18 16:31:37","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('377', '101', '39', '598', '3', '0', '103.211.54.122', '2', '2021-01-18 16:31:37')"}
{"userId":"2","date":"2021-01-18 16:33:14","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Sami', 'Akhter', 'meojharkhand@gmail.com', '9234675030', '', '', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.122', '2', '2021-01-18 16:33:14')"}
{"userId":"2","date":"2021-01-18 16:33:14","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('378', '101', '16', '254', '3', '0', '103.211.54.122', '2', '2021-01-18 16:33:14')"}
{"userId":"2","date":"2021-01-18 16:45:15","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Rajesh', 'Kumar', 'ddstd_bsacs@bihar.gov.in', '7857913255', '', '', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.122', '2', '2021-01-18 16:45:15')"}
{"userId":"2","date":"2021-01-18 16:45:15","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('379', '101', '5', '89', '3', '0', '103.211.54.122', '2', '2021-01-18 16:45:15')"}
{"userId":"2","date":"2021-01-18 16:47:23","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Sabyasachi', 'Chakraborty', 'simudsacs@gmail.com', '9718834704', '', '', 'e10adc3949ba59abbe56e057f20f883e', '5', '103.211.54.122', '2', '2021-01-18 16:47:23')"}
{"userId":"2","date":"2021-01-18 16:47:23","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('380', '101', '10', '133', '3', '0', '103.211.54.122', '2', '2021-01-18 16:47:23')"}