mynews_prod tables:
  addresses, addresses_additional_info, category_mapping, client_user, clients, clippings, contact_list, contact_publication, contact_region, contacts, countries, domains, failed_jobs, group_tag, groups, job_titles, jobs, language_market, languages, legacy_categories, legacy_tenants, legacy_tenants_v2, list_region, lists, main_city, market_list, market_region, market_user, markets, mediables, migrations, model_has_permissions, model_has_roles, notables, nova_media_library, nova_menu_menu_items, nova_menu_menus, nova_page_manager_pages, nova_page_manager_regions, nova_settings, permissions, personal_access_tokens, platforms, publication_group_publication, publication_groups, publications, regions, role_has_permissions, roles, sessions, social_accounts, social_media, staging_media_contacts, state, tags, tenant_user, tenants, user_filter_selections, users

category_mapping (1452 rows): id, category, tag_ids

group_tag (3913 rows): id, group_id, tag_id, created_at, updated_at, order

groups (326 rows): id, name, client_id, parent_id, is_part_of_article_group, is_part_of_contact_group, created_at, updated_at

publication_group_publication (5 rows): id, publication_group_id, publication_id
  {"id":1,"publication_group_id":1,"publication_id":10473}
  {"id":2,"publication_group_id":1,"publication_id":9712}
  {"id":3,"publication_group_id":1,"publication_id":9710}
  {"id":4,"publication_group_id":1,"publication_id":8667}
  {"id":5,"publication_group_id":1,"publication_id":8661}

publication_groups (1 rows): id, name, created_at, updated_at
  {"id":1,"name":"Tier 1","created_at":"2025-12-11T13:36:36.000Z","updated_at":"2025-12-11T13:36:36.000Z"}

user_filter_selections (27 rows): id, user_id, defaultable_type, defaultable_id, created_at, updated_at
  {"id":3,"user_id":262,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":5,"created_at":null,"updated_at":null}
  {"id":4,"user_id":347,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":5,"created_at":null,"updated_at":null}
  {"id":5,"user_id":378,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":1,"created_at":null,"updated_at":null}
  {"id":6,"user_id":311,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":1,"created_at":null,"updated_at":null}
  {"id":9,"user_id":351,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":2,"created_at":null,"updated_at":null}
  {"id":10,"user_id":313,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":2,"created_at":null,"updated_at":null}
  {"id":14,"user_id":355,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":3,"created_at":null,"updated_at":null}
  {"id":15,"user_id":355,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":4,"created_at":null,"updated_at":null}
  {"id":17,"user_id":437,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":3,"created_at":null,"updated_at":null}
  {"id":18,"user_id":437,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":4,"created_at":null,"updated_at":null}
  {"id":28,"user_id":480,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":2,"created_at":null,"updated_at":null}
  {"id":29,"user_id":475,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":30,"user_id":184,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":31,"user_id":337,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":32,"user_id":334,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":34,"user_id":79,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":35,"user_id":377,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":36,"user_id":493,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":37,"user_id":430,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":38,"user_id":262,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":39,"user_id":431,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":107,"created_at":null,"updated_at":null}
  {"id":40,"user_id":504,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":3,"created_at":null,"updated_at":null}
  {"id":41,"user_id":503,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":3,"created_at":null,"updated_at":null}
  {"id":42,"user_id":522,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":3,"created_at":null,"updated_at":null}
  {"id":43,"user_id":522,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":4,"created_at":null,"updated_at":null}
  {"id":44,"user_id":524,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":2,"created_at":null,"updated_at":null}
  {"id":45,"user_id":584,"defaultable_type":"Modules\\Fullbeam\\Models\\Central\\Region","defaultable_id":2,"created_at":null,"updated_at":null}

Ferrari (client 7) tags sample:
  {"id":641,"name":"Purosangue","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":642,"name":"Petrol ","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":644,"name":"Product","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":645,"name":"SUV","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":783,"name":"coupe","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":785,"name":"Tuner","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":786,"name":"Roma Spider","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":787,"name":"soft top","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":788,"name":"GMD","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":789,"name":"GMD Roma Spider","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":790,"name":"Seat patent","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":793,"name":"Portofino","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":794,"name":"hard top","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":795,"name":"Press release","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":796,"name":"812 Superfast","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":798,"name":"Crash","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":799,"name":"Prototype","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":800,"name":"F40","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":801,"name":"Corporate","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":802,"name":"four door","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":803,"name":"Crime","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":804,"name":"Theft","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":805,"name":"Enzo","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":806,"name":"288 GTO","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":807,"name":"F50","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":808,"name":"458 Speciale","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":809,"name":"La Ferrari","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":810,"name":"Bang & Olufsen","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":814,"name":"Tuning","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":815,"name":"Scale model","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":816,"name":"Stolen cars","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":817,"name":"Dealership","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":820,"name":"Reviews","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":821,"name":"296 GTS","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":822,"name":"296 GTB","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":823,"name":"Hybrid","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":824,"name":"812 Competizione","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":857,"name":"Ferrari Demo TEG","parent_id":null,"is_part_of_article_group":0,"is_competitor_tag":0}
  {"id":924,"name":"AMG GT Coupé","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":925,"name":"812 GTS","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":926,"name":"SF90XX Stradale","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":927,"name":"Rose Noire Droptail","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":928,"name":"Urus","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":929,"name":"499P","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":931,"name":"Roma","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":932,"name":"296 GT3","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":934,"name":"California ","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":938,"name":"Huracan STO SC 10°","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":939,"name":"McLaren 750S ","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":940,"name":"McLaren Artura","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":941,"name":"Lamborghini Urus S","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":942,"name":"Batur ","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":943,"name":"250 GTO","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":952,"name":"Test Drive","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":953,"name":"GT63 AMG","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":954,"name":"Chiron","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":957,"name":"Specter ","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":959,"name":"Taycan","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
  {"id":960,"name":"Nevera","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":1}
  {"id":961,"name":"Motorsport","parent_id":null,"is_part_of_article_group":1,"is_competitor_tag":0}
