-- Assign 81 dealer-specific offers/services to their dealers
-- Uses direct id_dealer for confirmed mappings
-- Uses subquery for kieser.gmbh (not found via name matching)

START TRANSACTION;

-- 7C8M9x9LVR71Yrs2nsr7v2 offer   KGM          -> art.car (ID 332)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7C8M9x9LVR71Yrs2nsr7v2' LIMIT 1), 332, 1);

-- 5NeRflcOTjuhsmYnYCuNZg offer   Hyundai      -> astara.ch (ID 661)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5NeRflcOTjuhsmYnYCuNZg' LIMIT 1), 661, 1);

-- 5Eac7bimT549coXc87RIZU offer   Hyundai      -> blatten (ID 92)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5Eac7bimT549coXc87RIZU' LIMIT 1), 92, 1);

-- 79YhgNsJUElvYmcd2BWFYX offer   Hyundai      -> blatten (ID 92)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '79YhgNsJUElvYmcd2BWFYX' LIMIT 1), 92, 1);

-- 7rm8bImvW4AjNobYrT2kwP offer   Hyundai      -> blatten (ID 92)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7rm8bImvW4AjNobYrT2kwP' LIMIT 1), 92, 1);

-- 4jcE2DfCGSD7HHQ8GWgsCR service Hyundai      -> blatten (ID 92)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '4jcE2DfCGSD7HHQ8GWgsCR' LIMIT 1), 92, 1);

-- 5fQMyxxNZKTNznbTzyQ66P offer   Nissan       -> branner.nueziders (ID 562)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5fQMyxxNZKTNznbTzyQ66P' LIMIT 1), 562, 1);

-- 2IY8NLSuOwR0JRvQwuC6ag offer   Hyundai      -> city.garage.ag (ID 99)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2IY8NLSuOwR0JRvQwuC6ag' LIMIT 1), 99, 1);

-- 5DP6JqXb2RlSQXfPaMG41A offer   Hyundai      -> city.garage.ag (ID 99)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5DP6JqXb2RlSQXfPaMG41A' LIMIT 1), 99, 1);

-- 7BG5cxdCawgZgG9mTgefIk offer   MgMotor      -> domenighetti (ID 110)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7BG5cxdCawgZgG9mTgefIk' LIMIT 1), 110, 1);

-- 6J0DUpBM3KHU10UyR8trzY offer   Hyundai      -> etoile.automobile (ID 36)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '6J0DUpBM3KHU10UyR8trzY' LIMIT 1), 36, 1);

-- 40EIAY90zHKGvy8JnS4NWm offer   Hyundai      -> garage.forge (ID 44)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '40EIAY90zHKGvy8JnS4NWm' LIMIT 1), 44, 1);

-- 3qvqVnfell9ymciSL0Gg8h offer   Maxus        -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '3qvqVnfell9ymciSL0Gg8h' LIMIT 1), 294, 1);

-- 4roYLuzP6huJwb9c4w4K6c offer   Maxus        -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '4roYLuzP6huJwb9c4w4K6c' LIMIT 1), 294, 1);

-- 1Nt2dRRQe2LZGUWEkBEL9B offer   MgMotor      -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '1Nt2dRRQe2LZGUWEkBEL9B' LIMIT 1), 294, 1);

-- 2Pw3n2nw3CvZvestUs6Uyz offer   MgMotor      -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2Pw3n2nw3CvZvestUs6Uyz' LIMIT 1), 294, 1);

-- 2kyxFoZM9vfw6XIID6pVVX offer   MgMotor      -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2kyxFoZM9vfw6XIID6pVVX' LIMIT 1), 294, 1);

-- 2537JO9m6KnI66DJZGiBgk service MgMotor      -> garage.konstantin (ID 294)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '2537JO9m6KnI66DJZGiBgk' LIMIT 1), 294, 1);

-- 2GJDV35yKuQqpgi3ubnlkq offer   Hyundai      -> garage.marti (ID 65)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2GJDV35yKuQqpgi3ubnlkq' LIMIT 1), 65, 1);

-- 2ZIY35P0FWZv9eCiw6JOGi offer   Hyundai      -> garage.marti (ID 65)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2ZIY35P0FWZv9eCiw6JOGi' LIMIT 1), 65, 1);

-- 9Iz2O4VpjBDMUxxf7uwAS offer   Hyundai      -> garage.marti (ID 65)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '9Iz2O4VpjBDMUxxf7uwAS' LIMIT 1), 65, 1);

-- kjprPff9th8K5rmMCrSV2 offer   Hyundai      -> germann.schaffhausen (ID 108)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = 'kjprPff9th8K5rmMCrSV2' LIMIT 1), 108, 1);

-- 1ra7ufHuxK9jsSS9KCemf0 offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '1ra7ufHuxK9jsSS9KCemf0' LIMIT 1), 58, 1);

-- 2iL8l6JUHsYclO8TkjTSPH offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2iL8l6JUHsYclO8TkjTSPH' LIMIT 1), 58, 1);

-- 45RagYsVoX3J8EcLRscMdz offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '45RagYsVoX3J8EcLRscMdz' LIMIT 1), 58, 1);

-- 5oe9RshXSj0dpzPRzCvDKy offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5oe9RshXSj0dpzPRzCvDKy' LIMIT 1), 58, 1);

-- 730trda0tnXM2SCcR0f96T offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '730trda0tnXM2SCcR0f96T' LIMIT 1), 58, 1);

-- 7Awt2rLlpCeHjTrYdqWuoS offer   Hyundai      -> gundeli.garage (ID 58)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7Awt2rLlpCeHjTrYdqWuoS' LIMIT 1), 58, 1);

-- 2n6AwhYgvDSUauEgQMlpU6 offer   Hyundai      -> huber (ID 275)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2n6AwhYgvDSUauEgQMlpU6' LIMIT 1), 275, 1);

-- 43yeG5xEE2kshm3KGW6pf2 offer   Hyundai      -> huber (ID 275)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '43yeG5xEE2kshm3KGW6pf2' LIMIT 1), 275, 1);

-- 69Zl7D6LEDMhcXQb27ewqw offer   Hyundai      -> huber (ID 275)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '69Zl7D6LEDMhcXQb27ewqw' LIMIT 1), 275, 1);

-- MwZQIGKsWesDpEZH3yXvs offer   Hyundai      -> huber (ID 275)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = 'MwZQIGKsWesDpEZH3yXvs' LIMIT 1), 275, 1);

-- 8U1XMgpcHn4CgHD6thNxY offer   Hyundai      -> karl.graf (ID 68)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '8U1XMgpcHn4CgHD6thNxY' LIMIT 1), 68, 1);

-- 44ODZZHYBMVDplnbSyV1tz offer   Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'offers', e.id_offers, d.id_dealer, 1
-- FROM aws_offers e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '44ODZZHYBMVDplnbSyV1tz'
-- LIMIT 1;

-- 10WV7X8zmnAe4shuTtg7JC service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '10WV7X8zmnAe4shuTtg7JC'
-- LIMIT 1;

-- 4rJjONS66wv3zkaNiKmBNO service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '4rJjONS66wv3zkaNiKmBNO'
-- LIMIT 1;

-- 4xsY20rOkpKadl1bctaYVz service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '4xsY20rOkpKadl1bctaYVz'
-- LIMIT 1;

-- 6C50ssiMkYaNxpYjtqo1rh service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '6C50ssiMkYaNxpYjtqo1rh'
-- LIMIT 1;

-- 6udtj8ejiACIWLJz06Olua service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '6udtj8ejiACIWLJz06Olua'
-- LIMIT 1;

-- 7t4tm7AklCYr2pq3ewoCH2 service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = '7t4tm7AklCYr2pq3ewoCH2'
-- LIMIT 1;

-- pZQPnJsoPqe0aCCvvN9S4 service Nissan       -> kieser.gmbh (MISSING - needs manual mapping)
-- INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published)
-- SELECT 'services', e.id_services, d.id_dealer, 1
-- FROM aws_services e
-- JOIN dealer2brands d ON d.dealer_code = 'kieser.gmbh'
-- WHERE e.ext_id = 'pZQPnJsoPqe0aCCvvN9S4'
-- LIMIT 1;

-- 1FHcikmok7inwxq7mZ1Ztl service Hyundai      -> kueng.ag (ID 71)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '1FHcikmok7inwxq7mZ1Ztl' LIMIT 1), 71, 1);

-- 160r8lJcFkzr8vo78jUrvD service Nissan       -> lifag (ID 545)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '160r8lJcFkzr8vo78jUrvD' LIMIT 1), 545, 1);

-- 1WF05gtiNHiWp1OZicvNbo offer   Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '1WF05gtiNHiWp1OZicvNbo' LIMIT 1), 284, 1);

-- 1rMpeZQFweMqpJC0cb6Bo6 offer   Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '1rMpeZQFweMqpJC0cb6Bo6' LIMIT 1), 284, 1);

-- 5WKnVUOwly1WBTIl2a1ZEz offer   Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5WKnVUOwly1WBTIl2a1ZEz' LIMIT 1), 284, 1);

-- 71cVCrPzhF0EBMKnVQy8JK offer   Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '71cVCrPzhF0EBMKnVQy8JK' LIMIT 1), 284, 1);

-- XjB83RX8bUCh7NyKe8uEO offer   Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = 'XjB83RX8bUCh7NyKe8uEO' LIMIT 1), 284, 1);

-- 1WGEjdvQx3yzvTBxDMEb96 service Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '1WGEjdvQx3yzvTBxDMEb96' LIMIT 1), 284, 1);

-- 2ATmdlRmvNKNAmgv4X6lsq service Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '2ATmdlRmvNKNAmgv4X6lsq' LIMIT 1), 284, 1);

-- 54UsZVOKjAU8rOrPkT19hn service Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '54UsZVOKjAU8rOrPkT19hn' LIMIT 1), 284, 1);

-- 5Zr5yc7mqYaDXlrYaBbAJv service Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '5Zr5yc7mqYaDXlrYaBbAJv' LIMIT 1), 284, 1);

-- 7GmxEAd04gBJT7j2JUMebv service Hyundai      -> p.schweizer (ID 284)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '7GmxEAd04gBJT7j2JUMebv' LIMIT 1), 284, 1);

-- 56CnwFQkrAImhQ5GICxtuC offer   Hyundai      -> pao (ID 98)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '56CnwFQkrAImhQ5GICxtuC' LIMIT 1), 98, 1);

-- 6J6iuoMtWGcz4UJFnrKRzd offer   Hyundai      -> pao (ID 98)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '6J6iuoMtWGcz4UJFnrKRzd' LIMIT 1), 98, 1);

-- 7ITVPbggrKzZeA50TWNno6 offer   Hyundai      -> pao (ID 98)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7ITVPbggrKzZeA50TWNno6' LIMIT 1), 98, 1);

-- 2fiLF5RqFDgassjFAPPcwf service Hyundai      -> pao (ID 98)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '2fiLF5RqFDgassjFAPPcwf' LIMIT 1), 98, 1);

-- 15R6YlBpkoB0qz3XjHxoAm offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '15R6YlBpkoB0qz3XjHxoAm' LIMIT 1), 267, 1);

-- 20VyHT3VfOF4R54zmgzjGC offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '20VyHT3VfOF4R54zmgzjGC' LIMIT 1), 267, 1);

-- 2sl66xb0OkiAvBuXMDXPCY offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2sl66xb0OkiAvBuXMDXPCY' LIMIT 1), 267, 1);

-- 3wGoa4PulpQSIklpMEShKo offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '3wGoa4PulpQSIklpMEShKo' LIMIT 1), 267, 1);

-- 5yhCgzSLINL0sifGxcD6Wn offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5yhCgzSLINL0sifGxcD6Wn' LIMIT 1), 267, 1);

-- 69c1mPhlGxmyY4GoNr27xh offer   Nissan       -> pieren.ag (ID 267)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '69c1mPhlGxmyY4GoNr27xh' LIMIT 1), 267, 1);

-- 3XIKkJF4nM0gTRtN1IvJIQ offer   Hyundai      -> riantbosson (ID 339)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '3XIKkJF4nM0gTRtN1IvJIQ' LIMIT 1), 339, 1);

-- 4ROcjQVsXSoajeIGW4GjhM offer   Nissan       -> ruedi.horat.ag (ID 239)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '4ROcjQVsXSoajeIGW4GjhM' LIMIT 1), 239, 1);

-- 5fiXxQS2WcEznp9j8OtDof offer   Nissan       -> ruedi.horat.ag (ID 239)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5fiXxQS2WcEznp9j8OtDof' LIMIT 1), 239, 1);

-- 7Bixi6BvvucXsucpQWIM6m offer   Nissan       -> ruedi.horat.ag (ID 239)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7Bixi6BvvucXsucpQWIM6m' LIMIT 1), 239, 1);

-- 2ZTjso38NlLOOwUjOnvXmZ offer   Hyundai      -> schaerli.bossert (ID 67)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '2ZTjso38NlLOOwUjOnvXmZ' LIMIT 1), 67, 1);

-- 1JRmufzqjkxLqNcYMhBpnY service KGM          -> siegler.automobile (ID 301)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '1JRmufzqjkxLqNcYMhBpnY' LIMIT 1), 301, 1);

-- 6FuZJLUt1ZfC5hvPBzOvgE service KGM          -> siegler.automobile (ID 301)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '6FuZJLUt1ZfC5hvPBzOvgE' LIMIT 1), 301, 1);

-- 7BxalmD0olQBy1DVTn4XrC service KGM          -> siegler.automobile (ID 301)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = '7BxalmD0olQBy1DVTn4XrC' LIMIT 1), 301, 1);

-- Blkw1NlCamQI2n6GW4FMI service KGM          -> siegler.automobile (ID 301)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('services', (SELECT id_services FROM aws_services WHERE ext_id = 'Blkw1NlCamQI2n6GW4FMI' LIMIT 1), 301, 1);

-- 6eobQEI10CLQPSAI6BiOKo offer   KGM          -> sportgarage.helg (ID 324)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '6eobQEI10CLQPSAI6BiOKo' LIMIT 1), 324, 1);

-- 52XhqncDOiZMTiN0zgGqWn offer   Maxus        -> th.willy.bern (ID 287)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '52XhqncDOiZMTiN0zgGqWn' LIMIT 1), 287, 1);

-- 7ogVJBUqYIjAyBVOkf9wjP offer   MgMotor      -> th.willy.bern (ID 287)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '7ogVJBUqYIjAyBVOkf9wjP' LIMIT 1), 287, 1);

-- 12tZBg3dGpLVVifrPnNqyU offer   Hyundai      -> zimmermann (ID 297)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '12tZBg3dGpLVVifrPnNqyU' LIMIT 1), 297, 1);

-- 5Y7YTmKHeI2OYOseHAylwt offer   Hyundai      -> zimmermann (ID 297)
INSERT INTO aws_entity2dealer (entity_type, entity_id, dealer_id, published) VALUES
  ('offers', (SELECT id_offers FROM aws_offers WHERE ext_id = '5Y7YTmKHeI2OYOseHAylwt' LIMIT 1), 297, 1);

COMMIT;

-- Total: 73 confirmed + 8 unmatched = 81 items