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
("28974","405","","855197","2064","rainmakertv.net@gmail.com","2015-12-07 14:41:02","N","539468417363","Sent","","0000-00-00 00:00:00","0","","0","","No","0","0"),
("28975","405","","855197","2065","rainmakertv.net@gmail.com","2015-12-07 14:56:23","N","885587882529","Sent","","0000-00-00 00:00:00","0","","0","","No","0","0"),
("28978","405","","855197","2068","rainmakertv.net@gmail.com","2015-12-07 15:22:06","Y","588248125370","Sent","","2015-12-08 20:01:00","6","","0","","No","0","0"),
("28979","405","","855197","2069","rainmakertv.net@gmail.com","2015-12-07 15:49:10","Y","167817376740","Sent","","2015-12-21 20:15:53","2","","0","","No","0","0"),
("259460","405","","368217","9269","ImpactInsMkg@gmail.com","2016-01-18 16:59:34","N","236641335813","Sent","","0000-00-00 00:00:00","0","","938523193122","0","No","0","0"),
("282201","405","","368217","10190","ImpactInsMkg@gmail.com","2016-01-22 00:10:04","N","578348963195","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("282202","405","","368217","10191","ImpactInsMkg@gmail.com","2016-01-22 00:10:04","N","578348963195","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("284787","405","","368199","10584","ImpactInsMkg@gmail.com","2016-01-22 15:45:45","N","843178615393","Generate","","0000-00-00 00:00:00","0","","360524650150","0","No","0","0"),
("285407","405","","368199","10591","ImpactInsMkg@gmail.com","2016-01-22 16:25:43","N","866132351197","Generate","","0000-00-00 00:00:00","0","","304754595411","0","No","0","0"),
("285411","405","","368201","10597","ImpactInsMkg@gmail.com","2016-01-22 16:49:23","N","612717395182","Generate","","0000-00-00 00:00:00","0","","882975898357","0","No","0","0"),
("288815","405","","1701286","10966","ImpactInsMkg@gmail.com","2016-01-25 10:44:12","N","153936567483","Generate","","0000-00-00 00:00:00","0","","872059427108","0","No","0","0"),
("288833","405","","368217","10972","ImpactInsMkg@gmail.com","2016-01-25 11:23:41","Y","990054083988","Open","","2016-01-25 11:24:54","1","","375395517656","0","No","0","0"),
("288840","405","","368217","10979","ImpactInsMkg@gmail.com","2016-01-25 11:36:52","Y","457588520506","Open","","2016-01-25 16:07:20","16","","609823973104","0","No","0","0"),
("289268","405","","368217","11104","ImpactInsMkg@gmail.com","2016-01-25 14:59:33","Y","939796042535","Open","","2016-01-25 15:01:53","10","","605110377585","0","No","0","0"),
("290047","405","","368217","11122","ImpactInsMkg@gmail.com","2016-01-25 16:06:57","Y","615901580872","Open","","2016-01-25 16:15:45","10","","150068824598","0","No","0","0"),
("290048","405","","368217","11123","ImpactInsMkg@gmail.com","2016-01-25 16:14:51","Y","380133242160","Open","","2016-01-26 16:19:21","13","","447695500170","0","No","0","0"),
("291066","405","","368228","11139","ImpactInsMkg@gmail.com","2016-01-26 00:10:03","Y","653223666455","Open","","2016-01-26 10:07:21","1","","0","0","No","0","0"),
("291067","405","","368228","11140","ImpactInsMkg@gmail.com","2016-01-26 00:10:04","Y","653223666455","Open","","2016-01-26 10:07:21","1","","0","0","No","0","0"),
("292769","405","","368217","11232","ImpactInsMkg@gmail.com","2016-01-26 10:50:38","Y","777713978104","Open","","2016-01-26 15:24:22","24","","357169219246","0","No","0","0"),
("294084","405","","368217","11303","ImpactInsMkg@gmail.com","2016-01-26 16:18:23","Y","826641954854","Open","","2016-01-26 16:21:05","6","","239499400928","0","No","0","0"),
("294085","405","","368217","11304","ImpactInsMkg@gmail.com","2016-01-26 16:30:34","Y","693596092145","Open","","2016-01-26 16:39:52","13","","793591377651","0","No","0","0"),
("294105","405","","368217","11324","ImpactInsMkg@gmail.com","2016-01-26 16:58:01","Y","642638499569","Open","","2016-01-26 16:58:54","2","","933838490862","0","No","0","0"),
("294106","405","","368217","11326","ImpactInsMkg@gmail.com","2016-01-26 17:02:47","Y","751105605950","Open","","2016-01-27 15:12:36","11","","957847125222","0","No","0","0"),
("298796","405","","368217","11660","ImpactInsMkg@gmail.com","2016-01-27 15:24:59","Y","718381881900","Open","","2016-01-27 15:28:28","6","","264063187595","0","No","0","0"),
("298799","405","","368217","11663","ImpactInsMkg@gmail.com","2016-01-27 15:33:01","Y","438100908277","Open","","2016-01-27 15:34:27","8","","987088819360","0","No","0","0"),
("298985","405","","368217","11669","ImpactInsMkg@gmail.com","2016-01-27 16:08:22","Y","764729002350","Open","","2016-01-27 16:10:24","6","","959184120083","0","No","0","0"),
("299003","405","","368217","11687","ImpactInsMkg@gmail.com","2016-01-27 17:14:21","Y","177807562611","Open","","2016-01-27 17:14:51","4","","492731349403","0","No","0","0"),
("299818","405","","368217","11706","ImpactInsMkg@gmail.com","2016-01-27 19:00:44","N","672845217306","Generate","","0000-00-00 00:00:00","0","","757259486941","0","No","0","0"),
("299819","405","","368217","11707","ImpactInsMkg@gmail.com","2016-01-27 19:01:11","Y","444285948574","Open","","2016-01-27 19:03:21","6","","683183044707","0","No","0","0"),
("299824","405","","368217","11711","ImpactInsMkg@gmail.com","2016-01-27 19:33:10","Y","386681168153","Open","","2016-01-27 19:33:51","6","","811397017259","0","No","0","0"),
("299825","405","","368217","11712","ImpactInsMkg@gmail.com","2016-01-27 19:43:12","Y","949521746253","Open","","2016-01-27 19:43:50","2","","643511779047","0","No","0","0"),
("299832","405","","368217","11717","ImpactInsMkg@gmail.com","2016-01-27 19:55:24","Y","103640132304","Open","","2016-01-27 20:06:35","5","","156215832848","0","No","0","0"),
("299834","405","","368217","11719","ImpactInsMkg@gmail.com","2016-01-27 20:02:31","Y","140474375616","Open","","2016-01-27 20:04:30","6","","244113865355","0","No","0","0"),
("299835","405","","368217","11720","ImpactInsMkg@gmail.com","2016-01-27 20:13:12","Y","346047182660","Open","","2016-01-27 20:14:16","6","","498397408658","0","No","0","0"),
("299838","405","","368217","11723","ImpactInsMkg@gmail.com","2016-01-27 20:20:08","Y","649191608512","Open","","2016-01-27 20:21:40","6","","733733241166","0","No","0","0"),
("299841","405","","368217","11726","ImpactInsMkg@gmail.com","2016-01-27 20:30:20","Y","817069339053","Open","","2016-01-28 15:09:25","10","","853340039774","0","No","0","0"),
("310029","405","","368217","12090","ImpactInsMkg@gmail.com","2016-01-28 15:08:46","Y","351789281703","Open","","2016-02-09 11:49:10","9","","907741253031","0","No","0","0"),
("310131","405","","368217","12122","ImpactInsMkg@gmail.com","2016-01-29 00:10:06","N","714796798583","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("330308","405","","368217","13471","ImpactInsMkg@gmail.com","2016-02-01 13:40:49","N","243671671766","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("330522","405","","1415306","13683","ImpactInsMkg@gmail.com","2016-02-01 15:00:04","N","412045926554","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("330569","405","","368217","13690","ImpactInsMkg@gmail.com","2016-02-01 15:30:06","Y","996872598771","Open","","2016-02-02 09:41:00","1","","0","0","No","0","0"),
("388839","405","","368199","16507","ImpactInsMkg@gmail.com","2016-02-05 11:09:58","Y","818139858962","Open","","2016-02-05 11:13:48","5","","683066257555","0","No","0","0"),
("388910","405","","368199","16508","ImpactInsMkg@gmail.com","2016-02-05 11:10:46","Y","524243554007","Open","","2016-02-08 16:02:10","8","","444656771933","0","No","0","0"),
("388951","405","","368199","16509","ImpactInsMkg@gmail.com","2016-02-05 11:11:10","Y","855941018089","Open","","2016-02-08 16:01:58","6","","541852084780","0","No","0","0"),
("405167","405","","368217","17139","ImpactInsMkg@gmail.com","2016-02-09 11:50:04","N","397739764209","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("405168","405","","368217","17140","ImpactInsMkg@gmail.com","2016-02-09 11:50:04","N","397739764209","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("420623","405","","369293","18473","ImpactInsMkg@gmail.com","2016-02-12 09:10:09","N","368153930921","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("420834","405","","1982513","18477","ImpactInsMkg@gmail.com","2016-02-12 09:20:09","Y","656273952079","Open","","2016-02-12 09:20:25","1","","0","0","No","0","0"),
("421201","405","","368192","18589","ImpactInsMkg@gmail.com","2016-02-12 10:00:09","N","410380740370","Generate","","0000-00-00 00:00:00","0","","0","0","No","0","0"),
("422304","405","","368192","18601","ImpactInsMkg@gmail.com","2016-02-12 10:40:10","Y","689962036302","Open","","2016-02-13 16:01:26","1","","0","0","No","0","0"),
("433698","405","","2263741","19553","ImpactInsMkg@gmail.com","2016-02-15 22:03:51","Y","242298352252","Open","","2016-02-15 22:04:31","1","","931379257654","0","No","0","0"),
("433702","405","","2263744","19557","ImpactInsMkg@gmail.com","2016-02-15 22:20:12","Y","825625737942","Open","","2016-02-22 04:57:52","6","","871366457035","0","No","0","0"),
("435852","405","","974991","19609","ImpactInsMkg@gmail.com","2016-02-16 07:33:55","Y","413000541925","Open","","2016-02-16 09:36:03","1","","857963042426","0","No","0","0"),
("435853","405","","974992","19609","ImpactInsMkg@gmail.com","2016-02-16 07:33:57","Y","166334789479","Open","","2016-02-16 07:34:12","1","","921341473469","0","No","0","0"),
("486585","405","","2347855","20904","ImpactInsMkg@gmail.com","2016-02-21 09:05:38","N","847300777537","Generate","","0000-00-00 00:00:00","0","","263592342147","0","No","0","0"),
("486586","405","","2347855","20905","ImpactInsMkg@gmail.com","2016-02-21 09:06:07","N","850063904607","Generate","","0000-00-00 00:00:00","0","","374173275241","0","No","0","0"),
("486587","405","","2347855","20906","ImpactInsMkg@gmail.com","2016-02-21 09:07:05","N","275505755702","Generate","","0000-00-00 00:00:00","0","","965638223662","0","No","0","0"),
("486588","405","","2347855","20907","ImpactInsMkg@gmail.com","2016-02-21 09:07:19","Y","579263681964","Open","","2016-02-21 09:12:19","2","","761837971210","0","No","0","0"),
("486810","405","","2347855","20920","ImpactInsMkg@gmail.com","2016-02-21 13:03:37","Y","413184016756","Open","","2016-02-21 13:05:03","1","","781221432425","0","No","0","0"),
("486811","405","","2347855","20921","ImpactInsMkg@gmail.com","2016-02-21 13:04:32","Y","375301133655","Open","","2016-02-21 13:44:03","1","","426213228004","0","No","0","0"),
("486817","405","","2347855","20924","ImpactInsMkg@gmail.com","2016-02-21 13:43:28","Y","268397952942","Open","","2016-02-21 13:45:58","2","","487821381818","0","No","0","0"),
("486818","405","","2347855","20926","ImpactInsMkg@gmail.com","2016-02-21 13:50:03","N","174806278850","Generate","","0000-00-00 00:00:00","0","","963730050297","0","No","0","0"),
("486819","405","","2347855","20927","ImpactInsMkg@gmail.com","2016-02-21 14:04:49","Y","191434416966","Open","","2016-02-21 14:05:57","1","","384451477974","0","No","0","0"),
("486820","405","","2347855","20928","ImpactInsMkg@gmail.com","2016-02-21 14:12:58","N","569625799218","Generate","","0000-00-00 00:00:00","0","","519097945559","0","No","0","0"),
("486821","405","","2347855","20929","ImpactInsMkg@gmail.com","2016-02-21 14:18:06","Y","549517580401","Open","","2016-02-21 14:20:48","1","","585574396327","0","No","0","0"),
("486822","405","","2347855","20930","ImpactInsMkg@gmail.com","2016-02-21 14:33:22","Y","360235270392","Open","","2016-02-21 14:43:45","2","","217348627559","0","No","0","0"),
("486827","405","","975092","20935","ImpactInsMkg@gmail.com","2016-02-21 14:46:27","N","408598785474","Generate","","0000-00-00 00:00:00","0","","726846934808","0","No","0","0"),
("486831","405","","975092","20939","ImpactInsMkg@gmail.com","2016-02-21 14:49:23","N","145864531537","Generate","","0000-00-00 00:00:00","0","","571846213145","0","No","0","0"),
("486832","405","","975092","20940","ImpactInsMkg@gmail.com","2016-02-21 14:49:46","N","550729367230","Generate","","0000-00-00 00:00:00","0","","752170741325","0","No","0","0"),
("486833","405","","975092","20941","ImpactInsMkg@gmail.com","2016-02-21 14:52:11","N","510284124594","Generate","","0000-00-00 00:00:00","0","","858676508348","0","No","0","0"),
("486834","405","","975092","20942","ImpactInsMkg@gmail.com","2016-02-21 14:57:38","N","916362892044","Generate","","0000-00-00 00:00:00","0","","630419069435","0","No","0","0"),
("486835","405","","2347855","20943","ImpactInsMkg@gmail.com","2016-02-21 15:12:35","Y","985973938647","Open","","2016-02-21 15:42:07","2","","443553441064","0","No","0","0"),
("486840","405","","2347855","20945","ImpactInsMkg@gmail.com","2016-02-21 15:25:31","Y","410997840389","Open","","2016-02-21 15:39:28","3","","330370144546","0","No","0","0"),
("486843","405","","2347855","20948","ImpactInsMkg@gmail.com","2016-02-21 15:54:12","Y","154296795697","Open","","2016-02-26 15:05:19","2","","682605881104","0","No","0","0"),
("486844","405","","2347855","20949","ImpactInsMkg@gmail.com","2016-02-21 15:54:27","Y","698026714613","Open","","2016-02-22 10:18:01","2","","527815851150","0","No","0","0"),
("486845","405","","2347855","20950","ImpactInsMkg@gmail.com","2016-02-21 15:54:47","Y","866928357072","Open","","2016-02-22 10:16:24","3","","496705488394","0","No","0","0"),
("486846","405","","2347855","20951","ImpactInsMkg@gmail.com","2016-02-21 15:55:00","Y","151008855039","Open","","2016-02-22 10:09:35","4","","311946721374","0","No","0","0"),
("486847","405","","2347855","20952","ImpactInsMkg@gmail.com","2016-02-21 16:06:25","Y","530708236386","Open","","2016-02-22 09:57:17","2","","726041529048","0","No","0","0"),
("486848","405","","2347855","20953","ImpactInsMkg@gmail.com","2016-02-21 16:09:41","Y","234757591923","Open","","2016-02-22 09:29:28","3","","286942189512","0","No","0","0"),
("535416","405","","2347855","24354","ImpactInsMkg@gmail.com","2016-02-26 15:01:24","Y","569936962705","Open","","2016-03-02 14:38:43","13","","200729069160","0","No","0","0"),
("576393","405","","2347855","33122","ImpactInsMkg@gmail.com","2016-03-02 15:39:53","Y","797507613617","Open","","2016-03-02 15:41:17","5","","796725587919","0","No","0","0"),
("576395","405","","2347855","33124","ImpactRepMkg@gmail.com","2016-03-02 15:45:53","N","656903822347","Generate","","0000-00-00 00:00:00","0","","440742020821","0","No","0","0"),
("576396","405","","2347855","33125","ImpactRepMkg@gmail.com","2016-03-02 15:47:40","N","491982948966","Generate","","0000-00-00 00:00:00","0","","980444011557","0","No","0","0"),
("576401","405","","2347855","33129","ImpactRepMkg@gmail.com","2016-03-02 15:55:13","Y","345928385946","Open","","2016-03-02 15:58:02","6","","222447703033","0","No","0","0"),
("576402","405","","2347855","33130","ImpactRepMkg@gmail.com","2016-03-02 15:55:38","Y","887467404454","Open","","2016-03-02 15:57:39","5","","333448022976","0","No","0","0"),
("576411","405","","2347855","33138","ImpactRepMkg@gmail.com","2016-03-02 16:11:27","N","882742902403","Generate","","0000-00-00 00:00:00","0","","197677824646","0","No","0","0"),
("576412","405","","2347855","33139","ImpactRepMkg@gmail.com","2016-03-02 16:11:49","Y","350672357063","Open","","2016-03-02 16:12:55","5","","147898169839","0","No","0","0"),
("576413","405","","2347855","33140","ImpactRepMkg@gmail.com","2016-03-02 16:13:52","Y","347343136789","Open","","2016-03-02 16:14:31","5","","852867023414","0","No","0","0"),
("588578","405","","2347855","33345","ImpactRepMkg@gmail.com","2016-03-03 10:04:29","Y","591632755473","Open","","2016-03-03 10:06:44","3","","308084005117","0","No","0","0"),
("588627","405","","2347855","33350","ImpactRepMkg@gmail.com","2016-03-03 10:10:45","Y","430772069701","Open","","2016-03-03 10:18:17","9","","323671897919","0","No","0","0"),
("588689","405","","2347855","33362","ImpactRepMkg@gmail.com","2016-03-03 10:22:03","Y","927894113445","Open","","2016-03-03 10:22:47","5","","215317108202","0","No","0","0"),
("588695","405","","2347855","33368","ImpactRepMkg@gmail.com","2016-03-03 10:29:56","Y","979573067696","Open","","2016-03-03 10:30:52","3","","742852369602","0","No","0","0"),
("588736","405","","2347855","33371","ImpactRepMkg@gmail.com","2016-03-03 10:32:10","Y","980460436316","Open","","2016-03-03 10:34:38","3","","207713098451","0","No","0","0"),
("589080","405","","2347855","33378","ImpactRepMkg@gmail.com","2016-03-03 10:45:26","Y","542170754261","Open","","2016-03-03 10:48:49","9","","137579499697","0","No","0","0"),
("589081","405","","2347855","33379","ImpactRepMkg@gmail.com","2016-03-03 10:45:52","Y","498996096989","Open","","2016-03-03 10:47:16","5","","311355048697","0","No","0","0"),
("589220","405","","2347855","33386","ImpactRepMkg@gmail.com","2016-03-03 10:56:53","N","350913461251","Generate","","0000-00-00 00:00:00","0","","516829476086","0","No","0","0"),
("589221","405","","2347855","33387","ImpactRepMkg@gmail.com","2016-03-03 10:57:06","Y","327484284620","Open","","2016-03-03 10:58:09","5","","442465825425","0","No","0","0"),
("589240","405","","2347855","33391","ImpactRepMkg@gmail.com","2016-03-03 11:00:48","Y","593882345966","Open","","2016-03-03 11:02:29","3","","430491170752","0","No","0","0"),
("589245","405","","2347855","33396","ImpactRepMkg@gmail.com","2016-03-03 11:12:54","N","993136357888","Generate","","0000-00-00 00:00:00","0","","717381517682","0","No","0","0"),
("589247","405","","2347855","33398","ImpactRepMkg@gmail.com","2016-03-03 11:16:12","Y","617666420759","Open","","2016-03-20 14:28:03","8","","868098149308","0","No","0","0"),
("589297","405","","2347855","33403","ImpactRepMkg@gmail.com","2016-03-03 11:24:31","Y","543689322518","Open","","2016-04-02 19:56:44","3","","594187623681","0","No","0","0"),
("760650","405","","2347855","46284","ImpactRepMkg@gmail.com","2016-03-20 14:10:11","Y","587994951661","Open","","2016-03-20 14:11:30","5","","422794409794","0","No","0","0"),
("760651","405","","2347855","46285","ImpactRepMkg@gmail.com","2016-03-20 14:23:25","Y","503983579995","Open","","2016-03-20 14:24:15","3","","641756998701","0","No","0","0"),
("760652","405","","2347855","46286","ImpactRepMkg@gmail.com","2016-03-20 14:29:59","Y","462668776931","Open","","2016-03-20 14:30:41","5","","159612573962","0","No","0","0"),
("760654","405","","2347855","46288","impactinsmkg@gmail.com","2016-03-20 14:35:06","N","234633711585","Generate","","0000-00-00 00:00:00","0","","845438363915","0","No","0","0"),
("760655","405","","2347855","46289","impactinsmkg@gmail.com","2016-03-20 14:36:20","Y","546477962424","Open","","2016-03-20 14:38:10","5","","604732287954","0","No","0","0"),
("760656","405","","2347855","46290","impactinsmkg@gmail.com","2016-03-20 14:48:08","Y","133499227790","Open","","2016-03-20 14:48:58","5","","526006684824","0","No","0","0"),
("761657","405","","2347855","46292","impactinsmkg@gmail.com","2016-03-20 14:58:25","Y","684231325751","Open","","2016-03-20 14:59:14","5","","413011881802","0","No","0","0"),
("762658","405","","2347855","46294","impactinsmkg@gmail.com","2016-03-20 15:01:58","Y","259813480963","Open","","2016-03-20 15:02:56","5","","295262818876","0","No","0","0"),
("762664","405","","2347855","46299","impactinsmkg@gmail.com","2016-03-20 15:51:21","Y","217926386278","Open","","2016-03-20 15:52:04","1","","955491157062","0","No","0","0"),
("762665","405","","2347855","46300","impactinsmkg@gmail.com","2016-03-20 15:56:10","Y","345134262647","Open","","2016-03-21 19:20:22","6","","927640384854","0","No","0","0");



