INSERT INTO hp_group (`groupId`,`memberId`,`sub_memberId`,`group_name`,`group_type`,`custom_fields`,`total_lead`,`total_email`,`total_phone`,`total_mobile`,`total_unsubscribed`,`permissions`,`integration_code`,`default_status`,`oldId`,`notification_status`,`notification_content`,`last_dnc_lookup`,`last_national_dnc_lookup`,`dated`,`tagId`) VALUES
("549285","2229","0","Customers","Group","","0","0","0","0","0","","","0","547680","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("549286","2229","0","Prospects","Group","","0","0","0","0","0","","","0","547681","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("549287","2229","0","Leads","Group","","0","0","0","0","0","","","0","547682","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("549291","2229","0","Inbound Phone Leads","Group","","26","7","19","26","0","","","0","548003","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("549292","2229","0","Play by SMS","Group","","1","0","1","1","0","","","0","548004","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("549294","2229","0","Play by QR Code","Group","","1","0","1","1","0","","","0","548009","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-03-22 06:58:11","0"),
("557404","2229","0","Text Message Invitations List 4","Group","","4020","55","0","4020","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-07-08 08:07:43","0"),
("558151","2229","0","Text Message Invitations List 1","Group","","3999","3999","0","3998","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-07-14 13:07:37","0"),
("558152","2229","0","Text Message Invitations List 2","Group","","4800","4273","5","4800","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-07-14 13:07:58","0"),
("558153","2229","0","Text Message Invitations List 3","Group","","3798","519","11","3798","465","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-07-14 13:07:14","0"),
("564146","2229","0","Nouvelle liste 2 TEMPORAIRE","Group","","3487","3483","0","3487","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-08-26 12:08:08","0"),
("569859","2229","0","Text Messages invitations","Group","","3","0","2","3","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2016-11-11 10:11:49","0"),
("585862","2229","0","Summer 2017 Complete SMS list","Group","","4671","778","23","4656","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-07-28 09:07:20","0"),
("586261","2229","0","Race To The Finish","Group","","27","27","27","27","0","","13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-08-08 13:08:40","0"),
("588575","2229","0","AutoCanada Test","Group","","1","1","1","1","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-09-27 14:09:48","0"),
("588778","2229","0","Winter Tires","Group","","255","255","255","255","0","","13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-10-03 05:10:43","0"),
("588838","2229","0","Winter Tires SMS","Group","","5244","560","66","5243","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-10-04 06:10:06","0"),
("593979","2229","0","Boxing Week 2017","Group","","3","3","3","3","0","","13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-12-13 05:12:33","0"),
("594055","2229","0","SMS Boxing Week 1","Group","","646","68","7","646","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-12-14 06:12:20","0"),
("594056","2229","0","SMS Boxing Week 2","Group","","647","64","20","647","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-12-14 06:12:33","0"),
("594057","2229","0","SMS Boxing Week 3","Group","","646","99","17","646","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-12-14 06:12:43","0"),
("594058","2229","0","SMS Boxing Week 4","Group","","746","68","31","746","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2017-12-14 06:12:55","0"),
("600590","2229","0","Fresh Start Upgrade","Group","","0","0","0","0","0","","13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-01-24 06:01:30","0"),
("600691","2229","0","FCA January 2018 Manifest","Group","","0","0","0","0","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-01-25 11:01:08","0"),
("602212","2229","0","Great Adventure Upgrade","Group","","0","0","0","0","0","","13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-02-14 11:02:42","0"),
("602426","2229","0","Great Adventure SMS 1","Group","","498","41","17","498","36","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-02-16 11:02:07","0"),
("602427","2229","0","Great Adventure SMS 2","Group","","499","60","18","499","45","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-02-16 11:02:44","0"),
("602428","2229","0","Great Adventure SMS 3","Group","","499","47","12","499","46","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-02-16 11:02:01","0"),
("602429","2229","0","Great Adventure SMS 4","Group","","464","45","14","464","46","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-02-16 11:02:14","0"),
("604697","2229","0","Jeep No Limits Month of the RAM","Group","","0","0","0","0","0","","10,13","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-03-09 06:03:57","0"),
("604722","2229","0","9-Year-Old Boy SMS","Group","","1417","110","61","1417","36","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-03-09 13:03:54","0"),
("605496","2229","0","Maple Ridge Chrysler 699 SMS List March 2018","Group","","101","10","8","101","2","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-03-14 12:03:15","0"),
("606665","2229","0","Maple Ridge Chrysler Lease/Finance/Warranty SMS Lists March 2018","Group","","0","0","0","0","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-03-21 14:03:51","0"),
("607936","2229","0","Maple Ridge Stop, Drop, and Roll SMS List April 2018","Group","","479","56","17","479","0","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-04-04 09:04:31","0"),
("610381","2229","0","April 2018 Month End Push","Group","","4379","360","114","4374","243","","","0","0","N","","0000-00-00 00:00:00","0000-00-00 00:00:00","2018-04-26 15:04:28","0");



