INSERT INTO `customer` (email, `id`, customer_group_id, default_payment_method_id, language_id, default_billing_address_id, default_shipping_address_id, customer_number, first_name, last_name, active, guest, order_count, created_at, sales_channel_id, salutation_id, password) VALUES
('shopware@example.com', 0xCFBD5018D38D41D8ADCA10D94FC8BD99, (SELECT id from customer_group where display_gross = 1 ORDER BY id DESC LIMIT 1), (SELECT id from payment_method LIMIT 1), (SELECT id FROM language WHERE name = 'Deutsch'), 0x00BCD5B03167423699473BF08FFAE100, 0x00BCD5B03167423699473BF08FFAE101, '2342', 'Max', 'Mustermann', 1, 0, 0, NOW(), (SELECT sc.id FROM sales_channel sc INNER JOIN sales_channel_translation sct ON sc.id = sct.sales_channel_id WHERE sct.name = 'Storefront'), (select id from salutation where salutation_key = 'mr'), '$2y$10$18yNn.r/GWMkXXPQUFQWSuA49WitfuW4ckdrD4kKLMpjmPDiTSG/6')
;

INSERT INTO b2b_customer_data (customer_id, is_debtor, is_sales_representative, created_at) VALUES
(0xCFBD5018D38D41D8ADCA10D94FC8BD99, 1, 0, NOW())
;

INSERT INTO `customer_address` (id, customer_id, company, department, title, first_name, last_name, street, zipcode, city, phone_number, country_id, country_state_id, salutation_id, additional_address_line1, additional_address_line2, custom_fields, created_at, updated_at) VALUES
(0x00BCD5B03167423699473BF08FFAE100, 0xCFBD5018D38D41D8ADCA10D94FC8BD99, 'shopware AG', 'Purchasing', null, 'Max', 'Mustermann', 'Musterstr. 1', '55555', 'Musterhausen', '05555 / 555555', (select id from country where iso3 = 'DEU'), null, (select id from salutation where salutation_key = 'mr'), null, null, null, NOW(), null)
,(0x00BCD5B03167423699473BF08FFAE101, 0xCFBD5018D38D41D8ADCA10D94FC8BD99, 'shopware AG', 'Purchasing', null, 'Max','Kundengruppe-Netto', 'Musterstr. 2', '55555','Musterstadt', '05555 / 555555', (select id from country where iso3 = 'DEU'), null, (select id from salutation where salutation_key = 'mr'), null, null, null, NOW(), null)
;

INSERT INTO b2b_store_front_auth (`id`, `context_owner_id`, `provider_key`, `provider_context`) VALUES
(201, 201, 'Shopware\\B2B\\Debtor\\Framework\\DebtorRepositoryInterface', LOWER(HEX(0xCFBD5018D38D41D8ADCA10D94FC8BD99)))
;

INSERT INTO b2b_customer_address_data (address_id, b2b_type, created_at) VALUES
(0x00BCD5B03167423699473BF08FFAE100,'billing', NOW())
,(0x00BCD5B03167423699473BF08FFAE101, 'shipping', NOW())
;

INSERT INTO b2b_role (id, `left`, `right`, `level`, `context_owner_id`, `name`) VALUES
(2012, 1, 80, 0, 201, 'shopware')
,(2013, 3, 18, 2, 201, 'Research & Development')
,(2014, 19, 22, 2, 201, 'Finance & Human Resource')
,(2015, 23, 40, 2, 201, 'Marketing')
,(2016, 41, 50, 2, 201, 'Sales & Relations')
,(2017, 4, 13, 3, 201, 'Product Development')
,(2018, 14, 15, 3, 201, 'Technical Engineering')
,(2019, 16, 17, 3, 201, 'IT-Administration')
,(2020, 5, 6, 4, 201, 'Core & Plugins')
,(2021, 7, 8, 4, 201, 'Enterprise')
,(2022, 9, 10, 4, 201, 'Connect')
,(2023, 11, 12, 4, 201, 'SBP')
,(2024, 20, 21, 3, 201, 'Financial Services')
,(2025, 24, 31, 3, 201, 'Marketing')
,(2026, 32, 39, 3, 201, 'Design')
,(2027, 25, 26, 4, 201, 'Marketing')
,(2028, 27, 28, 4, 201, 'Public Relations')
,(2029, 29, 30, 4, 201, 'Events')
,(2030, 33, 34, 4, 201, 'Corporate Design')
,(2031, 35, 36, 4, 201, 'Product Design')
,(2032, 37, 38, 4, 201, 'Store')
,(2033, 42, 43, 3, 201, 'Enterprise Consulting')
,(2034, 44, 45, 3, 201, 'National Sales')
,(2035, 46, 47, 3, 201, 'International Sales')
,(2036, 48, 49, 3, 201, 'International Sales UK')
,(2037, 2, 51, 1, 201, 'business units')
,(2038, 52, 73, 1, 201, 'Groups')
,(2039, 74, 79, 1, 201, 'Sites')
,(2040, 75, 76, 2, 201, 'Germany')
,(2041, 77, 78, 2, 201, 'UK')
,(2066, 53, 54, 2, 201, 'All listing routes')
,(2070, 55, 56, 2, 201, 'All listings and detail routes')
,(2072, 59, 60, 2, 201, 'All listings, details and updates')
,(2073, 57, 58, 2, 201, 'All routes')
,(20147, 61, 62, 2, 201, 'All listings, details, updates and assigns')
,(20150, 63, 64, 2, 201, 'All Shipping Addresses')
,(20152, 65, 66, 2, 201, 'All Billing Addresses')
,(20157, 67, 68, 2, 201, '1/2 Billing Addresses')
,(20158, 69, 70, 2, 201, '10.000 â‚¬ each month')
,(20162, 71, 72, 2, 201, 'Most Budgets')
;

INSERT INTO b2b_debtor_contact (id, password,encoder,email,active,`language`,title,salutation,firstname,lastname,department,context_owner_id) VALUES
(10001, 'a256a310bc1e5db755fd392c524028a8','md5','augusta12@macejkovic.info',1,(select id from language limit 1),NULL,'mr','Icie','Dietrich','Design',201),
(10002, 'a256a310bc1e5db755fd392c524028a8','md5','muller.mac@hotmail.com',1,(select id from language limit 1),NULL,'mr','Una','Friesen','Marketing',201),
(10003, 'a256a310bc1e5db755fd392c524028a8','md5','greenholt.rashawn@blick.com',0,(select id from language limit 1),NULL,'mr','Tyree','Ernser','Research & Development',201),
(10004, 'a256a310bc1e5db755fd392c524028a8','md5','otha.gerhold@carter.com',1,(select id from language limit 1),NULL,'mr','Dave','DuBuque','Research & Development',201),
(10005, 'a256a310bc1e5db755fd392c524028a8','md5','feest.jordan@padberg.net',0,(select id from language limit 1),NULL,'mr','Shyanne','Mraz','Sales & Relations',201),
(10006, 'a256a310bc1e5db755fd392c524028a8','md5','david51@yahoo.com',1,(select id from language limit 1),NULL,'mr','Tamara','Kuphal','Sales & Relations',201),
(10007, 'a256a310bc1e5db755fd392c524028a8','md5','green.tillman@gmail.com',1,(select id from language limit 1),NULL,'mr','Omari','Dach','Research & Development',201),
(10008, 'a256a310bc1e5db755fd392c524028a8','md5','fhagenes@pollich.com',1,(select id from language limit 1),NULL,'mr','Elliot','Herzog','Sales & Relations',201),
(10009, 'a256a310bc1e5db755fd392c524028a8','md5','eriberto.mosciski@orn.biz',1,(select id from language limit 1),NULL,'mr','Emerson','Lynch','Research & Development',201),
(10010, 'a256a310bc1e5db755fd392c524028a8','md5','jess.marks@bailey.info',1,(select id from language limit 1),NULL,'mr','Ivy','Rice','Finance & Human Resources',201),
(10011, 'a256a310bc1e5db755fd392c524028a8','md5','kyla03@jacobi.com',1,(select id from language limit 1),NULL,'mr','Vivien','Nolan','Sales & Relations',201),
(10012, 'a256a310bc1e5db755fd392c524028a8','md5','uherman@schaden.org',1,(select id from language limit 1),NULL,'mr','Montana','Funk','Design',201),
(10013, 'a256a310bc1e5db755fd392c524028a8','md5','romaguera.jacey@hotmail.com',1,(select id from language limit 1),NULL,'mr','Hailie','Kutch','Research & Development',201),
(10014, 'a256a310bc1e5db755fd392c524028a8','md5','swift.lilly@hotmail.com',0,(select id from language limit 1),NULL,'mr','Judy','Shanahan','Research & Development',201),
(10015, 'a256a310bc1e5db755fd392c524028a8','md5','koss.jose@bailey.com',1,(select id from language limit 1),NULL,'mr','Kara','Roob','Marketing',201),
(10016, 'a256a310bc1e5db755fd392c524028a8','md5','barrows.emil@hotmail.com',1,(select id from language limit 1),NULL,'mr','Yvette','Emmerich','Finance & Human Resources',201),
(10017, 'a256a310bc1e5db755fd392c524028a8','md5','iratke@wintheiser.com',1,(select id from language limit 1),NULL,'mr','Dina','Bernhard','Research & Development',201),
(10018, 'a256a310bc1e5db755fd392c524028a8','md5','cankunding@gmail.com',1,(select id from language limit 1),NULL,'mr','Bert','Keeling','Store',201),
(10019, 'a256a310bc1e5db755fd392c524028a8','md5','maximus.haag@bashirian.net',1,(select id from language limit 1),NULL,'mr','Jalyn','Hane','Research & Development',201),
(10020, 'a256a310bc1e5db755fd392c524028a8','md5','elody.streich@beahan.com',1,(select id from language limit 1),NULL,'mr','Nickolas','Heidenreich','Research & Development',201),
(10021, 'a256a310bc1e5db755fd392c524028a8','md5','bechtelar.patricia@hilpert.org',1,(select id from language limit 1),NULL,'mr','Abigayle','McCullough','Research & Development',201),
(10022, 'a256a310bc1e5db755fd392c524028a8','md5','rodrigo.mraz@harvey.net',1,(select id from language limit 1),NULL,'mr','Richie','Pagac','Sales & Relations',201),
(10023, 'a256a310bc1e5db755fd392c524028a8','md5','sidney.heller@gmail.com',0,(select id from language limit 1),NULL,'mr','Jarrett','Wiza','Research & Development',201),
(10024, 'a256a310bc1e5db755fd392c524028a8','md5','hailie32@pagac.com',1,(select id from language limit 1),NULL,'mr','Elisabeth','Cartwright','Research & Development',201),
(10025, 'a256a310bc1e5db755fd392c524028a8','md5','kunze.marley@hotmail.com',1,(select id from language limit 1),NULL,'mr','Lavern','Will','Research & Development',201),
(10026, 'a256a310bc1e5db755fd392c524028a8','md5','valerie43@nitzsche.info',0,(select id from language limit 1),NULL,'mr','Natasha','Paucek','Sales & Relations',201),
(10027, 'a256a310bc1e5db755fd392c524028a8','md5','carlee.farrell@nienow.com',0,(select id from language limit 1),NULL,'mr','Jany','Gorczany','Research & Development',201),
(10028, 'a256a310bc1e5db755fd392c524028a8','md5','afton.harber@gmail.com',1,(select id from language limit 1),NULL,'mr','Cheyenne','Satterfield','Sales & Relations',201),
(10029, 'a256a310bc1e5db755fd392c524028a8','md5','ivy89@yahoo.com',1,(select id from language limit 1),NULL,'mr','Humberto','Murazik','Design',201),
(10030, 'a256a310bc1e5db755fd392c524028a8','md5','wisozk.reanna@boehm.com',1,(select id from language limit 1),NULL,'mr','Wilburn','Heller','Research & Development',201),
(10031, 'a256a310bc1e5db755fd392c524028a8','md5','tad77@hotmail.com',1,(select id from language limit 1),NULL,'mr','Isabell','Aufderhar','Research & Development',201),
(10032, 'a256a310bc1e5db755fd392c524028a8','md5','charity.skiles@yahoo.com',1,(select id from language limit 1),NULL,'mr','Nels','Bechtelar','Design',201),
(10033, 'a256a310bc1e5db755fd392c524028a8','md5','christiana.morissette@walker.net',0,(select id from language limit 1),NULL,'mr','Lurline','Wunsch','Design',201),
(10034, 'a256a310bc1e5db755fd392c524028a8','md5','cydney46@hotmail.com',0,(select id from language limit 1),NULL,'mr','Marley','Johnston','Research & Development',201),
(10035, 'a256a310bc1e5db755fd392c524028a8','md5','cummerata.faye@yahoo.com',0,(select id from language limit 1),NULL,'mr','Merl','Stroman','Technical Engineering',201),
(10036, 'a256a310bc1e5db755fd392c524028a8','md5','pkunze@glover.info',1,(select id from language limit 1),NULL,'mr','Fabiola','Mohr','Research & Development',201),
(10037, 'a256a310bc1e5db755fd392c524028a8','md5','percy.stiedemann@bauch.org',0,(select id from language limit 1),NULL,'mr','Nichole','Lind','Research & Development',201),
(10038, 'a256a310bc1e5db755fd392c524028a8','md5','kunze.asa@gmail.com',1,(select id from language limit 1),NULL,'mr','Lacey','Green','Sales & Relations',201),
(10039, 'a256a310bc1e5db755fd392c524028a8','md5','drolfson@towne.com',0,(select id from language limit 1),NULL,'mr','Jaylin','Bashirian','Sales & Relations',201),
(10040, 'a256a310bc1e5db755fd392c524028a8','md5','maya.jenkins@schmitt.com',1,(select id from language limit 1),NULL,'mr','Lelah','Rowe','Finance & Human Resources',201),
(10041, 'a256a310bc1e5db755fd392c524028a8','md5','zharvey@yahoo.com',1,(select id from language limit 1),NULL,'mr','Augustine','Bergnaum','Finance & Human Resources',201),
(10042, 'a256a310bc1e5db755fd392c524028a8','md5','cheller@hotmail.com',0,(select id from language limit 1),NULL,'mr','Jonatan','Metz','Finance & Human Resources',201),
(10043, 'a256a310bc1e5db755fd392c524028a8','md5','lschmidt@hotmail.com',1,(select id from language limit 1),NULL,'mr','Doug','Powlowski','Sales & Relations',201),
(10044, 'a256a310bc1e5db755fd392c524028a8','md5','uriah.cremin@hotmail.com',1,(select id from language limit 1),NULL,'mr','Murl','Vandervort','Design',201),
(10045, 'a256a310bc1e5db755fd392c524028a8','md5','gaylord32@towne.net',0,(select id from language limit 1),NULL,'mr','Esta','Volkman','Sales & Relations',201),
(10046, 'a256a310bc1e5db755fd392c524028a8','md5','powlowski.rhiannon@herman.net',1,(select id from language limit 1),NULL,'mr','Marlen','Mayer','Research & Development',201),
(10047, 'a256a310bc1e5db755fd392c524028a8','md5','sandy05@yahoo.com',1,(select id from language limit 1),NULL,'mr','Sven','Homenick','Design',201),
(10048, 'a256a310bc1e5db755fd392c524028a8','md5','jillian.wintheiser@hotmail.com',1,(select id from language limit 1),NULL,'mr','Elaina','Kohler','Research & Development',201),
(10049, 'a256a310bc1e5db755fd392c524028a8','md5','seth.crooks@prosacco.net',0,(select id from language limit 1),NULL,'mr','Rachael','Reilly','Sales & Relations',201),
(10050, 'a256a310bc1e5db755fd392c524028a8','md5','tyost@gmail.com',1,(select id from language limit 1),NULL,'mr','Hester','Schaden','Research & Development',201),
(10051, 'a256a310bc1e5db755fd392c524028a8','md5','doris04@wuckert.biz',1,(select id from language limit 1),NULL,'mr','Darryl','Kris','Research & Development',201),
(10052, 'a256a310bc1e5db755fd392c524028a8','md5','lsawayn@jones.com',1,(select id from language limit 1),NULL,'mr','Jaquelin','Rutherford','Research & Development',201),
(10053, 'a256a310bc1e5db755fd392c524028a8','md5','brown35@hotmail.com',1,(select id from language limit 1),NULL,'mr','Claire','Eichmann','Research & Development',201),
(10054, 'a256a310bc1e5db755fd392c524028a8','md5','wreichert@murazik.info',0,(select id from language limit 1),NULL,'mr','Jairo','Feest','Marketing',201),
(10055, 'a256a310bc1e5db755fd392c524028a8','md5','laura.armstrong@donnelly.com',0,(select id from language limit 1),NULL,'mr','Josephine','Rippin','Research & Development',201),
(10056, 'a256a310bc1e5db755fd392c524028a8','md5','geovany25@hotmail.com',1,(select id from language limit 1),NULL,'mr','Gerson','Towne','Sales & Relations',201),
(10057, 'a256a310bc1e5db755fd392c524028a8','md5','ezra24@gmail.com',0,(select id from language limit 1),NULL,'mr','Trace','Watsica','Technical Engineering',201),
(10058, 'a256a310bc1e5db755fd392c524028a8','md5','hkoepp@gmail.com',1,(select id from language limit 1),NULL,'mr','Marty','Predovic','Marketing',201),
(10059, 'a256a310bc1e5db755fd392c524028a8','md5','albin53@kemmer.com',1,(select id from language limit 1),NULL,'mr','Regan','Abernathy','Research & Development',201),
(10060, 'a256a310bc1e5db755fd392c524028a8','md5','gavin.considine@gmail.com',1,(select id from language limit 1),NULL,'mr','Kiel','Collins','Research & Development',201),
(10061, 'a256a310bc1e5db755fd392c524028a8','md5','gladyce97@satterfield.com',1,(select id from language limit 1),NULL,'mr','Cooper','Flatley','Design',201),
(10062, 'a256a310bc1e5db755fd392c524028a8','md5','delilah54@yahoo.com',1,(select id from language limit 1),NULL,'mr','Zoe','Jast','Sales & Relations',201),
(10063, 'a256a310bc1e5db755fd392c524028a8','md5','dameon.mann@lesch.com',1,(select id from language limit 1),NULL,'mr','Aaliyah','Feest','Finance & Human Resources',201),
(10064, 'a256a310bc1e5db755fd392c524028a8','md5','smcclure@mayer.info',1,(select id from language limit 1),NULL,'mr','Arnold','Roberts','Sales & Relations',201),
(10065, 'a256a310bc1e5db755fd392c524028a8','md5','rashad.dubuque@keeling.biz',1,(select id from language limit 1),NULL,'mr','Janae','Orn','Research & Development',201),
(10066, 'a256a310bc1e5db755fd392c524028a8','md5','nayeli.hartmann@gmail.com',0,(select id from language limit 1),NULL,'mr','Anahi','Hayes','Sales & Relations',201),
(10067, 'a256a310bc1e5db755fd392c524028a8','md5','muller.lisa@hoppe.net',1,(select id from language limit 1),NULL,'mr','Lamont','Wyman','Research & Development',201),
(10068, 'a256a310bc1e5db755fd392c524028a8','md5','upton.alene@hotmail.com',1,(select id from language limit 1),NULL,'mr','Gregoria','Christiansen','Sales & Relations',201),
(10069, 'a256a310bc1e5db755fd392c524028a8','md5','ehessel@simonis.com',0,(select id from language limit 1),NULL,'mr','Jessica','Koss','Marketing',201),
(10070, 'a256a310bc1e5db755fd392c524028a8','md5','bartholome79@toy.com',1,(select id from language limit 1),NULL,'mr','Cristal','Cremin','Sales & Relations',201),
(10071, 'a256a310bc1e5db755fd392c524028a8','md5','mark02@yahoo.com',1,(select id from language limit 1),NULL,'mr','Wellington','Haag','Research & Development',201),
(10072, 'a256a310bc1e5db755fd392c524028a8','md5','simone66@beer.com',1,(select id from language limit 1),NULL,'mr','Dangelo','Roberts','Research & Development',201),
(10073, 'a256a310bc1e5db755fd392c524028a8','md5','gankunding@hotmail.com',1,(select id from language limit 1),NULL,'mr','Consuelo','Kuhic','Marketing',201),
(10074, 'a256a310bc1e5db755fd392c524028a8','md5','ischroeder@yahoo.com',1,(select id from language limit 1),NULL,'mr','Violet','Kunze','Design',201),
(10075, 'a256a310bc1e5db755fd392c524028a8','md5','olson.eladio@volkman.com',1,(select id from language limit 1),NULL,'mr','Garry','Rutherford','Research & Development',201),
(10076, 'a256a310bc1e5db755fd392c524028a8','md5','ydickens@yahoo.com',1,(select id from language limit 1),NULL,'mr','Dante','Rowe','Design',201),
(10077, 'a256a310bc1e5db755fd392c524028a8','md5','duncan.toy@hotmail.com',1,(select id from language limit 1),NULL,'mr','Tito','Fadel','Finance & Human Resources',201),
(10078, 'a256a310bc1e5db755fd392c524028a8','md5','layla.hirthe@kling.com',1,(select id from language limit 1),NULL,'mr','Blanca','Kshlerin','Marketing',201),
(10079, 'a256a310bc1e5db755fd392c524028a8','md5','ondricka.dino@dare.biz',1,(select id from language limit 1),NULL,'mr','Marvin','Murphy','Finance & Human Resources',201),
(10080, 'a256a310bc1e5db755fd392c524028a8','md5','hudson.darius@gmail.com',0,(select id from language limit 1),NULL,'mr','Michaela','Gutmann','Sales & Relations',201),
(10081, 'a256a310bc1e5db755fd392c524028a8','md5','bernice.king@prohaska.biz',1,(select id from language limit 1),NULL,'mr','Annie','Bernier','Research & Development',201),
(10082, 'a256a310bc1e5db755fd392c524028a8','md5','rowland.tremblay@hotmail.com',1,(select id from language limit 1),NULL,'mr','Jillian','Zemlak','Sales & Relations',201),
(10083, 'a256a310bc1e5db755fd392c524028a8','md5','hamill.baby@hotmail.com',1,(select id from language limit 1),NULL,'mr','Phoebe','Swaniawski','Sales & Relations',201),
(10084, 'a256a310bc1e5db755fd392c524028a8','md5','earl91@hotmail.com',1,(select id from language limit 1),NULL,'mr','Lisa','Gottlieb','Sales & Relations',201),
(10085, 'a256a310bc1e5db755fd392c524028a8','md5','evalyn42@yahoo.com',1,(select id from language limit 1),NULL,'mr','Alene','Fadel','Research & Development',201),
(10086, 'a256a310bc1e5db755fd392c524028a8','md5','fay.daniela@hotmail.com',1,(select id from language limit 1),NULL,'mr','Fausto','Barton','Finance & Human Resources',201),
(10087, 'a256a310bc1e5db755fd392c524028a8','md5','mann.richie@mertz.com',1,(select id from language limit 1),NULL,'mr','Sallie','Ritchie','Research & Development',201),
(10088, 'a256a310bc1e5db755fd392c524028a8','md5','friesen.scotty@hotmail.com',1,(select id from language limit 1),NULL,'mr','Kade','Johnston','Research & Development',201),
(10089, 'a256a310bc1e5db755fd392c524028a8','md5','alva22@will.info',1,(select id from language limit 1),NULL,'mr','Helene','Mosciski','Design',201),
(10090, 'a256a310bc1e5db755fd392c524028a8','md5','zoila.hessel@hotmail.com',1,(select id from language limit 1),NULL,'mr','Elisha','Champlin','Marketing',201),
(10091, 'a256a310bc1e5db755fd392c524028a8','md5','stokes.vincenza@gmail.com',1,(select id from language limit 1),NULL,'mr','Tomas','Daniel','Research & Development',201),
(10092, 'a256a310bc1e5db755fd392c524028a8','md5','quincy10@hotmail.com',0,(select id from language limit 1),NULL,'mr','Maida','Wiza','Research & Development',201),
(10093, 'a256a310bc1e5db755fd392c524028a8','md5','gregoria.hermiston@hotmail.com',1,(select id from language limit 1),NULL,'mr','Magnus','Brakus','Sales & Relations',201),
(10094, 'a256a310bc1e5db755fd392c524028a8','md5','ellie40@gmail.com',1,(select id from language limit 1),NULL,'mr','Hailee','Pagac','Research & Development',201),
(10095, 'a256a310bc1e5db755fd392c524028a8','md5','kutch.kurtis@hotmail.com',1,(select id from language limit 1),NULL,'mr','Ova','Kautzer','Research & Development',201),
(10096, 'a256a310bc1e5db755fd392c524028a8','md5','giovanna.reichert@yahoo.com',0,(select id from language limit 1),NULL,'mr','Jefferey','Langosh','Sales & Relations',201),
(10097, 'a256a310bc1e5db755fd392c524028a8','md5','mcclure.nathanael@gmail.com',1,(select id from language limit 1),NULL,'mr','Silas','Veum','Research & Development',201),
(10098, 'a256a310bc1e5db755fd392c524028a8','md5','ullrich.mckenna@yahoo.com',1,(select id from language limit 1),NULL,'mr','Lola','Torphy','Research & Development',201),
(10099, 'a256a310bc1e5db755fd392c524028a8','md5','juliana07@harris.com',1,(select id from language limit 1),NULL,'mr','Elouise','Metz','Sales & Relations',201),
(10100, 'a256a310bc1e5db755fd392c524028a8','md5','wmclaughlin@gmail.com',1,(select id from language limit 1),NULL,'mr','Elva','Schimmel','Finance & Human Resources',201),
(10101, 'a256a310bc1e5db755fd392c524028a8','md5','stehr.hugh@schmeler.com',0,(select id from language limit 1),NULL,'mr','Madie','Ritchie','Design',201),
(10102, 'a256a310bc1e5db755fd392c524028a8','md5','mueller.kaley@gmail.com',1,(select id from language limit 1),NULL,'mr','Aubree','Streich','Sales & Relations',201),
(10103, 'a256a310bc1e5db755fd392c524028a8','md5','joanne82@beahan.com',0,(select id from language limit 1),NULL,'mr','Lonzo','Pollich','Sales & Relations',201),
(10104, 'a256a310bc1e5db755fd392c524028a8','md5','kgoodwin@blanda.org',1,(select id from language limit 1),NULL,'mr','Leonor','Fritsch','Research & Development',201),
(10105, 'a256a310bc1e5db755fd392c524028a8','md5','briana.bins@mcdermott.com',1,(select id from language limit 1),NULL,'mr','Jed','Stamm','Sales & Relations',201),
(10106, 'a256a310bc1e5db755fd392c524028a8','md5','linnea60@schumm.com',1,(select id from language limit 1),NULL,'mr','Braden','Ernser','Sales & Relations',201),
(10107, 'a256a310bc1e5db755fd392c524028a8','md5','wuckert.virginia@gmail.com',1,(select id from language limit 1),NULL,'mr','Georgiana','Vandervort','Finance & Human Resources',201),
(10108, 'a256a310bc1e5db755fd392c524028a8','md5','isobel52@hegmann.com',1,(select id from language limit 1),NULL,'mr','Madisyn','Waelchi','Finance & Human Resources',201),
(10109, 'a256a310bc1e5db755fd392c524028a8','md5','vwiza@bins.biz',1,(select id from language limit 1),NULL,'mr','Rosetta','Kub','Sales & Relations',201),
(10110, 'a256a310bc1e5db755fd392c524028a8','md5','tatum.ortiz@balistreri.biz',1,(select id from language limit 1),NULL,'mr','Tom','Abshire','Research & Development',201),
(10111, 'a256a310bc1e5db755fd392c524028a8','md5','adaline.fadel@gmail.com',1,(select id from language limit 1),NULL,'mr','Lora','Lueilwitz','Research & Development',201),
(10112, 'a256a310bc1e5db755fd392c524028a8','md5','adah.reilly@ortiz.org',1,(select id from language limit 1),NULL,'mr','Emma','Schowalter','Research & Development',201),
(10113, 'a256a310bc1e5db755fd392c524028a8','md5','colton38@wolff.com',1,(select id from language limit 1),NULL,'mr','Jordan','Waelchi','Sales & Relations',201),
(10114, 'a256a310bc1e5db755fd392c524028a8','md5','alind@robel.com',1,(select id from language limit 1),NULL,'mr','Eloy','Baumbach','Finance & Human Resources',201),
(10115, 'a256a310bc1e5db755fd392c524028a8','md5','fbailey@ruecker.com',1,(select id from language limit 1),NULL,'mr','Gladys','Lueilwitz','Finance & Human Resources',201),
(10116, 'a256a310bc1e5db755fd392c524028a8','md5','fcronin@king.com',0,(select id from language limit 1),NULL,'mr','Anibal','Tromp','Research & Development',201),
(10117, 'a256a310bc1e5db755fd392c524028a8','md5','lambert92@gmail.com',1,(select id from language limit 1),NULL,'mr','Dedric','Lindgren','Research & Development',201),
(10118, 'a256a310bc1e5db755fd392c524028a8','md5','walsh.aisha@hackett.net',1,(select id from language limit 1),NULL,'mr','Bridget','Torphy','Sales & Relations',201),
(10119, 'a256a310bc1e5db755fd392c524028a8','md5','nsauer@gmail.com',1,(select id from language limit 1),NULL,'mr','Destany','Larson','Marketing',201),
(10120, 'a256a310bc1e5db755fd392c524028a8','md5','rcrist@hotmail.com',1,(select id from language limit 1),NULL,'mr','Taryn','Torphy','Research & Development',201),
(10121, 'a256a310bc1e5db755fd392c524028a8','md5','helga.ebert@streich.com',1,(select id from language limit 1),NULL,'mr','Lolita','Brekke','Design',201),
(10122, 'a256a310bc1e5db755fd392c524028a8','md5','grover.lowe@yahoo.com',1,(select id from language limit 1),NULL,'mr','Rosie','Glover','Sales & Relations',201),
(10123, 'a256a310bc1e5db755fd392c524028a8','md5','lang.armand@bailey.com',0,(select id from language limit 1),NULL,'mr','Keagan','Blanda','Sales & Relations',201),
(10124, 'a256a310bc1e5db755fd392c524028a8','md5','baumbach.fausto@gmail.com',1,(select id from language limit 1),NULL,'mr','Wilfredo','Wiegand','Research & Development',201),
(10125, 'a256a310bc1e5db755fd392c524028a8','md5','mcdermott.elaina@wolff.biz',1,(select id from language limit 1),NULL,'mr','Danial','Davis','Research & Development',201),
(10126, 'a256a310bc1e5db755fd392c524028a8','md5','clyde55@hotmail.com',1,(select id from language limit 1),NULL,'mr','Santa','Turner','Research & Development',201),
(10127, 'a256a310bc1e5db755fd392c524028a8','md5','wehner.natalie@hotmail.com',1,(select id from language limit 1),NULL,'mr','Otto','Schuppe','Sales & Relations',201),
(10128, 'a256a310bc1e5db755fd392c524028a8','md5','hilpert.kristopher@yahoo.com',1,(select id from language limit 1),NULL,'mr','Katharina','Mertz','Research & Development',201),
(10129, 'a256a310bc1e5db755fd392c524028a8','md5','mcglynn.elyse@jacobs.com',1,(select id from language limit 1),NULL,'mr','Rhoda','Oberbrunner','Research & Development',201),
(10130, 'a256a310bc1e5db755fd392c524028a8','md5','jacinthe.bayer@hotmail.com',1,(select id from language limit 1),NULL,'mr','Vada','McLaughlin','Research & Development',201),
(10131, 'a256a310bc1e5db755fd392c524028a8','md5','dbernhard@dickinson.org',1,(select id from language limit 1),NULL,'mr','Mauricio','Bailey','Design',201),
(10132, 'a256a310bc1e5db755fd392c524028a8','md5','lpouros@gleichner.info',1,(select id from language limit 1),NULL,'mr','Ignatius','Padberg','Sales & Relations',201),
(10133, 'a256a310bc1e5db755fd392c524028a8','md5','marcel86@yahoo.com',1,(select id from language limit 1),NULL,'mr','Sienna','Schmeler','Research & Development',201),
(10134, 'a256a310bc1e5db755fd392c524028a8','md5','melyssa95@kuphal.net',1,(select id from language limit 1),NULL,'mr','Evans','Aufderhar','Sales & Relations',201),
(10135, 'a256a310bc1e5db755fd392c524028a8','md5','hoeger.winifred@king.biz',1,(select id from language limit 1),NULL,'mr','Raleigh','Ortiz','Research & Development',201),
(10136, 'a256a310bc1e5db755fd392c524028a8','md5','runte.lilian@jaskolski.net',1,(select id from language limit 1),NULL,'mr','Zita','Upton','Research & Development',201),
(10137, 'a256a310bc1e5db755fd392c524028a8','md5','sonya63@moen.org',1,(select id from language limit 1),NULL,'mr','Davin','Howe','Finance & Human Resources',201),
(10138, 'a256a310bc1e5db755fd392c524028a8','md5','ycummerata@gmail.com',1,(select id from language limit 1),NULL,'mr','Shaniya','Witting','Design',201),
(10139, 'a256a310bc1e5db755fd392c524028a8','md5','laury.cummerata@gmail.com',1,(select id from language limit 1),NULL,'mr','Clinton','Sawayn','Finance & Human Resources',201),
(10140, 'a256a310bc1e5db755fd392c524028a8','md5','louisa.schowalter@carter.com',1,(select id from language limit 1),NULL,'mr','Viola','Boehm','Research & Development',201),
(10141, 'a256a310bc1e5db755fd392c524028a8','md5','candace.hand@langosh.com',1,(select id from language limit 1),NULL,'mr','Pauline','Kerluke','Sales & Relations',201),
(10142, 'a256a310bc1e5db755fd392c524028a8','md5','mcglynn.raymond@yahoo.com',1,(select id from language limit 1),NULL,'mr','Electa','Schroeder','Research & Development',201),
(10143, 'a256a310bc1e5db755fd392c524028a8','md5','hickle.holly@jacobs.com',1,(select id from language limit 1),NULL,'mr','Loma','Luettgen','Research & Development',201),
(10144, 'a256a310bc1e5db755fd392c524028a8','md5','jones.carolina@hotmail.com',1,(select id from language limit 1),NULL,'mr','Abdiel','Dickens','Sales & Relations',201),
(10145, 'a256a310bc1e5db755fd392c524028a8','md5','mante.jazmyne@wisozk.info',1,(select id from language limit 1),NULL,'mr','Trycia','Dare','Marketing',201),
(10146, 'a256a310bc1e5db755fd392c524028a8','md5','elbert.rowe@yahoo.com',1,(select id from language limit 1),NULL,'mr','Dan','Hessel','Marketing',201),
(10147, 'a256a310bc1e5db755fd392c524028a8','md5','goyette.addison@hotmail.com',0,(select id from language limit 1),NULL,'mr','Jacky','Russel','Sales & Relations',201),
(10148, 'a256a310bc1e5db755fd392c524028a8','md5','joana53@zboncak.org',1,(select id from language limit 1),NULL,'mr','Jerrold','Roob','Research & Development',201),
(10149, 'a256a310bc1e5db755fd392c524028a8','md5','billy.olson@hotmail.com',1,(select id from language limit 1),NULL,'mr','Jensen','Schamberger','Vorstand',201),
(10150, 'a256a310bc1e5db755fd392c524028a8','md5','mallie78@gmail.com',1,(select id from language limit 1),NULL,'mr','Olen','Schumm','Research & Development',201),
(10151, 'a256a310bc1e5db755fd392c524028a8','md5','rebeka.kreiger@gmail.com',1,(select id from language limit 1),NULL,'mr','Candido','Denesik','Research & Development',201),
(10152, 'a256a310bc1e5db755fd392c524028a8','md5','berry.kshlerin@hotmail.com',1,(select id from language limit 1),NULL,'mr','Jayden','Russel','Design',201),
(10153, 'a256a310bc1e5db755fd392c524028a8','md5','braun.terrance@cartwright.com',1,(select id from language limit 1),NULL,'mr','Otho','Schaden','Design',201),
(10154, 'a256a310bc1e5db755fd392c524028a8','md5','gregory.kovacek@hotmail.com',0,(select id from language limit 1),NULL,'mr','Otto','Douglas','Sales & Relations',201),
(10155, 'a256a310bc1e5db755fd392c524028a8','md5','kautzer.alphonso@gmail.com',0,(select id from language limit 1),NULL,'mr','Donnell','Beahan','Research & Development',201),
(10156, 'a256a310bc1e5db755fd392c524028a8','md5','rowe.derrick@strosin.com',1,(select id from language limit 1),NULL,'mr','Mollie','Macejkovic','Research & Development',201),
(10157, 'a256a310bc1e5db755fd392c524028a8','md5','jamaal.ankunding@gmail.com',1,(select id from language limit 1),NULL,'mr','Frederique','Goodwin','Marketing',201),
(10158, 'a256a310bc1e5db755fd392c524028a8','md5','kraig15@stokes.org',1,(select id from language limit 1),NULL,'mr','Grayce','Boyle','Marketing',201),
(10159, 'a256a310bc1e5db755fd392c524028a8','md5','price.ella@gmail.com',1,(select id from language limit 1),NULL,'mr','Tyrese','Rau','Sales & Relations',201),
(10160, 'a256a310bc1e5db755fd392c524028a8','md5','spfeffer@mayer.com',1,(select id from language limit 1),NULL,'mr','Matilde','Gleason','Research & Development',201),
(10161, 'a256a310bc1e5db755fd392c524028a8','md5','una82@reilly.com',1,(select id from language limit 1),NULL,'mr','Alivia','Lesch','Vorstand',201),
(10162, 'a256a310bc1e5db755fd392c524028a8','md5','nick.predovic@bins.biz',1,(select id from language limit 1),NULL,'mr','Mara','Parisian','Vorstand',201),
(10163, 'a256a310bc1e5db755fd392c524028a8','md5','ofelia.aufderhar@von.com',1,(select id from language limit 1),NULL,'mr','Alysson','Heathcote','Research & Development',201),
(10164, 'a256a310bc1e5db755fd392c524028a8','md5','bernadine.dickens@hoeger.biz',1,(select id from language limit 1),NULL,'mr','Maximillian','Bashirian','Sales & Relations',201),
(10165, 'a256a310bc1e5db755fd392c524028a8','md5','qcole@yahoo.com',1,(select id from language limit 1),NULL,'mr','Sunny','Reynolds','Sales & Relations',201),
(10166, 'a256a310bc1e5db755fd392c524028a8','md5','ookon@emmerich.com',1,(select id from language limit 1),NULL,'mr','Shea','Welch','Research & Development',201),
(10167, 'a256a310bc1e5db755fd392c524028a8','md5','hagenes.cortney@kreiger.info',0,(select id from language limit 1),NULL,'mr','Alf','Stark','Technical Engineering',201),
(10168, 'a256a310bc1e5db755fd392c524028a8','md5','jonathon.ebert@hamill.com',1,(select id from language limit 1),NULL,'mr','Asha','Walter','Research & Development',201),
(10169, 'a256a310bc1e5db755fd392c524028a8','md5','mona36@gmail.com',1,(select id from language limit 1),NULL,'mr','Matilda','Rodriguez','Research & Development',201),
(10170, 'a256a310bc1e5db755fd392c524028a8','md5','xwyman@jacobson.com',1,(select id from language limit 1),NULL,'mr','Jillian','Hartmann','Research & Development',201),
(10171, 'a256a310bc1e5db755fd392c524028a8','md5','bonnie.luettgen@gmail.com',0,(select id from language limit 1),NULL,'mr','Amanda','Kub','Research & Development',201),
(10172, 'a256a310bc1e5db755fd392c524028a8','md5','colten.yundt@gmail.com',1,(select id from language limit 1),NULL,'mr','Marilou','Schmidt','Sales & Relations',201),
(10173, 'a256a310bc1e5db755fd392c524028a8','md5','floyd17@emmerich.net',1,(select id from language limit 1),NULL,'mr','Monty','Schimmel','Sales & Relations',201),
(10174, 'a256a310bc1e5db755fd392c524028a8','md5','strosin.allie@mcglynn.org',1,(select id from language limit 1),NULL,'mr','Heath','Hintz','Research & Development',201),
(10175, 'a256a310bc1e5db755fd392c524028a8','md5','gottlieb.mckayla@gmail.com',1,(select id from language limit 1),NULL,'mr','Jerry','Donnelly','Research & Development',201),
(10176, 'a256a310bc1e5db755fd392c524028a8','md5','jeramie20@luettgen.info',0,(select id from language limit 1),NULL,'mr','Demario','Spencer','Technical Engineering',201),
(10177, 'a256a310bc1e5db755fd392c524028a8','md5','christophe.brekke@stroman.com',1,(select id from language limit 1),NULL,'mr','Christiana','Pacocha','Research & Development',201),
(10178, 'a256a310bc1e5db755fd392c524028a8','md5','qyundt@corkery.com',1,(select id from language limit 1),NULL,'mr','Earline','Cummerata','Marketing',201),
(10179, 'a256a310bc1e5db755fd392c524028a8','md5','ferry.krystina@heidenreich.net',0,(select id from language limit 1),NULL,'mr','Jalon','Greenholt','Research & Development',201),
(10180, 'a256a310bc1e5db755fd392c524028a8','md5','marcus44@jenkins.com',0,(select id from language limit 1),NULL,'mr','Jamison','Morissette','Research & Development',201),
(10181, 'a256a310bc1e5db755fd392c524028a8','md5','eldred76@yahoo.com',1,(select id from language limit 1),NULL,'mr','Osbaldo','Reynolds','Sales & Relations',201),
(10182, 'a256a310bc1e5db755fd392c524028a8','md5','vondricka@hessel.com',1,(select id from language limit 1),NULL,'mr','Darrel','Schoen','Research & Development',201),
(10183, 'a256a310bc1e5db755fd392c524028a8','md5','alicia.rolfson@wilderman.biz',1,(select id from language limit 1),NULL,'mr','Philip','Graham','Marketing',201),
(10184, 'a256a310bc1e5db755fd392c524028a8','md5','rmertz@yahoo.com',0,(select id from language limit 1),NULL,'mr','Joshua','Tremblay','Marketing',201),
(10185, 'a256a310bc1e5db755fd392c524028a8','md5','hudson01@yahoo.com',1,(select id from language limit 1),NULL,'mr','Bethel','Kautzer','Marketing',201);

INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10001 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Icie Dietrich
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10002 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Una Friesen
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10003 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Tyree Ernser
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10004 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Dave DuBuque
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10005 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Shyanne Mraz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10006 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Tamara Kuphal
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10007 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Omari Dach
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10008 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Elliot Herzog
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10009 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Emerson Lynch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10010 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Finance & Human Resource'); 	#Ivy Rice
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10011 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Vivien Nolan
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10012 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Montana Funk
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10013 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Hailie Kutch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10014 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Judy Shanahan
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10015 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Kara Roob
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10016 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Yvette Emmerich
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10017 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Dina Bernhard
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10018 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Bert Keeling
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10019 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Jalyn Hane
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10020 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Nickolas Heidenreich
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10021 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Abigayle McCullough
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10022 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Richie Pagac
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10023 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Connect'); 	#Jarrett Wiza
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10024 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Elisabeth Cartwright
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10025 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Lavern Will
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10026 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Natasha Paucek
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10027 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Jany Gorczany
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10028 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Cheyenne Satterfield
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10029 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Humberto Murazik
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10030 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Wilburn Heller
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10031 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Isabell Aufderhar
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10032 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Nels Bechtelar
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10033 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Lurline Wunsch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10034 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Marley Johnston
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10035 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Merl Stroman
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10036 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Fabiola Mohr
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10037 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Connect'); 	#Nichole Lind
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10038 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Lacey Green
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10039 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Jaylin Bashirian
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10040 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Finance & Human Resource'); 	#Lelah Rowe
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10041 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Augustine Bergnaum
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10042 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Front Desk'); 	#Jonatan Metz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10043 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Doug Powlowski
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10044 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Murl Vandervort
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10045 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Esta Volkman
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10046 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Marlen Mayer
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10047 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Sven Homenick
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10048 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Elaina Kohler
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10049 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Rachael Reilly
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10050 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Hester Schaden
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10051 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'IT-Administration'); 	#Darryl Kris
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10052 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Jaquelin Rutherford
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10053 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Claire Eichmann
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10054 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Jairo Feest
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10055 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Josephine Rippin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10056 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Gerson Towne
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10057 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Trace Watsica
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10058 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Marty Predovic
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10059 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Regan Abernathy
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10060 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Kiel Collins
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10061 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Cooper Flatley
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10062 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Zoe Jast
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10063 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Aaliyah Feest
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10064 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Arnold Roberts
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10065 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Janae Orn
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10066 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'International Sales'); 	#Anahi Hayes
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10067 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Lamont Wyman
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10068 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Gregoria Christiansen
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10069 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Public Relations'); 	#Jessica Koss
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10070 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Cristal Cremin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10071 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Wellington Haag
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10072 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Dangelo Roberts
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10073 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Public Relations'); 	#Consuelo Kuhic
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10074 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Violet Kunze
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10075 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Garry Rutherford
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10076 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Dante Rowe
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10077 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Tito Fadel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10078 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Blanca Kshlerin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10079 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Marvin Murphy
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10080 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Michaela Gutmann
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10081 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Annie Bernier
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10082 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Jillian Zemlak
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10083 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Phoebe Swaniawski
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10084 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Lisa Gottlieb
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10085 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Alene Fadel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10086 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Fausto Barton
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10087 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Sallie Ritchie
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10088 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'IT-Administration'); 	#Kade Johnston
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10089 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Helene Mosciski
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10090 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Elisha Champlin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10091 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Tomas Daniel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10092 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Maida Wiza
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10093 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Magnus Brakus
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10094 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Hailee Pagac
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10095 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Ova Kautzer
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10096 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Jefferey Langosh
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10097 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Silas Veum
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10098 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Lola Torphy
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10099 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Elouise Metz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10100 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Elva Schimmel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10101 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Madie Ritchie
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10102 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Aubree Streich
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10103 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Lonzo Pollich
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10104 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Leonor Fritsch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10105 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Jed Stamm
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10106 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Braden Ernser
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10107 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Finance & Human Resource'); 	#Georgiana Vandervort
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10108 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Madisyn Waelchi
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10109 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Rosetta Kub
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10110 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'IT-Administration'); 	#Tom Abshire
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10111 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Lora Lueilwitz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10112 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Emma Schowalter
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10113 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Jordan Waelchi
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10114 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Eloy Baumbach
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10115 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Finance & Human Resource'); 	#Gladys Lueilwitz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10116 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Anibal Tromp
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10117 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Dedric Lindgren
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10118 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Bridget Torphy
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10119 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Destany Larson
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10120 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Taryn Torphy
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10121 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Lolita Brekke
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10122 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Rosie Glover
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10123 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Keagan Blanda
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10124 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Wilfredo Wiegand
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10125 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Danial Davis
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10126 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Santa Turner
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10127 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Otto Schuppe
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10128 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Katharina Mertz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10129 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'IT-Administration'); 	#Rhoda Oberbrunner
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10130 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Vada McLaughlin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10131 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Product Design'); 	#Mauricio Bailey
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10132 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Ignatius Padberg
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10133 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Sienna Schmeler
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10134 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Evans Aufderhar
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10135 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Raleigh Ortiz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10136 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Zita Upton
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10137 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Financial Services'); 	#Davin Howe
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10138 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Shaniya Witting
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10139 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Clinton Sawayn
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10140 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Viola Boehm
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10141 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Pauline Kerluke
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10142 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Electa Schroeder
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10143 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Loma Luettgen
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10144 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Abdiel Dickens
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10145 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Trycia Dare
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10146 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Dan Hessel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10147 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'International Sales'); 	#Jacky Russel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10148 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Jerrold Roob
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10149 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'business units'); 	#Jensen Schamberger
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10150 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Olen Schumm
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10151 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Candido Denesik
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10152 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Jayden Russel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10153 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Corporate Design'); 	#Otho Schaden
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10154 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Otto Douglas
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10155 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Donnell Beahan
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10156 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Mollie Macejkovic
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10157 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Frederique Goodwin
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10158 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Grayce Boyle
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10159 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Tyrese Rau
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10160 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Matilde Gleason
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10161 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'business units'); 	#Alivia Lesch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10162 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'business units'); 	#Mara Parisian
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10163 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Alysson Heathcote
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10164 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Maximillian Bashirian
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10165 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Sunny Reynolds
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10166 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Shea Welch
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10167 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'International Sales'); 	#Alf Stark
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10168 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Asha Walter
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10169 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Matilda Rodriguez
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10170 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'SBP'); 	#Jillian Hartmann
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10171 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Amanda Kub
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10172 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Marilou Schmidt
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10173 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Monty Schimmel
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10174 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Heath Hintz
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10175 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Core & Plugins'); 	#Jerry Donnelly
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10176 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Demario Spencer
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10177 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Christiana Pacocha
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10178 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Research & Development'); 	#Earline Cummerata
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10179 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Enterprise'); 	#Jalon Greenholt
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10180 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Connect'); 	#Jamison Morissette
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10181 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'National Sales'); 	#Osbaldo Reynolds
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10182 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Technical Engineering'); 	#Darrel Schoen
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10183 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Philip Graham
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10184 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Public Relations'); 	#Joshua Tremblay
INSERT INTO b2b_role_contact (debtor_contact_id, role_id) (SELECT 10185 as debtor_contact_id, id AS role_id FROM b2b_role WHERE `name` = 'Marketing'); 	#Bethel Kautzer