{"userId":"30","date":"2019-04-17 18:43:56","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('30', '117.214.48.137', '2019-04-17 18:43:56')"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:46:23","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '' when ansid=76153 then '' when ansid=76154 then '' when ansid=76155 then '' when ansid=76156 then '' when ansid=76157 then '' when ansid=76158 then '' when ansid=76159 then '' when ansid=76161 then '' when ansid=76163 then '' when ansid=76165 then '' when ansid=76167 then '' when ansid=76169 then '' when ansid=76171 then '' when ansid=76173 then '' when ansid=76175 then '' when ansid=76177 then '' when ansid=76179 then '' when ansid=76181 then '' when ansid=76183 then '' when ansid=76185 then '' when ansid=76187 then '' when ansid=76189 then '' when ansid=76191 then '' when ansid=76193 then '' when ansid=76195 then '' when ansid=76197 then '' when ansid=76199 then '' when ansid=76201 then '' when ansid=76203 then '' when ansid=76205 then '' when ansid=76207 then '' when ansid=76209 then '' when ansid=76211 then '' when ansid=76212 then '' when ansid=76213 then '' when ansid=76214 then '' when ansid=76215 then '' when ansid=76216 then '' when ansid=76217 then '' when ansid=76218 then '' when ansid=76219 then '' when ansid=76220 then '' when ansid=76221 then '' when ansid=76222 then '' when ansid=76223 then '' when ansid=76224 then '' when ansid=76225 then '' when ansid=76226 then '' when ansid=76227 then '' when ansid=76228 then '' when ansid=76229 then '' when ansid=76230 then '' when ansid=76231 then '' when ansid=76232 then '' when ansid=76233 then '' when ansid=76234 then '' when ansid=76235 then '' when ansid=76236 then '' when ansid=76237 then '' when ansid=76238 then '' when ansid=76239 then '' when ansid=76240 then '' when ansid=76241 then '' when ansid=76242 then '' when ansid=76243 then '' when ansid=76244 then '' when ansid=76245 then '' when ansid=76246 then '' when ansid=76247 then '' when ansid=76248 then '' when ansid=76249 then '' when ansid=76250 then '' when ansid=76251 then '' when ansid=76252 then '' when ansid=76253 then '' when ansid=76254 then '' when ansid=76255 then '' when ansid=76256 then '' when ansid=76257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:46:23'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE supvisstepid = '4659'"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:46:24","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:46:23' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '' when ansid=76161 then '' when ansid=76163 then '' when ansid=76165 then '' when ansid=76167 then '' when ansid=76169 then '' when ansid=76171 then '' when ansid=76173 then '' when ansid=76175 then '' when ansid=76177 then '' when ansid=76179 then '' when ansid=76181 then '' when ansid=76183 then '' when ansid=76185 then '' when ansid=76187 then '' when ansid=76189 then '' when ansid=76191 then '' when ansid=76193 then '' when ansid=76195 then '' when ansid=76197 then '' when ansid=76199 then '' when ansid=76201 then '' when ansid=76203 then '' when ansid=76205 then '' when ansid=76207 then '' when ansid=76209 then '' when ansid=76211 then '' when ansid=76212 then '' when ansid=76213 then '' when ansid=76214 then '' when ansid=76215 then '' when ansid=76216 then '' when ansid=76217 then '' when ansid=76218 then '' when ansid=76219 then '' when ansid=76220 then '' when ansid=76221 then '' when ansid=76222 then '' when ansid=76223 then '' when ansid=76224 then '' when ansid=76225 then '' when ansid=76226 then '' when ansid=76227 then '' when ansid=76228 then '' when ansid=76229 then '' when ansid=76230 then '' when ansid=76231 then '' when ansid=76232 then '' when ansid=76233 then '' when ansid=76234 then '' when ansid=76235 then '' when ansid=76236 then '' when ansid=76237 then '' when ansid=76238 then '' when ansid=76239 then '' when ansid=76240 then '' when ansid=76241 then '' when ansid=76242 then '' when ansid=76243 then '' when ansid=76244 then '' when ansid=76245 then '' when ansid=76246 then '' when ansid=76247 then '' when ansid=76248 then '' when ansid=76249 then '' when ansid=76250 then '' when ansid=76251 then '' when ansid=76252 then '' when ansid=76253 then '' when ansid=76254 then '' when ansid=76255 then '' when ansid=76256 then '' when ansid=76257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:47:21'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE supvisstepid = '4660'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:47:21","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:47:21' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 18:48:23","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:25' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:25' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:25' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:25' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '2' when ansid=76161 then '2' when ansid=76163 then '450' when ansid=76165 then '0' when ansid=76167 then '0' when ansid=76169 then '532' when ansid=76171 then '1' when ansid=76173 then '1' when ansid=76175 then '' when ansid=76177 then '' when ansid=76179 then '' when ansid=76181 then '' when ansid=76183 then '' when ansid=76185 then '' when ansid=76187 then '' when ansid=76189 then '' when ansid=76191 then '' when ansid=76193 then '' when ansid=76195 then '' when ansid=76197 then '' when ansid=76199 then '' when ansid=76201 then '' when ansid=76203 then '' when ansid=76205 then '' when ansid=76207 then '' when ansid=76209 then '' when ansid=76211 then '' when ansid=76212 then '' when ansid=76213 then '' when ansid=76214 then '' when ansid=76215 then '' when ansid=76216 then '' when ansid=76217 then '' when ansid=76218 then '' when ansid=76219 then '' when ansid=76220 then '' when ansid=76221 then '' when ansid=76222 then '' when ansid=76223 then '' when ansid=76224 then '' when ansid=76225 then '' when ansid=76226 then '' when ansid=76227 then '' when ansid=76228 then '' when ansid=76229 then '' when ansid=76230 then '' when ansid=76231 then '' when ansid=76232 then '' when ansid=76233 then '' when ansid=76234 then '' when ansid=76235 then '' when ansid=76236 then '' when ansid=76237 then '' when ansid=76238 then '' when ansid=76239 then '' when ansid=76240 then '' when ansid=76241 then '' when ansid=76242 then '' when ansid=76243 then '' when ansid=76244 then '' when ansid=76245 then '' when ansid=76246 then '' when ansid=76247 then '' when ansid=76248 then '' when ansid=76249 then '' when ansid=76250 then '' when ansid=76251 then '' when ansid=76252 then '' when ansid=76253 then '' when ansid=76254 then '' when ansid=76255 then '' when ansid=76256 then '' when ansid=76257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:48:23'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE supvisstepid = '4661'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:48:25","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:48:23' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '2' when ansid=76161 then '2' when ansid=76163 then '450' when ansid=76165 then '0' when ansid=76167 then '0' when ansid=76169 then '532' when ansid=76171 then '1' when ansid=76173 then '1' when ansid=76175 then '2' when ansid=76177 then '200' when ansid=76179 then '482' when ansid=76181 then '419' when ansid=76183 then '30' when ansid=76185 then '1' when ansid=76187 then '0' when ansid=76189 then '450' when ansid=76191 then '532' when ansid=76193 then '2' when ansid=76195 then '2' when ansid=76197 then '1' when ansid=76199 then '3' when ansid=76201 then '' when ansid=76203 then '' when ansid=76205 then '' when ansid=76207 then '' when ansid=76209 then '' when ansid=76211 then '' when ansid=76212 then '' when ansid=76213 then '' when ansid=76214 then '' when ansid=76215 then '' when ansid=76216 then '' when ansid=76217 then '' when ansid=76218 then '' when ansid=76219 then '' when ansid=76220 then '' when ansid=76221 then '' when ansid=76222 then '' when ansid=76223 then '' when ansid=76224 then '' when ansid=76225 then '' when ansid=76226 then '' when ansid=76227 then '' when ansid=76228 then '' when ansid=76229 then '' when ansid=76230 then '' when ansid=76231 then '' when ansid=76232 then '' when ansid=76233 then '' when ansid=76234 then '' when ansid=76235 then '' when ansid=76236 then '' when ansid=76237 then '' when ansid=76238 then '' when ansid=76239 then '' when ansid=76240 then '' when ansid=76241 then '' when ansid=76242 then '' when ansid=76243 then '' when ansid=76244 then '' when ansid=76245 then '' when ansid=76246 then '' when ansid=76247 then '' when ansid=76248 then '' when ansid=76249 then '' when ansid=76250 then '' when ansid=76251 then '' when ansid=76252 then '' when ansid=76253 then '' when ansid=76254 then '' when ansid=76255 then '' when ansid=76256 then '' when ansid=76257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:50:13'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE supvisstepid = '4662'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:50:13","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:13' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '2' when ansid=76161 then '2' when ansid=76163 then '450' when ansid=76165 then '0' when ansid=76167 then '0' when ansid=76169 then '532' when ansid=76171 then '1' when ansid=76173 then '1' when ansid=76175 then '2' when ansid=76177 then '200' when ansid=76179 then '482' when ansid=76181 then '419' when ansid=76183 then '30' when ansid=76185 then '1' when ansid=76187 then '0' when ansid=76189 then '450' when ansid=76191 then '532' when ansid=76193 then '2' when ansid=76195 then '2' when ansid=76197 then '1' when ansid=76199 then '3' when ansid=76201 then '1' when ansid=76203 then '1' when ansid=76205 then '1' when ansid=76207 then '0' when ansid=76209 then '1' when ansid=76211 then '' when ansid=76212 then '' when ansid=76213 then '' when ansid=76214 then '' when ansid=76215 then '' when ansid=76216 then '' when ansid=76217 then '' when ansid=76218 then '' when ansid=76219 then '' when ansid=76220 then '' when ansid=76221 then '' when ansid=76222 then '' when ansid=76223 then '' when ansid=76224 then '' when ansid=76225 then '' when ansid=76226 then '' when ansid=76227 then '' when ansid=76228 then '' when ansid=76229 then '' when ansid=76230 then '' when ansid=76231 then '' when ansid=76232 then '' when ansid=76233 then '' when ansid=76234 then '' when ansid=76235 then '' when ansid=76236 then '' when ansid=76237 then '' when ansid=76238 then '' when ansid=76239 then '' when ansid=76240 then '' when ansid=76241 then '' when ansid=76242 then '' when ansid=76243 then '' when ansid=76244 then '' when ansid=76245 then '' when ansid=76246 then '' when ansid=76247 then '' when ansid=76248 then '' when ansid=76249 then '' when ansid=76250 then '' when ansid=76251 then '' when ansid=76252 then '' when ansid=76253 then '' when ansid=76254 then '' when ansid=76255 then '' when ansid=76256 then '' when ansid=76257 then '' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:50:48'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE supvisstepid = '4663'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:50:48","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:50:48' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 18:58:58","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '2' when ansid=76161 then '2' when ansid=76163 then '450' when ansid=76165 then '0' when ansid=76167 then '0' when ansid=76169 then '532' when ansid=76171 then '1' when ansid=76173 then '1' when ansid=76175 then '2' when ansid=76177 then '200' when ansid=76179 then '482' when ansid=76181 then '419' when ansid=76183 then '30' when ansid=76185 then '1' when ansid=76187 then '0' when ansid=76189 then '450' when ansid=76191 then '532' when ansid=76193 then '2' when ansid=76195 then '2' when ansid=76197 then '1' when ansid=76199 then '3' when ansid=76201 then '1' when ansid=76203 then '1' when ansid=76205 then '1' when ansid=76207 then '0' when ansid=76209 then '1' when ansid=76211 then '2' when ansid=76212 then '2' when ansid=76213 then '47' when ansid=76214 then '47' when ansid=76215 then '' when ansid=76216 then '1' when ansid=76217 then '1' when ansid=76218 then '' when ansid=76219 then '1' when ansid=76220 then '' when ansid=76221 then '1' when ansid=76222 then '10' when ansid=76223 then '1' when ansid=76224 then '1' when ansid=76225 then 'Counsellor' when ansid=76226 then '1' when ansid=76227 then '' when ansid=76228 then '1' when ansid=76229 then '1' when ansid=76230 then '' when ansid=76231 then '1' when ansid=76232 then '4' when ansid=76233 then '1' when ansid=76234 then '1' when ansid=76235 then '1' when ansid=76236 then '2' when ansid=76237 then '1' when ansid=76238 then '1' when ansid=76239 then '1' when ansid=76240 then '1' when ansid=76241 then 'Not dispatched yet' when ansid=76242 then '5' when ansid=76243 then 'Thermocol box' when ansid=76244 then '2' when ansid=76245 then '1' when ansid=76246 then '1' when ansid=76247 then '' when ansid=76248 then '1' when ansid=76249 then '2' when ansid=76250 then '3' when ansid=76251 then '3' when ansid=76252 then '1' when ansid=76253 then '0' when ansid=76254 then 'PPTCT and blood collection facility in separate building. Needs coordination with ASHA' when ansid=76255 then 'Nil' when ansid=76256 then 'Centrifuge machine and refrigerator of ART center was being used. HSS needed coordination with ART staff.' when ansid=76257 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 18:58:58'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE supvisstepid = '4664'"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 18:59:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 18:58:58' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE sitesupervision SET `siteid` = '373', `userid` = '30', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2019-03-29', `numofsamplecollected` = '49', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54', `locationtype` = '1', `establishmentyear` = '2005', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '727'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Sriram Prasad', `staffdesigid` = '7', `isavailable` = '0', `exphss` = '1', `istrained` = '1', `remarks` = 'On leave', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE onssid = '3236'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE onsitestaffs SET `staffname` = 'Satwinder Kaur', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE onssid = '3237'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE onsitestaffs SET `staffname` = 'Santosh Kumar Ram', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '4', `istrained` = '1', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE onssid = '3238'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE onsitestaffs SET `staffname` = '', `staffdesigid` = '', `isavailable` = '0', `exphss` = '0', `istrained` = '0', `remarks` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE onssid = '3239'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE quesanstransaction\n\t\t\t\t\t\t\tSET queansvalue = (case when ansid=76152 then '1' when ansid=76153 then '2' when ansid=76154 then '2' when ansid=76155 then '2' when ansid=76156 then '2' when ansid=76157 then '180' when ansid=76158 then '1' when ansid=76159 then '2' when ansid=76161 then '2' when ansid=76163 then '450' when ansid=76165 then '0' when ansid=76167 then '0' when ansid=76169 then '532' when ansid=76171 then '1' when ansid=76173 then '1' when ansid=76175 then '2' when ansid=76177 then '200' when ansid=76179 then '482' when ansid=76181 then '419' when ansid=76183 then '30' when ansid=76185 then '1' when ansid=76187 then '0' when ansid=76189 then '450' when ansid=76191 then '532' when ansid=76193 then '2' when ansid=76195 then '2' when ansid=76197 then '1' when ansid=76199 then '3' when ansid=76201 then '1' when ansid=76203 then '1' when ansid=76205 then '1' when ansid=76207 then '0' when ansid=76209 then '1' when ansid=76211 then '2' when ansid=76212 then '2' when ansid=76213 then '47' when ansid=76214 then '47' when ansid=76215 then '' when ansid=76216 then '1' when ansid=76217 then '1' when ansid=76218 then '' when ansid=76219 then '1' when ansid=76220 then '' when ansid=76221 then '1' when ansid=76222 then '10' when ansid=76223 then '1' when ansid=76224 then '1' when ansid=76225 then 'Counsellor' when ansid=76226 then '1' when ansid=76227 then '' when ansid=76228 then '1' when ansid=76229 then '1' when ansid=76230 then '' when ansid=76231 then '1' when ansid=76232 then '4' when ansid=76233 then '1' when ansid=76234 then '1' when ansid=76235 then '1' when ansid=76236 then '2' when ansid=76237 then '1' when ansid=76238 then '1' when ansid=76239 then '1' when ansid=76240 then '1' when ansid=76241 then 'Not dispatched yet' when ansid=76242 then '5' when ansid=76243 then 'Thermocol box' when ansid=76244 then '2' when ansid=76245 then '1' when ansid=76246 then '1' when ansid=76247 then '' when ansid=76248 then '1' when ansid=76249 then '2' when ansid=76250 then '3' when ansid=76251 then '3' when ansid=76252 then '1' when ansid=76253 then '0' when ansid=76254 then 'PPTCT and blood collection facility in separate building. Needs coordination with ASHA' when ansid=76255 then 'Nil' when ansid=76256 then 'Centrifuge machine and refrigerator of ART center was being used. HSS needed coordination with ART staff.' when ansid=76257 then '2' end),\n\t\t\t\t\t\t\t\t ipaddress = '117.214.48.137',\n\t\t\t\t\t\t\t\tmodifiedby =30,\n\t\t\t\t\t\t\t\tmodifieddate = '2019-04-17 19:02:54'\n\t\t\t\t\t\t\tWHERE ansid in ('76152','76153','76154','76155','76156','76157','76158','76159','76161','76163','76165','76167','76169','76171','76173','76175','76177','76179','76181','76183','76185','76187','76189','76191','76193','76195','76197','76199','76201','76203','76205','76207','76209','76211','76212','76213','76214','76215','76216','76217','76218','76219','76220','76221','76222','76223','76224','76225','76226','76227','76228','76229','76230','76231','76232','76233','76234','76235','76236','76237','76238','76239','76240','76241','76242','76243','76244','76245','76246','76247','76248','76249','76250','76251','76252','76253','76254','76255','76256','76257')"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE supvisstepid = '4665'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE visitfeedback SET `feedback` = 'Blood collection facility away from ANC clinic and it depended upon ASHA who brought the clients for HSS.', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE visitfeedbackid = '3411'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE visitfeedback SET `feedback` = 'Centrifuge machine and refrigerator of ART center was being used and needed support of staff of this center.', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE visitfeedbackid = '3412'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE visitfeedbackid = '3413'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE visitfeedbackid = '3414'"} {"userId":"30","date":"2019-04-17 19:02:54","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '117.214.48.137', `modifiedby` = '30', `modifieddate` = '2019-04-17 19:02:54' WHERE visitfeedbackid = '3415'"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('357', '909', '30', '2019-04-17', '1', '117.214.48.137', '30', '2019-04-17 19:07:08', '', '')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '0', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '1', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '2', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '3', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '4', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '5', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('728', '6', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('728', '', '', 'Array', '', 'Array', '', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('728', '', '', 'Array', '', 'Array', '', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('728', '', '', 'Array', '', 'Array', '', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('728', '', '', 'Array', '', 'Array', '', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:09","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:26","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:27","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:28","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:29","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:30","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:32","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:33","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:34","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:37","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:38","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:39","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:40","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:41","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:43","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:46","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:48","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:50","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:51","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:52","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:55","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:56","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:07:57","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:01","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:02","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:04","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:05","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:07","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:08","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:11","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:12","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:13","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:14","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:15","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:16","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:17","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:18","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:19","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:20","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:21","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:22","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:23","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:24","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('728', '117.214.48.137', '30', '2019-04-17 19:07:08')"} {"userId":"30","date":"2019-04-17 19:08:25","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('728', '117.214.48.137', '30', '2019-04-17 19:07:08')"}