INSERT INTO hp_email_statistics (`stateId`,`memberId`,`emailId`,`templateId`,`subject`,`total_email`,`sent_email`,`open_email`,`bounce_email`,`spam_email`,`clicks_email`,`ubsubscribe_email`,`dated`) VALUES
("80729","1651","138068","","Quotes","2709","2475","1113","32","2","0","0","2016-11-21"),
("80730","1651","142454","16511481220000","Tried calling you","123","112","47","4","0","1","0","2016-12-08"),
("80731","1651","142510","16511481220000","Tried calling you","0","0","0","0","0","0","0","2016-12-09"),
("80752","1651","142608","0","Do you have Openings?","0","0","0","0","0","0","0","2016-12-12"),
("80753","1651","142609","0","Openings?","0","0","0","0","0","0","0","2016-12-12"),
("80812","1651","142817","0","Tried calling you","0","0","0","0","0","0","0","2016-12-15"),
("80817","1651","142827","0","Do you have openings?","0","0","0","0","0","0","0","2016-12-15"),
("80818","1651","142828","0","Do you have openings?","0","0","0","0","0","0","0","2016-12-15"),
("80833","1651","142891","0","Quotes","0","0","0","0","0","0","0","2016-12-16"),
("81135","1651","143510","0","Still hiring?","0","0","0","0","0","0","0","2016-12-27"),
("81206","1651","143755","0","Quote","0","0","0","0","0","0","0","2017-01-04"),
("81226","1651","143880","0","Tried calling you","0","0","0","0","0","0","0","2017-01-06"),
("81233","1651","143899","0","Openings?","0","0","0","0","0","0","0","2017-01-06"),
("81265","1651","144042","0","Hiring?","0","0","0","0","0","0","0","2017-01-09"),
("81316","1651","144390","0","Quotes","0","0","0","0","0","0","0","2017-01-13"),
("81352","1651","144652","16511483990412","Openings?","0","0","0","0","0","0","0","2017-01-17"),
("102722","1651","167401","0","Openings?","0","0","0","0","0","0","0","2017-01-27"),
("103179","1651","169044","0","Tried Calling you.","0","0","0","0","0","0","0","2017-02-14"),
("105041","1651","170941","0","Tried calling you","0","0","0","0","0","0","0","2017-02-14"),
("105047","1651","171013","0","Tried Calling you.","0","0","0","0","0","0","0","2017-02-15"),
("105048","1651","171015","0","Tried calling you","0","0","0","0","0","0","0","2017-02-15"),
("106231","1651","172305","0","Tried calling you","0","0","0","0","0","0","0","2017-02-16"),
("106249","1651","172453","0","Quotes","0","0","0","0","0","0","0","2017-02-17"),
("106291","1651","172812","0","Quotes","0","0","0","0","0","0","0","2017-02-21"),
("106312","1651","172921","0","Quotes","0","0","0","0","0","0","0","2017-02-22"),
("106717","1651","174208","0","Quotes","0","0","0","0","0","0","0","2017-03-07"),
("106755","1651","174483","0","Quotes","0","0","0","0","0","0","0","2017-03-09"),
("106835","1651","174884","0","cases","0","0","0","0","0","0","0","2017-03-13"),
("106838","1651","174950","0","Immigration Case","0","0","0","0","0","0","0","2017-03-14"),
("106847","1651","175127","0","still hiring?","0","0","0","0","0","0","0","2017-03-15"),
("106875","1651","175276","0","Conversation with  Business owners","0","0","0","0","0","0","0","2017-03-16"),
("106943","1651","175725","0","Applications","0","0","0","0","0","0","0","2017-03-20"),
("107670","1651","177855","0","Tried calling you","0","0","0","0","0","0","0","2017-03-29"),
("108834","1651","179084","0","Tried calling you","0","0","0","0","0","0","0","2017-03-30"),
("111113","1651","186553","0","Job Opening?","0","0","0","0","0","0","0","2017-05-01"),
("111145","1651","186752","0","Hiring?","0","0","0","0","0","0","0","2017-05-02"),
("113884","1651","191055","0","still hiring?","0","0","0","0","0","0","0","2017-05-10"),
("113899","1651","191161","0","Hiring Process","0","0","0","0","0","0","0","2017-05-11"),
("116445","1651","197281","0","Programs","0","0","0","0","0","0","0","2017-05-23"),
("116911","1651","214910","0","Appointments","0","0","0","0","0","0","0","2017-06-14"),
("117133","1651","218213","0","Need more sales?","0","0","0","0","0","0","0","2017-06-21"),
("118019","1651","239921","0","Final Expense  Quotes","0","0","0","0","0","0","0","2017-07-28"),
("118656","1651","249700","0","Get prequalified applicants using Artifcial Intelligence","0","0","0","0","0","0","0","2017-08-17"),
("118667","1651","249755","16511490877963","Offer 40 hours","0","0","0","0","0","0","0","2017-08-17"),
("118679","1651","249854","0","Applicants using JobBot","0","0","0","0","0","0","0","2017-08-18"),
("118879","1651","256064","0","Tried calling","0","0","0","0","0","0","0","2017-08-30"),
("118958","1651","258317","0","Tried calling you","0","0","0","0","0","0","0","2017-09-05"),
("119039","1651","262301","0","Tried calling","0","0","0","0","0","0","0","2017-09-12"),
("119040","1651","262346","0","Tried calling","0","0","0","0","0","0","0","2017-09-12"),
("119085","1651","263717","0","Openings?","0","0","0","0","0","0","0","2017-09-14"),
("123479","1651","285535","0","Fees","0","0","0","0","0","0","0","2017-11-01"),
("123483","1651","285940","0","Tried calling","0","0","0","0","0","0","0","2017-11-02"),
("124595","1651","301591","0","new lead","0","0","0","0","0","0","0","2017-12-11"),
("125753","1651","369735","0","Potholes at your property","0","0","0","0","0","0","0","2018-01-31"),
("125787","1651","371607","0","Potholes at your property","0","0","0","0","0","0","0","2018-02-01"),
("125881","1651","374876","0","Potholes in your area","0","0","0","0","0","0","0","2018-02-06"),
("125883","1651","374958","0","Potholes at your property","0","0","0","0","0","0","0","2018-02-07"),
("126053","1651","379615","0","potholes at your property.","0","0","0","0","0","0","0","2018-02-21");



