INSERT INTO hp_email_logsent_archive (`sentId`,`memberId`,`permission`,`leadId`,`emailId`,`from_email`,`sent_date`,`read_status`,`unique_id`,`sent_status`,`fail_reason`,`read_date`,`read_count`,`email_open_info`,`unbsubscribeId`,`unsubscribe`,`syncronize`,`refresh_status`,`allservices_campaignId`) VALUES
("630008","1215","","2506914","39275","sales@srswebsolutions.com","2016-03-07 18:27:38","Y","20160307182738.9509.4989","Open","","2016-03-08 17:40:28","2","{\"country\":\"US\",\"region\":\"CA\",\"city\":\"Mountain View\",\"ip\":\"64.233.172.222\",\"client-name\":\"Firefox\",\"user-agent\":\"Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy)\",\"client-os\":\"Windows\"}","423573781363","0","No","0","0"),
("630009","1215","","2506916","39276","sales@srswebsolutions.com","2016-03-07 18:28:00","N","20160307182800.29599.25013","Delivered","","0000-00-00 00:00:00","0","","511429386353","0","No","0","0"),
("630010","1215","","2506917","39277","sales@srswebsolutions.com","2016-03-07 18:28:11","Y","20160307182811.31079.60015","Open","","2016-03-07 18:51:11","1","{\"country\":\"US\",\"region\":\"Unknown\",\"city\":\"Unknown\",\"ip\":\"172.56.11.65\",\"client-name\":\"Mobile Safari\",\"user-agent\":\"Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/13B143\",\"client-os\":\"iOS\"}","864884220017","0","No","0","0"),
("2217977","1215","","4659977","92958","sales@srswebsolutions.com","2016-08-23 09:40:05","N","20160823094005.39252.11793.2FF7D127","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("2217978","1215","","4659977","92959","sales@srswebsolutions.com","2016-08-23 09:40:05","N","20160823094005.113137.78735.8275974C","Dropped","521 The IP 198.61.254.10 is Blacklisted by dnsbl-2.uceprotect.net. NET 198.61.254.0/24 is UCEPROTECT-Level2 listed because 6 abusers are hosted by /AS19994 there. See: http://www.uceprotect.net/rblcheck.php?ipr=198.61.254.10 --","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("2217981","1215","","2544541","92963","sales@srswebsolutions.com","2016-08-23 12:50:05","N","20160823125005.113317.18673.6BA22D5E","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("2248153","1215","","7465422","94566","sales@srswebsolutions.com","2016-08-25 14:50:05","N","20160825195005.20547.9068.F0509E9B","Delivered","","0000-00-00 00:00:00","0","","0","0","No","0","0");



