INSERT INTO hp_messages (`messageId`,`teamId`,`permission`,`leadId`,`campaignId`,`to_number`,`from_number`,`body`,`status`,`type`,`return_message`,`read_status`,`dated`,`allservices_campaignId`,`show_status`) VALUES
("7100944","872","872","31714242","0","+17042702221","+17042319445","Wow","Received","","","Y","2018-05-10 18:50:38","0","Show"),
("7100977","872","872","31714239","0","+17049313531","+17042702221","test this system wowow to this system
\nTo unsubscribe reply with unsub","Sent","","","Y","2018-05-10 18:56:02","0","Show"),
("7100980","872","872","31714239","0","+17042702221","+17049313531","that actually worked but I can\'t get the email to work","Received","normal_broad","","Y","2018-05-10 18:57:26","0","Show"),
("7226359","872","872","31714242","0","+17042702221","+17042319445","Test","Received","normal_broad","","Y","2018-05-16 12:31:01","0","Show"),
("7302895","872","","31714242","1305","+17042319445","17042319445","Thank you for calling our automated tele-subscription line.  Please reply with your first name so I know who I\'m talking to.{{PreviousAnswer}}","Sent","","","Y","2018-05-17 17:17:09","0","Show"),
("7302911","872","872","31714242","1305","17042702221","17042319445","john","Received","","","Y","2018-05-17 17:18:13","0","Show"),
("7302912","872","872","31714242","1305","17042319445","17042702221","Nice to meet you John! As a speicial gift, I\'m sending a 3 night resort stay in either Las Vegas or Orlando.  Please reply with your email.","Sent","","","Y","2018-05-17 17:18:13","0","Show"),
("7302920","872","872","31714242","1305","17042702221","17042319445","yjohnsp@gmail.com","Received","","","Y","2018-05-17 17:18:38","0","Show"),
("7302921","872","872","31714242","1305","17042319445","17042702221","Perfect. Reply \"YES\" now to confirm so I can add you to my list. I\'ll never spam you and will only text from time to time. Standard data rates apply.","Sent","","","Y","2018-05-17 17:18:38","0","Show"),
("7302927","872","872","31714242","1305","17042702221","17042319445","yes","Received","","","Y","2018-05-17 17:18:52","0","Show"),
("7302928","872","872","31714242","1305","17042319445","17042702221","Thank you for joining. Your special gift will arrive in your email soon. By the way to leave at any time reply \"BYE\".","Sent","","","Y","2018-05-17 17:18:52","0","Show"),
("7306789","872","","32133622","1305","+19373214968","19373214968","Thank you for calling our automated tele-subscription line.  Please reply with your first name so I know who I\'m talking to.","Sent","","","Y","2018-05-17 17:47:25","0","Show"),
("7306807","872","872","32133622","1305","17042702221","19373214968","quinta","Received","","","Y","2018-05-17 17:48:00","0","Show"),
("7306808","872","872","32133622","1305","19373214968","17042702221","Nice to meet you Quinta! As a speicial gift, I\'m sending a 3 night resort stay in either Las Vegas or Orlando.  Please reply with your email.","Sent","","","Y","2018-05-17 17:48:00","0","Show"),
("7306836","872","872","32133622","1305","17042702221","19373214968","qpressley@gmail.com","Received","","","Y","2018-05-17 17:49:01","0","Show"),
("7306837","872","872","32133622","1305","19373214968","17042702221","Perfect. Reply \"YES\" now to confirm so I can add you to my list. I\'ll never spam you and will only text from time to time. Standard data rates apply.","Sent","","","Y","2018-05-17 17:49:01","0","Show"),
("7306843","872","872","32133622","1305","17042702221","19373214968","yes","Received","","","Y","2018-05-17 17:49:12","0","Show"),
("7306844","872","872","32133622","1305","19373214968","17042702221","Thank you for joining. Your special gift will arrive in your email soon. By the way to leave at any time reply \"BYE\".","Sent","","","Y","2018-05-17 17:49:12","0","Show"),
("7307081","872","872","32133622","0","+19373214968","+17042702221","Hey just wanted to thank you again for your help. Maybe you can do the voice?","Sent","","","Y","2018-05-17 17:58:10","0","Show"),
("7307094","872","872","31714242","0","+17042319445","+17042702221","This system is expensive.","Sent","","","Y","2018-05-17 17:58:53","0","Show"),
("7309383","872","","32252198","1305","+17042005381","17042005381","Thank you for calling our automated tele-subscription line.  Please reply with your first name so I know who I\'m talking to.","Sent","","","N","2018-05-17 21:25:00","0","Show"),
("7378192","872","","32133622","1305","+19373214968","19373214968","Thank you for calling our automated tele-subscription line.  Please reply with your first name so I know who I\'m talking to.","Sent","","","Y","2018-05-20 17:50:54","0","Show"),
("7378193","872","872","32133622","1305","17042702221","19373214968","quinta","Received","","","Y","2018-05-20 17:51:29","0","Show"),
("7378194","872","872","32133622","1305","19373214968","17042702221","Nice to meet you Quinta! As a speicial gift, I\'m sending a 3 night resort stay in either Las Vegas or Orlando.  Please reply with your email.","Sent","","","Y","2018-05-20 17:51:29","0","Show"),
("7818932","872","872","32252198","1305","17042702221","17042005381","geziuzo of wakanda\n(adjacent)","Received","","","N","2018-05-27 11:29:33","0","Show"),
("7818933","872","872","32252198","1305","17042005381","17042702221","Nice to meet you Geziuzo of Wakanda\n(adjacent)! As a speicial gift, I\'m sending a 3 night resort stay in either Las Vegas or Orlando.  Please reply with your email.","Sent","","","N","2018-05-27 11:29:33","0","Show"),
("7819002","872","872","32252198","1305","17042702221","17042005381","agm972@sbcglobal.net","Received","","","N","2018-05-27 11:32:21","0","Show"),
("7819003","872","872","32252198","1305","17042005381","17042702221","Perfect. Reply \"YES\" now to confirm so I can add you to my list. I\'ll never spam you and will only text from time to time. Standard data rates apply.","Sent","","","N","2018-05-27 11:32:21","0","Show"),
("7819006","872","872","32252198","1305","17042702221","17042005381","yes","Received","","","N","2018-05-27 11:34:31","0","Show"),
("7819007","872","872","32252198","1305","17042005381","17042702221","Thank you for joining. Your special gift will arrive in your email soon. By the way to leave at any time reply \"BYE\".","Sent","","","N","2018-05-27 11:34:31","0","Show"),
("7819011","872","872","32252198","1305","17042702221","17042005381","????","Received","","","N","2018-05-27 11:35:25","0","Show"),
("7819012","872","872","32252198","1305","17042005381","17042702221","Please reply \"bye\" to unsubscribe , \"ok\" to resubscribe and \"yes\" to confirm","Sent","","","N","2018-05-27 11:35:25","0","Show"),
("7819015","872","872","32252198","1305","17042702221","17042005381","yes","Received","","","N","2018-05-27 11:37:16","0","Show"),
("7819016","872","872","32252198","1305","17042005381","17042702221","Thank you for joining. Your special gift will arrive in your email soon. By the way to leave at any time reply \"BYE\".","Sent","","","N","2018-05-27 11:37:16","0","Show");



