INSERT INTO hp_messages_archive (`messageId`,`teamId`,`permission`,`leadId`,`campaignId`,`to_number`,`from_number`,`body`,`status`,`type`,`return_message`,`read_status`,`dated`,`allservices_campaignId`,`show_status`) VALUES
("13178","1262","","1349252","280","+16145540101","+16148605077","test sms mane","Sent","","","N","2016-01-06 12:25:26","0","Show"),
("18926","1262","","1349252","114","+16145540101","16145540101","Hi there, What\'s your name?","Sent","","","N","2016-01-12 12:50:59","0","Show"),
("18974","1262","","1349252","114","16143444406","16145540101","hello","Received","","","Y","2016-01-12 13:04:36","0","Show"),
("18975","1262","","1349252","114","16145540101","16143444406","Nice to meet your hello,  whats your email so I can send you your confirmation?","Sent","","","N","2016-01-12 13:04:36","0","Show"),
("18982","1262","","1349252","114","16143444406","16145540101","1040miller@gmail.com","Received","","","Y","2016-01-12 13:05:56","0","Show"),
("18983","1262","","1349252","114","16145540101","16143444406","Awesome! It\'ll be on its way in a few. is that ok?","Sent","","","N","2016-01-12 13:05:56","0","Show"),
("18984","1262","","1349252","114","16143444406","16145540101","yes","Received","","","Y","2016-01-12 13:06:07","0","Show"),
("18985","1262","","1349252","114","16145540101","16143444406","Perfect! Reply \"CONFIRM\" and I will send it asap. 
\nstandard sms rates apply","Sent","","","N","2016-01-12 13:06:07","0","Show"),
("18986","1262","","1349252","114","16143444406","16145540101","confirm","Received","","","Y","2016-01-12 13:06:30","0","Show"),
("18987","1262","","1349252","114","16145540101","16143444406","It\'s on its way! Thank you for reaching out. Someone will be in touch with you shortly. 
\n
\nIf you want to quit reply \"QUIT\"","Sent","","","N","2016-01-12 13:06:30","0","Show"),
("19039","1262","","1349252","114","16143444406","16145540101","quit","Received","","","Y","2016-01-12 13:40:35","0","Show"),
("19040","1262","","1349252","114","16145540101","16143444406","Sad to see you go.  If you decide to come back reply START","Sent","","","N","2016-01-12 13:40:35","0","Show"),
("19041","1262","","1349252","114","16143444406","16145540101","start","Received","","","Y","2016-01-12 13:43:54","0","Show"),
("19042","1262","","1349252","114","16145540101","16143444406","Glad to see you back!","Sent","","","N","2016-01-12 13:43:54","0","Show"),
("19043","1262","","1349252","114","16143444406","16145540101","start","Received","","","Y","2016-01-12 13:43:57","0","Show"),
("19044","1262","","1349252","114","16145540101","16143444406","Glad to see you back!","Sent","","","N","2016-01-12 13:43:57","0","Show"),
("19045","1262","","1349252","114","16143444406","16145540101","neiro","Received","","","Y","2016-01-12 13:43:59","0","Show"),
("19046","1262","","1349252","114","16145540101","16143444406","Please reply \"quit\" to unsubscribe , \"start\" to resubscribe and \"confirm\" to confirm","Sent","","","N","2016-01-12 13:43:59","0","Show"),
("2087820","1262","","1584534","544","+16145540101","+16143444406","test www.designblaze.com","Sent","inbound","","N","2016-02-16 18:13:56","0","Show"),
("2087821","1262","","1438375","544","+16144567599","+16143444406","test www.designblaze.com","Sent","inbound","","N","2016-02-16 18:15:20","0","Show"),
("2831998","1262","","13775738","0","+16145540101","+16146826422","Blackmon, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","Y","2017-02-15 23:17:30","0","Show"),
("2831999","1262","","3080554","0","+16145378783","+16146826422","Sharee, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","N","2017-02-15 23:26:06","0","Show"),
("2832040","1262","","13794470","0","+16145378783","+16146826422","Sharee, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","N","2017-02-16 10:54:31","0","Show"),
("2832114","1262","","13809085","0","+17402154036","+16146826422","Robin, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","N","2017-02-16 11:16:31","0","Show"),
("2863851","1262","","13847618","0","+14193719932","+16146826422","David, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","N","2017-02-18 18:05:49","0","Show"),
("3072777","1262","","14853710","0","+16785779877","+16146826422","Angel, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","N","2017-04-09 17:27:45","0","Show"),
("3075291","1262","","14920346","0","+16142049419","+16146826422","Leyah, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","Y","2017-04-11 19:27:54","0","Show"),
("3443486","1262","","13775738","0","+16145540101","+16146826422","Janeiro, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","Y","2017-06-20 21:08:13","0","Show"),
("3447477","1262","1262","17445122","0","+17274124082","+16148605077","Hi Nicole, call 614-682-6422\nTo unsubscribe reply with unsub","Sent","","","Y","2017-06-21 15:19:54","0","Show"),
("3447638","1262","","17445122","0","+17274124082","+16146826422","Temple, thanks for calling in to listen to my free recorded message. Check your voicemail and email over the next few moments to see the rest of this powerful new feature in action. 
\nTo unsubscribe reply with unsub","Sent","","","Y","2017-06-21 15:24:29","0","Show"),
("3468526","1262","1262","13775738","280","+16148605077","+16145540101","Hey, this is a test","Received","inbound","","Y","2017-06-23 14:33:11","0","Show"),
("3479813","1262","1262","13775738","0","+16145540101","+16148605077","HI  Janeiro, We have your account setup... here are a few details: http://screencast-o-matic.com/watch/cb1ZbplhCa\nTo unsubscribe reply with unsub","Sent","","","N","2017-06-24 13:43:33","0","Show"),
("3479897","1262","1262","17445122","0","+17274124082","+16148605077","Hey Nicole, We\'ve got your account setup. Here are a few details: http://screencast-o-matic.com/watch/cb1ZbplhCa\nTo unsubscribe reply with unsub","Sent","","","Y","2017-06-24 13:50:51","0","Show"),
("3481123","1262","1262","17445122","0","+17274124082","+16148605077","Hey Nicole, just wanted to make sure you got access to the account I set up for you. Did you get the email?\nTo unsubscribe reply with unsub","Sent","","","Y","2017-06-26 10:26:33","0","Show"),
("3481127","1262","1262","17445122","0","+17274124082","+16148605077","Here are a few details about the account: http://screencast-o-matic.com/watch/cb1ZbplhCa","Sent","","","Y","2017-06-26 10:29:02","0","Show"),
("3481131","1262","1262","17445122","280","+16148605077","+17274124082","Hi there yes I sent you an email I decided to go with hot prospects instead. Thank you so much","Received","inbound","","Y","2017-06-26 10:39:17","0","Show"),
("3481137","1262","1262","17445122","0","+17274124082","+16148605077","Ok. Thanks for considering our system and let me know if you have any questions about anything else. Thanks.","Sent","","","Y","2017-06-26 10:51:17","0","Show"),
("3564065","1262","1262","18146003","3519","+16149800068","+12183500452","Your Updated Zero Cost Prescription Benefit  MEMBER#:UXAAXX000719  GROUP:UXAAXX  BIN:013824  PCN:RXCUT  Present info at pharmacy for immediate use","Received","inbound","","N","2017-07-19 09:59:38","0","Show"),
("3766273","1262","1262","18928711","3455","+16143104121","+16142541025","Hey.  I am set for tomorrow. Sorry do not use messenger.","Received","inbound","","Y","2017-08-17 15:21:40","0","Show"),
("3766555","1262","1262","18928711","3455","+16143104121","+16142541025","So sorry. Texted to wrong number.","Received","inbound","","Y","2017-08-17 18:51:14","0","Show");



