INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'traiteur-verviers-boucherie-goeders', 'BE-WAL', 'Boucherie Goeders', 'Traiteur', ARRAY['viande locale', 'charcuterie maison', 'plats traiteur', 'viande maturée', 'produits saisonniers', 'circuit court', 'bœuf wagyu', 'affinage contrôlé', '24h/24', 'préparation de plats traiteurs', 'viandes maturées', 'charcuteries artisanales']::text[], ARRAY['Préparation de plats traiteurs', 'Viandes maturées', 'Charcuteries artisanales', 'Plats préparés', 'Conseils en découpe et cuisson']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue des Minières 56', 'https://boucheriegoeders.be/', NULL, NULL, NULL, NULL, 'contact@boucheriegoeders.be', NULL, '+3287222384', '+3287222384', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], '24h/24 - 7j/7', '[{"day":"jeudi","open":"08:30","close":"18:30","isClosed":false},{"day":"vendredi","open":"08:30","close":"18:30","isClosed":false}]'::jsonb, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de préparation de plats traiteurs?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Verviers et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'La Boucherie Goeders à Verviers allie tradition et innovation avec ses viandes maturées, charcuteries artisanales et plats traiteurs. Leur comptoir créatif évolue au rythme des saisons pour offrir une fraîcheur irréprochable. La viande locale et les produits d''exception comme le Wagyu ou la Rubia Gallega y côtoient des spécialités primées.', 'Traiteur à Verviers | Boucherie Goeders', 'Viandes maturées en chambre à sel et plats traiteurs frais préparés quotidiennement. Traçabilité complète avec QR code pour une transparence totale.', 'Boucherie Goeders - Traiteur à Verviers', 'Découvrez des viandes maturées, charcuteries artisanales et plats traiteurs préparés avec des produits locaux. Affinage contrôlé en chambre à sel.', '{"@context":"https://schema.org","@type":"ButcherShop","name":"Boucherie Goeders","description":"Traiteur spécialisé en viandes maturées et plats traiteurs artisanaux à Verviers.","url":"https://revelys.be/entreprises/traiteur-verviers-boucherie-goeders","sameAs":["https://boucheriegoeders.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue des Minières 56","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":"Verviers","keywords":["viande locale","charcuterie maison","plats traiteur","viande maturée","produits saisonniers","circuit court","bœuf wagyu","affinage contrôlé","24h/24","préparation de plats traiteurs","viandes maturées","charcuteries artisanales"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","name":"Services et produits","itemListElement":[{"@type":"OfferItem","name":"Préparation de plats traiteurs"},{"@type":"OfferItem","name":"Viandes maturées"},{"@type":"OfferItem","name":"Charcuteries artisanales"}]}}'::jsonb, '2026-02-26T23:32:27.346Z', TRUE, 5, '35e223e9d719e52a5aed275554f12927cdbab94de0d29c056fc2a57a65a20f4a', 'Chez Boucherie Goeders, chaque produit raconte une histoire : celle d''éleveurs locaux et de viandes affinées avec passion. Leur savoir-faire artisanal, récompensé par des médailles d''or, se décline en plats traiteurs gourmands et charcuteries maison.', NULL, 'Joie', '[{"name":"Affinage dans chambre à sel","description":"Les viandes reposent plusieurs semaines dans une chambre climatisée avec blocs de sel himalayen pour optimiser leur tendreté et développer des arômes uniques. Chaque pièce est contrôlée quotidiennement.","frequency":"quotidien","impact":"meilleure qualité gustative","proof":null},{"name":"Traçabilité complète","description":"L''application Quality Guard permet de retracer chaque morceau de viande : origine, élevage et conditions d''affinage. Un QR code est disponible sur demande.","frequency":"à chaque vente","impact":"transparence totale","proof":null},{"name":"Préparation des plats traiteurs","description":"Le cuisinier prépare quotidiennement les plats traiteurs avec des produits frais et locaux. Les recettes évoluent selon les saisons pour garantir fraîcheur et originalité.","frequency":"quotidien","impact":"plats toujours frais","proof":null},{"name":"Conseil personnalisé en découpe","description":"Charly guide chaque client dans le choix des morceaux, propose des techniques de cuisson adaptées et partage ses astuces pour sublimer les produits.","frequency":"à chaque demande","impact":"meilleure expérience culinaire","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-26T23:33:34.162Z","proof":"https://boucheriegoeders.be/"},{"label":"Seed: city hint","date":"2026-02-26T23:33:34.162Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-26T23:33:34.162Z","proof":"Traiteur"},{"label":"Seed: search keyword","date":"2026-02-26T23:33:34.162Z","proof":"Traiteur"},{"label":"Extracted: city","date":"2026-02-26T23:33:34.162Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-26T23:33:34.162Z","proof":"0822089648"},{"label":"Email extracted","date":"2026-02-26T23:33:34.162Z","proof":"contact@boucheriegoeders.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-26T23:33:34.162Z","proof":"confidence=92/100"},{"label":"Phone extracted","date":"2026-02-26T23:33:34.162Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-26T23:33:34.162Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/traiteur-verviers-boucherie-goeders/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0822089648', 'Actif', 'BCE_CSV', '2026-02-26T23:28:53.337Z', '2026-02-26T23:28:53.337Z', 'GOEDERS', '2010-01-08', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-26T23:33:34.162Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0822089648'
    AND c_existing.slug <> 'traiteur-verviers-boucherie-goeders'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coach-sportif-verviers-declaration-de-confidentialite', 'BE-WAL', 'DÉCLARATION DE CONFIDENTIALITÉ', 'Coach sportif', ARRAY['objectifs fitness', 'programme personnalise', 'suivi progressif', 'motivation sportive', 'equipements dernier cri', '24h/7j', 'coaching sportif personnalisé', 'programmes d''entraînement sur mesure', 'suivi nutritionnel', 'préparation physique spécifique', 'accompagnement mental']::text[], ARRAY['Coaching sportif personnalisé', 'Programmes d''entraînement sur mesure', 'Suivi nutritionnel', 'Préparation physique spécifique', 'Accompagnement mental']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue des Martyrs 37', 'https://www.basic-fit.com/', 'https://www.facebook.com/BasicFitFrance', 'https://www.instagram.com/basicfitfr/?hl=fr', NULL, 'https://www.tiktok.com/@basicfitnl', 'requestprivacy@basic-fit.com', NULL, '+32105032026', '+32105032026', NULL, NULL, NULL, 'Verviers', ARRAY['français', 'néerlandais', 'anglais', 'allemand']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coaching sportif personnalisé?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Gérez-vous les interventions urgentes?","answer":"Oui, l''organisation permet de répondre aux demandes urgentes (24h/24 - 7j/7)."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"DÉCLARATION DE CONFIDENTIALITÉ se distingue par son approche humaine et adaptable, transformant chaque défi sportif en opportunité de progression."}]'::jsonb, 'DÉCLARATION DE CONFIDENTIALITÉ accompagne les sportifs de Verviers avec des coachings personnalisés pour atteindre leurs objectifs. Chaque séance est conçue pour s''adapter aux besoins individuels, en combinant motivation et expertise technique.', 'Coach sportif à Verviers | DÉCLARATION DE CONFIDENTIALITÉ', 'Programmes d''entraînement personnalisés avec suivi nutritionnel et mental. Bilan initial complet pour adapter les séances. Coach disponible 24h/7j à Verviers.', 'Coach sportif à Verviers - DÉCLARATION DE CONFIDENTIALITÉ', 'Découvrez des programmes d''entraînement sur mesure avec suivi nutritionnel et mental. Bilan initial complet pour adapter les séances à vos besoins.', '{"@context":"https://schema.org","@type":"FitnessBusiness","name":"DÉCLARATION DE CONFIDENTIALITÉ","description":"Coach sportif proposant des programmes personnalisés avec suivi nutritionnel et mental à Verviers.","url":"https://revelys.be/entreprises/coach-sportif-verviers-declaration-de-confidentialite","sameAs":["https://www.basic-fit.com/"],"address":{"@type":"PostalAddress","streetAddress":"Rue des Martyrs 37","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["objectifs fitness","programme personnalise","suivi progressif","motivation sportive","equipements dernier cri","24h/7j","coaching sportif personnalisé","programmes d''entraînement sur mesure","suivi nutritionnel","préparation physique spécifique","accompagnement mental"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/logo.webp"}'::jsonb, '2026-02-26T23:51:05.995Z', TRUE, 5, '4aa724e60f2beb2cb7318637e4ec7192dc604772713c519db830b9b40d8835e6', 'DÉCLARATION DE CONFIDENTIALITÉ se distingue par son approche humaine et adaptable, transformant chaque défi sportif en opportunité de progression.', NULL, 'Joie', '[{"name":"Bilan initial complet","description":"Analyse des capacités physiques, objectifs et habitudes alimentaires pour personnaliser le programme.","frequency":"1 fois","impact":"Permet d''adapter les séances aux besoins réels du client.","proof":null},{"name":"Suivi hebdomadaire","description":"Évaluation des progrès et ajustement du programme en fonction des résultats et de la motivation.","frequency":"1 fois par semaine","impact":"Garantit une progression constante et évite les plateaux.","proof":null},{"name":"Séance d''essai gratuite","description":"Découverte des méthodes de coaching sans engagement pour évaluer la compatibilité.","frequency":"1 fois","impact":"Permet au client de tester l''approche avant tout engagement.","proof":null}]'::jsonb, 77, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-26T23:51:56.960Z","proof":"https://www.basic-fit.com/fr-be/clubs/basic-fit-verviers-rue-de-limbourg-24-7-c482af9e84134ad297d592fcb4360484.html"},{"label":"Seed: city hint","date":"2026-02-26T23:51:56.960Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-26T23:51:56.960Z","proof":"Coach sportif"},{"label":"Seed: search keyword","date":"2026-02-26T23:51:56.960Z","proof":"Coach sportif"},{"label":"Extracted: city","date":"2026-02-26T23:51:56.960Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-26T23:51:56.960Z","proof":"0450228765"},{"label":"Email extracted","date":"2026-02-26T23:51:56.960Z","proof":"requestprivacy@basic-fit.com"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-26T23:51:56.960Z","proof":"confidence=80/100"},{"label":"BCE recovered from local identity","date":"2026-02-26T23:51:56.960Z","proof":"score=85"},{"label":"Phone extracted","date":"2026-02-26T23:51:56.960Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-26T23:51:56.960Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-declaration-de-confidentialite/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0450228765', 'Actif', 'BCE_CSV', '2026-02-26T23:48:48.401Z', '2026-02-26T23:48:48.401Z', 'ID', '1993-04-09', 'Personne morale', 'Association sans but lucratif', 'Situation normale', '2026-02-11', '2026-02-26T23:51:56.960Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0450228765'
    AND c_existing.slug <> 'coach-sportif-verviers-declaration-de-confidentialite'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coach-sportif-verviers-la-maison', 'BE-WAL', 'La Maison', 'Coach sportif', ARRAY['sport sur mesure', 'objectifs fitness', 'accompagnement personnalisé', 'bien-être global', 'performance durable', 'rituels concrets', 'coaching sportif individuel', 'entrainement en groupe', 'programme de remise en forme', 'suivi nutritionnel', 'préparation physique spécifique']::text[], ARRAY['Coaching sportif individuel', 'Entrainement en groupe', 'Programme de remise en forme', 'Suivi nutritionnel', 'Préparation physique spécifique']::text[], NULL, NULL, NULL, NULL, 'Uccle', '1180', 'BE', 'Rue Dodonée 71', 'https://www.la-maison.be/', NULL, NULL, NULL, NULL, 'location@la-maison.be', NULL, '+32486463574', '+32486463574', NULL, NULL, NULL, 'Uccle', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coaching sportif individuel?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Uccle. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"La Maison se distingue par son approche holistique qui lie performance sportive et équilibre mental, avec des programmes adaptés à chaque profil."}]'::jsonb, 'La Maison à Uccle propose un coaching sportif personnalisé pour atteindre vos objectifs de forme physique. Son approche holistique allie bien-être mental et performance corporelle, dans une dynamique d''accompagnement sur mesure.', 'Coach sportif à Uccle | La Maison', 'Programmes sportifs sur mesure avec suivi nutritionnel et bilan initial personnalisé. Approche holistique adaptée aux besoins d''Uccle.', 'Coaching sportif à Uccle - La Maison', 'La Maison propose des programmes de remise en forme, coaching individuel et entraînement en groupe à Uccle avec suivi nutritionnel personnalisé.', '{"@context":"https://schema.org","@type":"HealthAndFitnessInstruction","name":"La Maison","description":"Coach sportif proposant des programmes sur mesure et un accompagnement personnalisé à Uccle.","url":"https://revelys.be/entreprises/coach-sportif-verviers-la-maison","sameAs":["https://www.la-maison.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue Dodonée 71","postalCode":"1180","addressLocality":"Uccle","addressCountry":"BE"},"areaServed":"Uccle","keywords":["sport sur mesure","objectifs fitness","accompagnement personnalisé","bien-être global","performance durable","rituels concrets","coaching sportif individuel","entrainement en groupe","programme de remise en forme","suivi nutritionnel","préparation physique spécifique"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","name":"Services de coaching sportif","itemListElement":[{"@type":"Offer","name":"Coaching sportif individuel"},{"@type":"Offer","name":"Entrainement en groupe"},{"@type":"Offer","name":"Programme de remise en forme"},{"@type":"Offer","name":"Suivi nutritionnel"},{"@type":"Offer","name":"Préparation physique spécifique"}]}}'::jsonb, '2026-02-26T23:58:17.411Z', TRUE, 5, '176eac66024cfb72a6943a8db74f8782be109c44cf0fec3a162c74f0c1652be8', 'La Maison se distingue par son approche holistique qui lie performance sportive et équilibre mental, avec des programmes adaptés à chaque profil.', NULL, 'Clarté', '[{"name":"Bilan initial complet","description":"Évaluation des capacités physiques, objectifs et habitudes de vie pour personnaliser le programme.","frequency":"1 fois","impact":"Adaptation optimale du coaching","proof":null},{"name":"Suivi hebdomadaire","description":"Point régulier sur les progrès, ajustements des exercices et motivation continue.","frequency":"1 fois par semaine","impact":"Maintenir l''engagement client","proof":null},{"name":"Journal d''entrainement","description":"Tenue d''un carnet de bord pour suivre les performances, sensations et évolutions.","frequency":"Quotidiennement","impact":"Conscience des progrès","proof":null}]'::jsonb, 87, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-26T23:59:19.972Z","proof":"https://www.la-maison.be/equipe/"},{"label":"Seed: city hint","date":"2026-02-26T23:59:19.972Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-26T23:59:19.972Z","proof":"Coach sportif"},{"label":"Seed: search keyword","date":"2026-02-26T23:59:19.972Z","proof":"Coach sportif"},{"label":"Extracted: city","date":"2026-02-26T23:59:19.972Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-26T23:59:19.972Z","proof":"0410174792"},{"label":"Email extracted","date":"2026-02-26T23:59:19.972Z","proof":"location@la-maison.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-26T23:59:19.972Z","proof":"confidence=80/100"},{"label":"BCE recovered from local identity","date":"2026-02-26T23:59:19.972Z","proof":"score=60"},{"label":"Phone extracted","date":"2026-02-26T23:59:19.972Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-26T23:59:19.972Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coach-sportif-verviers-la-maison/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0410174792', 'Actif', 'BCE_CSV', '2026-02-26T23:55:12.710Z', '2026-02-26T23:55:12.710Z', 'La Maison', '1961-07-13', 'Personne morale', 'Association sans but lucratif', 'Situation normale', '2026-02-11', '2026-02-26T23:59:19.972Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0410174792'
    AND c_existing.slug <> 'coach-sportif-verviers-la-maison'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'agence-web-verviers-bac-agency', 'BE-WAL', 'BAC Agency', 'Agence web', ARRAY['communication digitale', 'stratégie cross-média', 'anciens journalistes', 'production audiovisuelle', 'développement web', 'gestion réseaux sociaux', 'campagnes publicitaires', 'développement de sites internet', 'création de vidéos professionnelles', 'gestion des réseaux sociaux', 'référencement naturel (seo)', 'campagnes publicitaires digitales']::text[], ARRAY['Développement de sites internet', 'Création de vidéos professionnelles', 'Gestion des réseaux sociaux', 'Référencement naturel (seo)', 'Campagnes publicitaires digitales', 'Production de contenus multimédias']::text[], 'sur_devis', NULL, NULL, NULL, 'Limbourg', '4830', 'BE', 'Hèvremont (Village) 107', 'https://bacagency.be/', 'https://www.facebook.com/bacagency.be', 'https://instagram.com/bacagency.be', 'https://www.linkedin.com/company/bacagency', 'https://www.tiktok.com/@bac_agency', 'admin@bacagency.be', NULL, '+32495822002', '+32495822002', NULL, NULL, NULL, 'Limbourg', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de développement de sites internet?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Limbourg. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"BAC Agency se distingue par son expertise éditoriale unique, alliant fond et forme pour créer des campagnes qui captent l''attention. Leur approche cross-média garantit une cohérence du message sur tous les canaux."}]'::jsonb, 'BAC Agency est une agence web spécialisée en communication digitale et multimédia, basée à Limbourg. Elle propose des solutions sur-mesure pour booster la notoriété des entreprises grâce à une stratégie cross-média intégrant production audiovisuelle, développement web et gestion de communauté.', 'Agence web à Limbourg | BAC Agency', 'Expertise éditoriale et production vidéo professionnelle pour une communication digitale cohérente. Ancienne équipe de journalistes avec contrôle qualité interne.', 'BAC Agency - Agence web à Limbourg', 'Agence spécialisée en stratégie cross-média, développement web et création de vidéos professionnelles. Basée à Hèvremont (Limbourg), elle propose des solutions digitales sur mesure.', '{"@context":"https://schema.org","@type":"WebDesignAgency","name":"BAC Agency","description":"Agence web spécialisée en communication digitale et production audiovisuelle.","url":"https://revelys.be/entreprises/agence-web-verviers-bac-agency","sameAs":["https://bacagency.be/"],"address":{"@type":"PostalAddress","streetAddress":"Hèvremont (Village) 107","postalCode":"4830","addressLocality":"Limbourg","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Limbourg"},"keywords":["communication digitale","stratégie cross-média","anciens journalistes","production audiovisuelle","développement web","gestion réseaux sociaux","campagnes publicitaires","développement de sites internet","création de vidéos professionnelles","référencement naturel (seo)","campagnes publicitaires digitales"],"image":[{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/logo.webp","width":500,"height":300}],"logo":{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/logo.webp"},"hasOfferCatalog":{"@type":"OfferCatalog","itemListElement":[{"@type":"OfferItem","name":"Développement de sites internet","url":"https://bacagency.be/"},{"@type":"OfferItem","name":"Création de vidéos professionnelles","url":"https://bacagency.be/"}]}}'::jsonb, '2026-02-27T00:36:19.176Z', TRUE, 5, 'a5b81bda9fc700ed488485d22483b929f80cdebbddc2ecb5f3c368381204de26', 'BAC Agency se distingue par son expertise éditoriale unique, alliant fond et forme pour créer des campagnes qui captent l''attention. Leur approche cross-média garantit une cohérence du message sur tous les canaux.', NULL, 'Clarté', '[{"name":"Briefing éditorial approfondi","description":"Chaque projet débute par un échange détaillé avec le client pour comprendre son ADN et définir la ligne éditoriale. Ce rituel permet de créer des contenus parfaitement alignés avec l''identité de la marque.","frequency":"1 fois par projet","impact":"Garantit une cohérence du message sur tous les canaux","proof":null},{"name":"Production vidéo en interne","description":"L''agence réalise elle-même ses tournages avec un équipement professionnel (caméras 4K, drones) et une équipe dédiée. Ce contrôle qualité permet des contenus visuels d''excellente facture.","frequency":"Pour chaque projet audiovisuel","impact":"Assure une qualité constante des productions","proof":null},{"name":"Reporting détaillé des campagnes","description":"Chaque action digitale fait l''objet d''un suivi statistique précis avec indicateurs de performance. Ces données permettent d''ajuster les stratégies en temps réel.","frequency":"Hebdomadaire ou mensuelle selon le","impact":"Optimise le retour sur investissement des campagnes","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T00:37:22.005Z","proof":"https://bacagency.be/"},{"label":"Seed: city hint","date":"2026-02-27T00:37:22.005Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T00:37:22.005Z","proof":"Agence web"},{"label":"Seed: search keyword","date":"2026-02-27T00:37:22.005Z","proof":"Agence web"},{"label":"Extracted: city","date":"2026-02-27T00:37:22.005Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T00:37:22.005Z","proof":"0897101431"},{"label":"Email extracted","date":"2026-02-27T00:37:22.005Z","proof":"admin@bacagency.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T00:37:22.005Z","proof":"confidence=92/100"},{"label":"Phone extracted","date":"2026-02-27T00:37:22.005Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T00:37:22.005Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-bac-agency/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0897101431', 'Actif', 'BCE_CSV', '2026-02-27T00:29:53.731Z', '2026-02-27T00:29:53.731Z', 'BAC AGENCY', '2008-04-09', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T00:37:22.005Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0897101431'
    AND c_existing.slug <> 'agence-web-verviers-bac-agency'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'creation-de-site-internet-verviers-something-about-responsive-is-happening', 'BE-WAL', 'Something about RESPONSIVE is happening ...', 'Agence web', ARRAY['responsive design', 'mobile first', 'e-commerce', 'hébergement dédié', 'maintenance serveur', 'autonomie client', 'cms intuitif', 'verviers', 'création de site internet', 'développement e-commerce', 'hébergement web', 'maintenance it']::text[], ARRAY['Création de site internet', 'Développement e-commerce', 'Hébergement web', 'Maintenance it', 'Référencement naturel']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Chaussée de Heusy 225', 'https://www.imust.be/', NULL, NULL, NULL, NULL, 'bruno@imust.be', NULL, NULL, NULL, NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de création de site internet?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Verviers et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'Something about RESPONSIVE is happening... est une agence web verviétoise spécialisée dans la création de sites internet adaptés aux mobiles et tablettes. Leur expertise couvre les CMS, l''e-commerce et l''hébergement sécurisé avec serveurs dédiés. L''entreprise met un point d''honneur à rendre ses clients autonomes grâce à des interfaces intuitives.', 'Création site internet à Verviers | Something about RESPONSIVE is happening ...', 'Formation gratuite pour gérer votre site après livraison. Sauvegardes automatiques quotidiennes. Expertise locale en responsive design et e-commerce.', 'Création de sites internet à Verviers', 'Agence spécialisée dans la création de sites web responsives, avec formation client pour une autonomie totale. Hébergement sécurisé inclus.', '{"@context":"https://schema.org","@type":"WebDesign","name":"Something about RESPONSIVE is happening ...","description":"Création de sites internet responsives avec formation client et hébergement sécurisé.","url":"https://revelys.be/entreprises/creation-de-site-internet-verviers-something-about-responsive-is-happening","sameAs":["https://www.imust.be/"],"address":{"@type":"PostalAddress","streetAddress":"Chaussée de Heusy 225","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["responsive design","mobile first","e-commerce","hébergement dédié","maintenance serveur","autonomie client","cms intuitif","verviers","création de site internet","développement e-commerce","hébergement web","maintenance it"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/logo.webp"}'::jsonb, '2026-02-27T00:39:38.135Z', TRUE, 5, '99098acab2e1d03e5fdf0b24c2f943d59308c7d2f53e6ed773e6771908893c66', 'Something about RESPONSIVE is happening... se distingue par son approche pédagogique qui permet aux clients de gérer eux-mêmes leur site après livraison, combinée à une infrastructure technique robuste.', NULL, 'Clarté', '[{"name":"Test multi-écrans systématique","description":"Chaque site est vérifié sur différents appareils (smartphones, tablettes, ordinateurs) avant mise en ligne pour garantir un affichage optimal.","frequency":"100","impact":"100","proof":null},{"name":"Formation à l''administration du site","description":"Une session de prise en main est systématiquement organisée avec le client pour lui montrer comment modifier son contenu via l''interface CMS.","frequency":"100","impact":"100","proof":null},{"name":"Sauvegarde automatique des données","description":"Les sites hébergés bénéficient de sauvegardes quotidiennes automatiques stockées sur des serveurs sécurisés.","frequency":"100","impact":"100","proof":null}]'::jsonb, 96, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T00:40:27.566Z","proof":"https://www.imust.be/www/"},{"label":"Seed: city hint","date":"2026-02-27T00:40:27.566Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T00:40:27.566Z","proof":"Agence web"},{"label":"Seed: search keyword","date":"2026-02-27T00:40:27.566Z","proof":"création de site internet"},{"label":"Extracted: city","date":"2026-02-27T00:40:27.566Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T00:40:27.566Z","proof":"0872985944"},{"label":"Email extracted","date":"2026-02-27T00:40:27.566Z","proof":"bruno@imust.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T00:40:27.566Z","proof":"confidence=98/100"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T00:40:27.566Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-something-about-responsive-is-happening/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0872985944', 'Actif', 'BCE_CSV', '2026-02-27T00:37:26.433Z', '2026-02-27T00:37:26.433Z', 'IMUSTBE', '2005-04-06', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T00:40:27.566Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0872985944'
    AND c_existing.slug <> 'creation-de-site-internet-verviers-something-about-responsive-is-happening'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'agence-web-verviers-upstand', 'BE-WAL', 'UPSTAND', 'Agence web', ARRAY['site web professionnel', 'startup digitale', 'optimisation seo', 'boutique en ligne', 'design conversion', 'agence locale verviers', 'accompagnement personnalisé', 'sans frais cachés', 'création de site vitrine', 'développement de boutique en ligne', 'design graphique sur mesure']::text[], ARRAY['Création de site vitrine', 'Développement de boutique en ligne', 'Design graphique sur mesure']::text[], 'sur_devis', NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue de Chestret 23, 4000 Liège, Wallonia, BE', 'https://www.upstand.be/', NULL, 'http://instagram.com/upstand.be', 'https://www.linkedin.com/company/upstand-agence-web', NULL, 'hello@upstand.be', NULL, '+32451034077', '+32451034077', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de création de site vitrine?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Gérez-vous les interventions urgentes?","answer":"Oui, l''organisation permet de répondre aux demandes urgentes (24h/24 - 7j/7)."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"UPSTAND se distingue par son approche sur-mesure et sa promesse de sites web conçus pour convertir, sans complications ni retards. L''agence met un point d''honneur à accompagner ses clients avec des solutions claires et adaptées à leurs besoins spécifiques."}]'::jsonb, 'UPSTAND est une agence web basée à Verviers, spécialisée dans la création de sites internet performants pour startups et PME. L''équipe accompagne ses clients de la conception à l''optimisation SEO, en passant par le design sur mesure et la gestion des boutiques en ligne. Chaque projet est pensé pour convertir les visiteurs en clients, avec un suivi rapide et personnalisé.', 'Agence web à Verviers | UPSTAND', 'Création de sites vitrine et boutiques en ligne optimisés pour le référencement. Approche sur-mesure avec prototypage interactif avant développement.', 'UPSTAND - Agence web à Verviers', 'Agence spécialisée dans la création de sites web professionnels et boutiques en ligne, basée à Verviers. Audit SEO initial inclus pour optimiser votre visibilité.', '{"@context":"https://schema.org","@type":"WebDesign","name":"UPSTAND","description":"Agence web spécialisée dans la création de sites vitrine et boutiques en ligne à Verviers.","url":"https://revelys.be/entreprises/agence-web-verviers-upstand","sameAs":["https://www.upstand.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue de Chestret 23","postalCode":"4800","addressLocality":"Verviers","addressRegion":"Wallonia","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["site web professionnel","startup digitale","optimisation seo","boutique en ligne","design conversion","agence locale verviers","accompagnement personnalisé","sans frais cachés","création de site vitrine","développement de boutique en ligne","design graphique sur mesure"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","itemListElement":[{"@type":"OfferItem","name":"Création de site vitrine"},{"@type":"OfferItem","name":"Développement de boutique en ligne"},{"@type":"OfferItem","name":"Design graphique sur mesure"}]}}'::jsonb, '2026-02-27T00:49:30.574Z', TRUE, 5, 'c4b9c2c55e70b7c687948ade040b8dd819e3c0d03d3a74e4e8f23ea3eb75a408', 'UPSTAND se distingue par son approche sur-mesure et sa promesse de sites web conçus pour convertir, sans complications ni retards. L''agence met un point d''honneur à accompagner ses clients avec des solutions claires et adaptées à leurs besoins spécifiques.', NULL, 'Joie', '[{"name":"Audit SEO initial","description":"Avant toute création de site, UPSTAND réalise un audit complet pour identifier les mots-clés stratégiques et optimiser la structure du site dès le départ","frequency":"1 fois par projet","impact":"Améliore le référencement naturel et la visibilité en ligne.","proof":null},{"name":"Prototypage interactif","description":"L''agence crée des maquettes cliquables pour valider l''expérience utilisateur avant le développement final","frequency":"1 fois par projet","impact":"Permet d''ajuster l''interface en fonction des retours clients.","proof":null},{"name":"Suivi post-lancement","description":"Après la mise en ligne, UPSTAND propose un suivi régulier pour analyser les performances et apporter des améliorations","frequency":"Mensuel ou trimestriel selon le contrat","impact":"Garantit une optimisation continue du site.","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T00:50:33.912Z","proof":"https://www.upstand.be/service/agence-web-verviers"},{"label":"Seed: city hint","date":"2026-02-27T00:50:33.912Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T00:50:33.912Z","proof":"Agence web"},{"label":"Seed: search keyword","date":"2026-02-27T00:50:33.912Z","proof":"Agence web"},{"label":"Extracted: city","date":"2026-02-27T00:50:33.912Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T00:50:33.912Z","proof":"1028290367"},{"label":"Email extracted","date":"2026-02-27T00:50:33.912Z","proof":"hello@upstand.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T00:50:33.912Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T00:50:33.912Z","proof":"source=jsonld"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T00:50:33.912Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/agence-web-verviers-upstand/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE1028290367', 'Actif', 'BCE_CSV', '2026-02-27T00:44:45.828Z', '2026-02-27T00:44:45.828Z', 'Ezzanzouni Essakyati, Mohamed', '2025-09-29', 'Personne physique', NULL, 'Situation normale', '2026-02-11', '2026-02-27T00:50:33.912Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE1028290367'
    AND c_existing.slug <> 'agence-web-verviers-upstand'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'creation-de-site-internet-verviers-esi-informatique', 'BE-WAL', 'ESI Informatique', 'Agence web', ARRAY['site internet professionnel', 'e-commerce personnalisé', 'hébergement sécurisé', 'design graphique moderne', 'stratégie digitale', 'wallonie', 'entreprise locale', 'création de site web', 'développement d’applications', 'hébergement web', 'graphic design', 'marketing digital']::text[], ARRAY['Création de site web', 'Développement d’applications', 'Hébergement web', 'Graphic design', 'Marketing digital']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Chaussée de Heusy 225', 'https://www.esi-informatique.com/', 'https://www.facebook.com/ESI.Informatique/?locale=fr_FR', 'https://www.instagram.com/esi_informatique/', 'https://www.linkedin.com/company/esi-informatique-sprl/posts/?feedView=all', NULL, 'web@esi-informatique.com', NULL, '+3287226060', '+3287226060', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], 'Du lundi au vendredi', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de création de site web?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Verviers et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'ESI Informatique est une agence web spécialisée dans la création de sites internet sur mesure à Verviers. L''entreprise propose des solutions digitales complètes, du développement applicatif à l''hébergement sécurisé, en passant par le design graphique et le marketing digital. Avec plus de 38 ans d''expérience, ESI Informatique accompagne les entreprises dans leur transformation numérique.', 'Création site web à Verviers | ESI Informatique', 'Audit technique gratuit pour optimiser votre présence en ligne. Solutions digitales sur mesure pour les entreprises wallonnes, avec prototypage interactif.', 'ESI Informatique - Création de sites web à Verviers', 'Agence spécialisée dans la création de sites internet professionnels et le développement d''applications. Basée à Verviers en Wallonie.', '{"@context":"https://schema.org","@type":"WebDesign","name":"ESI Informatique","description":"Création de sites web professionnels et développement d''applications sur mesure.","url":"https://revelys.be/entreprises/creation-de-site-internet-verviers-esi-informatique","sameAs":["https://www.esi-informatique.com/"],"address":{"@type":"PostalAddress","streetAddress":"Chaussée de Heusy 225","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"Place","name":"Wallonie"},"keywords":["site internet professionnel","e-commerce personnalisé","hébergement sécurisé","design graphique moderne","stratégie digitale","wallonie","entreprise locale","création de site web","développement d’applications","hébergement web","graphic design","marketing digital"],"image":[{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/logo.webp"}],"logo":{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/logo.webp"}}'::jsonb, '2026-02-27T00:56:05.540Z', TRUE, 5, 'ad32e04d1603fe91278e7e273834a127e424d17a4021773692a55f3accef7776', 'Chez ESI Informatique, chaque projet est unique. Nous prenons le temps de comprendre vos besoins pour proposer des solutions digitales sur mesure qui répondent précisément à vos objectifs.', NULL, 'Joie', '[{"name":"Audit technique préalable","description":"Avant toute création ou développement, nous réalisons un audit complet de votre environnement existant pour identifier les points d''amélioration et proposer une solution optimale.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Prototypage interactif","description":"Nous créons des maquettes fonctionnelles pour vous permettre de visualiser et d''interagir avec votre futur site ou application avant le développement final.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Tests utilisateurs","description":"Nous organisons des sessions de tests avec vos futurs utilisateurs pour valider l''ergonomie et la pertinence des fonctionnalités proposées.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T00:56:55.540Z","proof":"https://www.esi-informatique.com/"},{"label":"Seed: city hint","date":"2026-02-27T00:56:55.540Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T00:56:55.540Z","proof":"Agence web"},{"label":"Seed: search keyword","date":"2026-02-27T00:56:55.540Z","proof":"création de site internet"},{"label":"Extracted: city","date":"2026-02-27T00:56:55.540Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T00:56:55.540Z","proof":"0431066713"},{"label":"Email extracted","date":"2026-02-27T00:56:55.540Z","proof":"web@esi-informatique.com"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T00:56:55.540Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T00:56:55.540Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T00:56:55.540Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/creation-de-site-internet-verviers-esi-informatique/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0431066713', 'Actif', 'BCE_CSV', '2026-02-27T00:53:08.136Z', '2026-02-27T00:53:08.136Z', 'E.S.I. INFORMATIQUE', '1987-05-14', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T00:56:55.540Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0431066713'
    AND c_existing.slug <> 'creation-de-site-internet-verviers-esi-informatique'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'graphiste-verviers-coonen', 'BE-WAL', 'Coonen', 'Graphiste', ARRAY['supports graphiques sur mesure', 'sérigraphie industrielle', 'anodisation aluminium', 'impression digitale haute qualité', 'certification iso 9001', 'projets personnalisés', 'signalétique d''entreprise', 'affichage publicitaire', '50 ans d''expérience', 'anodisation', 'autocollants', 'panneaux']::text[], ARRAY['Anodisation', 'Autocollants', 'Panneaux', 'Lettrage', 'Bâches', 'Expo & déco']::text[], 'sur_devis', NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue de Gelée 16', 'https://www.coonen.net/', 'https://www.facebook.com/CoonenGraphicsbe', NULL, 'https://www.linkedin.com/company/coonen-graphics/', NULL, 'y.leigsnering@coonen.net', NULL, '+3287338944', '+3287338944', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, '[{"day":"lundi","open":"07:30","close":"12:30","isClosed":false},{"day":"mardi","open":"07:30","close":"12:30","isClosed":false},{"day":"mercredi","open":"07:30","close":"12:30","isClosed":false},{"day":"jeudi","open":"07:30","close":"12:30","isClosed":false},{"day":"vendredi","open":"07:30","close":"12:30","isClosed":false}]'::jsonb, NULL, NULL, NULL, '[{"question":"Proposez-vous des services d''anodisation?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Coonen se distingue par son approche sur mesure et sa maîtrise de technologies variées pour créer des supports graphiques durables. L''équipe polyvalente accompagne chaque projet avec expertise depuis plus de cinq décennies."}]'::jsonb, 'Coonen est un graphiste spécialisé à Verviers, alliant innovation et polyvalence depuis plus de 50 ans. Son équipe d''une vingtaine de professionnels maîtrise la sérigraphie, l''impression digitale et l''anodisation pour créer des supports graphiques sur mesure. La certification ISO 9001 garantit une qualité irréprochable dans chaque projet.', 'Graphiste à Verviers | Coonen', 'Supports graphiques sur mesure avec certification ISO 9001. 50 ans d''expérience en sérigraphie et anodisation pour entreprises locales.', 'Coonen - Graphiste professionnel à Verviers', 'Création de supports graphiques personnalisés : autocollants, panneaux, signalétique. Expertise en impression digitale et traitement aluminium.', '{"@context":"https://schema.org","@type":"GraphicDesignBusiness","name":"Coonen","description":"Graphiste spécialisé dans les supports sur mesure à Verviers","url":"https://revelys.be/entreprises/graphiste-verviers-coonen","sameAs":["https://www.coonen.net/"],"address":{"@type":"PostalAddress","streetAddress":"Rue de Gelée 16","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":"Verviers","keywords":["supports graphiques sur mesure","sérigraphie industrielle","anodisation aluminium","impression digitale haute qualité","certification iso 9001","projets personnalisés","signalétique d''entreprise","affichage publicitaire","50 ans d''expérience","anodisation","autocollants","panneaux"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/logo.webp","service":[{"@type":"Service","name":"Anodisation"},{"@type":"Service","name":"Autocollants"},{"@type":"Service","name":"Panneaux"},{"@type":"Service","name":"Lettrage"},{"@type":"Service","name":"Bâches"},{"@type":"Service","name":"Expo & déco"}]}'::jsonb, '2026-02-27T01:37:44.611Z', TRUE, 5, 'edfa00e50cb50d574b9b3c43813043636f7bb404ad4d5166d2604f5e3f94ac11', 'Coonen se distingue par son approche sur mesure et sa maîtrise de technologies variées pour créer des supports graphiques durables. L''équipe polyvalente accompagne chaque projet avec expertise depuis plus de cinq décennies.', NULL, 'Clarté', '[{"name":"Test de résistance des autocollants","description":"Chaque autocollant est soumis à un test de pelage et d''adhérence pour garantir sa durabilité dans le temps, même en conditions extrêmes.","frequency":"tous les projets","impact":"qualité","proof":null},{"name":"Validation des couleurs avant impression","description":"Un contrôle rigoureux du rendu chromatique est effectué sur chaque support pour s''assurer de la fidélité à la demande client.","frequency":"tous les projets","impact":"qualité","proof":null},{"name":"Nettoyage des plaques avant anodisation","description":"Un protocole de nettoyage spécifique est appliqué pour éliminer toute impureté avant le traitement d''anodisation, garantissant un résultat optimal.","frequency":"tous les projets","impact":"qualité","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T01:38:44.107Z","proof":"https://www.coonen.net/"},{"label":"Seed: city hint","date":"2026-02-27T01:38:44.107Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T01:38:44.107Z","proof":"Graphiste"},{"label":"Seed: search keyword","date":"2026-02-27T01:38:44.107Z","proof":"Graphiste"},{"label":"Extracted: city","date":"2026-02-27T01:38:44.107Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T01:38:44.107Z","proof":"0458191079"},{"label":"Email extracted","date":"2026-02-27T01:38:44.107Z","proof":"y.leigsnering@coonen.net"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T01:38:44.107Z","proof":"confidence=92/100"},{"label":"BCE recovered from local identity","date":"2026-02-27T01:38:44.107Z","proof":"score=105"},{"label":"Phone extracted","date":"2026-02-27T01:38:44.107Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T01:38:44.107Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/graphiste-verviers-coonen/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0458191079', 'Actif', 'BCE_CSV', '2026-02-27T01:33:50.543Z', '2026-02-27T01:33:50.543Z', 'COONEN GRAPHICS', '1996-06-07', 'Personne morale', 'Société anonyme', 'Situation normale', '2026-02-11', '2026-02-27T01:38:44.107Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0458191079'
    AND c_existing.slug <> 'graphiste-verviers-coonen'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'branding-verviers-debry-coverpaint', 'BE-WAL', 'Debry Coverpaint', 'Graphiste', ARRAY['conseil personnalisé peinture', 'revêtement sol durable', 'stores sur mesure', 'papier peint tendance', 'outillage professionnel', 'projet intérieur extérieur', 'dépannage urgent', 'showroom verviers', 'peinture murale', 'revêtements de sol', 'stores et tentures', 'papier peint']::text[], ARRAY['Peinture murale', 'Revêtements de sol', 'Stores et tentures', 'Papier peint', 'Outillage professionnel']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue de Battice 84', 'https://debry.be/', 'https://www.facebook.com/debrycoverpaint', 'https://www.instagram.com/debry.coverpaint', NULL, NULL, 'info@debry.be', NULL, '+3287331106', '+3287331106', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de peinture murale?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Verviers et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'Debry Coverpaint est un spécialiste de la peinture et des revêtements à Verviers, alliant expertise technique et conseil personnalisé pour particuliers et professionnels. Leur showroom de 750 m² propose une large gamme de produits haut de gamme, avec une attention particulière portée aux solutions durables et esthétiques.', 'Branding à Verviers | Debry Coverpaint', 'Conseil personnalisé pour peinture murale et revêtements de sol durables. Showroom à Verviers avec démonstrations produits. Expertise locale depuis plusieurs générations.', 'Debry Coverpaint - Solutions de branding à Verviers', 'Entreprise familiale spécialisée en peinture, revêtements de sol et stores sur mesure. Accompagnement complet pour vos projets intérieurs et extérieurs à Verviers.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"Debry Coverpaint","description":"Spécialiste en branding avec showroom à Verviers. Solutions sur mesure pour peinture, revêtements et stores.","url":"https://revelys.be/entreprises/branding-verviers-debry-coverpaint","sameAs":["https://debry.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue de Battice 84","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":"Verviers","keywords":["conseil personnalisé peinture","revêtement sol durable","stores sur mesure","papier peint tendance","outillage professionnel","projet intérieur extérieur","dépannage urgent","showroom verviers","peinture murale","revêtements de sol","stores et tentures","papier peint"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/cover.webp"],"hasOfferCatalog":{"@type":"OfferCatalog","name":"Services Debry Coverpaint","itemListElement":[{"@type":"Offer","name":"Peinture murale","url":"https://debry.be/"},{"@type":"Offer","name":"Revêtements de sol","url":"https://debry.be/"},{"@type":"Offer","name":"Stores et tentures","url":"https://debry.be/"},{"@type":"Offer","name":"Papier peint","url":"https://debry.be/"},{"@type":"Offer","name":"Outillage professionnel","url":"https://debry.be/"}]}}'::jsonb, '2026-02-27T01:53:41.086Z', TRUE, 5, 'fecae760b1b9e17f2b7a8b5c45921875886540a5d9a4296969074e411bcfcc2d', 'Chez Debry Coverpaint, nous combinons savoir-faire familial et innovation pour transformer vos espaces avec des solutions sur mesure. Notre équipe vous accompagne de l''idée à la réalisation.', NULL, 'Proximité', '[{"name":"Analyse technique en magasin","description":"Nos conseillers réalisent une première analyse technique dès votre arrivée pour identifier précisément vos besoins et vous proposer les meilleures solutions.","frequency":"toujours","impact":"qualite","proof":null},{"name":"Démonstration des produits","description":"Nous présentons concrètement les textures, couleurs et finitions pour vous aider à faire un choix éclairé.","frequency":"toujours","impact":"qualite","proof":null},{"name":"Conseil couleur et texture","description":"Nos experts en décoration vous guident dans le choix des harmonies de couleurs et des matières pour un résultat cohérent.","frequency":"toujours","impact":"qualite","proof":null},{"name":"Service dépannage urgent","description":"Nous proposons une assistance rapide pour les professionnels du bâtiment confrontés à des problèmes techniques imprévus.","frequency":"occasionnel","impact":"satisfaction client","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T01:54:46.873Z","proof":"https://debry.be/"},{"label":"Seed: city hint","date":"2026-02-27T01:54:46.873Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T01:54:46.873Z","proof":"Graphiste"},{"label":"Seed: search keyword","date":"2026-02-27T01:54:46.873Z","proof":"branding"},{"label":"Extracted: city","date":"2026-02-27T01:54:46.873Z","proof":""},{"label":"BCE: mod97 valid","date":"2026-02-27T01:54:46.873Z","proof":"0440712075"},{"label":"Email extracted","date":"2026-02-27T01:54:46.873Z","proof":"info@debry.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T01:54:46.873Z","proof":"confidence=80/100"},{"label":"BCE recovered from local identity","date":"2026-02-27T01:54:46.873Z","proof":"score=60"},{"label":"Phone extracted","date":"2026-02-27T01:54:46.873Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T01:54:46.873Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/branding-verviers-debry-coverpaint/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0440712075', 'Actif', 'BCE_CSV', '2026-02-27T01:48:46.989Z', '2026-02-27T01:48:46.989Z', 'DEBRY - COVERPAINT', '1990-06-05', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T01:54:46.873Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0440712075'
    AND c_existing.slug <> 'branding-verviers-debry-coverpaint'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'automatisation-verviers-idautomation', 'BE-WAL', 'Idautomation', 'Développeur', ARRAY['automatisation industrielle', 'programmation plc', 'électrification usine', 'rétrofit machine', 'industrie alimentaire', 'traitement des eaux', 'système scada', 'longue durée', 'programmation d''automates industriels', 'conception d''armoires électriques', 'electrification de sites industriels', 'rétrofit d''installations existantes']::text[], ARRAY['Programmation d''automates industriels', 'Conception d''armoires électriques', 'Electrification de sites industriels', 'Rétrofit d''installations existantes']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue Jean Koch 16', 'https://www.idautomation.be/', 'https://www.facebook.com/idautomation.be/', NULL, 'https://www.linkedin.com/company/id-automation/', NULL, 'info@idautomation.be', NULL, '+3287312114', '+3287312114', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de programmation d''automates industriels?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"La qualité est suivie via vérification systématique des circuits avant mise en service pour garantir la sécurité et le bon fonctionnement."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"IdAutomation se distingue par son approche sur mesure, combinant expertise technique et réactivité pour des solutions industrielles durables."}]'::jsonb, 'IdAutomation conçoit et déploie des solutions d''automatisation industrielle sur mesure pour optimiser les processus de production. Spécialisée dans la programmation PLC, SCADA et l''électrification, cette entreprise basée à Verviers accompagne des secteurs variés comme le traitement des eaux ou l''industrie alimentaire.', 'Automatisation industrielle à Verviers | Idautomation', 'Solutions d''automatisation sur mesure pour l''industrie alimentaire et le traitement des eaux. Expertise locale en électrification de sites industriels.', 'Idautomation - Automatisation industrielle à Verviers', 'Entreprise spécialisée dans la programmation d''automates, la conception d''armoires électriques et l''électrification de sites industriels. Basée à Verviers.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"Idautomation","description":"Automatisation industrielle, électrification et retrofit d''installations.","url":"https://revelys.be/entreprises/automatisation-verviers-idautomation","sameAs":["https://www.idautomation.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue Jean Koch 16","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"Place","name":"Verviers"},"keywords":["automatisation industrielle","programmation plc","électrification usine","rétrofit machine","industrie alimentaire","traitement des eaux","système scada","longue durée","programmation d''automates industriels","conception d''armoires électriques","electrification de sites industriels","rétrofit d''installations existantes"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/logo.webp"}'::jsonb, '2026-02-27T02:02:46.743Z', TRUE, 5, '07980ecfc1eee810a5d537c9be6cbb00a24781d66502222cf651f44b733cb0cb', 'IdAutomation se distingue par son approche sur mesure, combinant expertise technique et réactivité pour des solutions industrielles durables.', NULL, 'Sécurité', '[{"name":"Test de pression sur armoire électrique","description":"Vérification systématique des circuits avant mise en service pour garantir la sécurité et le bon fonctionnement.","frequency":"100","impact":"50","proof":null},{"name":"Documentation technique détaillée","description":"Création de schémas électriques complets et de manuels d''utilisation pour chaque projet livré.","frequency":"100","impact":"50","proof":null},{"name":"Mise en service avec client","description":"Formation des équipes sur place lors du démarrage des installations automatisées.","frequency":"100","impact":"50","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T02:03:34.973Z","proof":"https://www.idautomation.be/"},{"label":"Seed: city hint","date":"2026-02-27T02:03:34.973Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T02:03:34.973Z","proof":"Développeur"},{"label":"Seed: search keyword","date":"2026-02-27T02:03:34.973Z","proof":"automatisation"},{"label":"Extracted: city","date":"2026-02-27T02:03:34.973Z","proof":""},{"label":"BCE: mod97 valid","date":"2026-02-27T02:03:34.973Z","proof":"0877697471"},{"label":"Email extracted","date":"2026-02-27T02:03:34.973Z","proof":"info@idautomation.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T02:03:34.973Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T02:03:34.973Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T02:03:34.973Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/automatisation-verviers-idautomation/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0877697471', 'Actif', 'BCE_CSV', '2026-02-27T01:58:22.453Z', '2026-02-27T01:58:22.453Z', 'IDAUTOMATION', '2005-12-05', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T02:03:34.973Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0877697471'
    AND c_existing.slug <> 'automatisation-verviers-idautomation'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'developpeur-automatisation-verviers-isis-informatique', 'BE-WAL', 'Isis Informatique', 'Développeur', ARRAY['logiciel entreprise', 'erp personnalisé', 'technologie 4d', 'facture électronique', 'solution métier unique', 'développement web mobile', 'optimisation processus', 'peppol belgique', 'application sur mesure', 'développement sur mesure', 'logiciel de gestion', 'distribution 4d']::text[], ARRAY['Développement sur mesure', 'Logiciel de gestion', 'Distribution 4d', 'Facturation électronique peppol']::text[], 'sur_devis', NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue des Déportés 120', 'https://www.isis.be/', 'https://www.facebook.com/ISIS.VERVIERS', NULL, 'https://www.linkedin.com/company/isis-sa', NULL, 'infonl@isis.be', NULL, '+3287230690', '+3287230690', NULL, NULL, NULL, 'Verviers', ARRAY['français', 'néerlandais']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de développement sur mesure?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Chez Isis Informatique, chaque projet est abordé comme un cas unique. Notre approche combine l''analyse terrain de vos besoins avec une expertise technique pluridisciplinaire pour créer des solutions qui s''adaptent à votre croissance."}]'::jsonb, 'Isis Informatique, spécialiste du développement informatique à Verviers depuis 1987, conçoit des solutions logicielles sur mesure pour optimiser vos processus métiers. Son expertise couvre l''intégration d''ERP comme EQUISIS et le développement d''applications spécifiques en technologies variées (4D, web, mobile).', 'Développeur automatisation à Verviers | Isis Informatique', 'Solutions logicielles sur mesure pour optimiser vos processus métiers. Expertise en technologie 4D et facturation électronique PEPPOL, adaptée aux entreprises belges.', 'Isis Informatique - Développeur automatisation à Verviers', 'Création de logiciels sur mesure pour l''automatisation des processus métiers. Analyse terrain et prototypage fonctionnel pour une solution parfaitement adaptée.', '{"@context":"https://schema.org","@type":"SoftwareCompany","name":"Isis Informatique","description":"Développeur automatisation spécialisé en solutions logicielles sur mesure et technologie 4D.","url":"https://revelys.be/entreprises/developpeur-automatisation-verviers-isis-informatique","sameAs":["https://www.isis.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue des Déportés 120","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["logiciel entreprise","erp personnalisé","technologie 4d","facture électronique","solution métier unique","développement web mobile","optimisation processus","peppol belgique","application sur mesure","développement sur mesure","logiciel de gestion","distribution 4d"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/logo.webp"}'::jsonb, '2026-02-27T02:13:50.390Z', TRUE, 5, 'ecabf1ecf0d5dddbe0a2c2dbbd6a50d93f00c84dea4edc22a69599c60fa35a9a', 'Chez Isis Informatique, chaque projet est abordé comme un cas unique. Notre approche combine l''analyse terrain de vos besoins avec une expertise technique pluridisciplinaire pour créer des solutions qui s''adaptent à votre croissance.', NULL, 'Accompagnement', '[{"name":"Analyse terrain des processus","description":"Un consultant spécialisé se rend sur site pour observer et documenter les flux métiers existants avant toute proposition technique.","frequency":"100%","impact":"Garantit une solution parfaitement adaptée aux besoins réels de l''entreprise","proof":null},{"name":"Prototypage fonctionnel","description":"Création d''une maquette interactive des principales fonctionnalités pour validation client avant développement complet.","frequency":"90%","impact":"Réduit les risques de malentendus et permet des ajustements précoces","proof":null},{"name":"Tests utilisateurs en conditions réelles","description":"Mise à disposition d''une version bêta aux équipes opérationnelles pour validation pratique avant déploiement final.","frequency":"85%","impact":"Assure l''appropriation par les utilisateurs finaux et identifie les derniers ajustements nécessaires","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T02:14:34.112Z","proof":"https://www.isis.be/developpement-sur-mesure/"},{"label":"Seed: city hint","date":"2026-02-27T02:14:34.112Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T02:14:34.112Z","proof":"Développeur"},{"label":"Seed: search keyword","date":"2026-02-27T02:14:34.112Z","proof":"Développeur automatisation"},{"label":"Extracted: city","date":"2026-02-27T02:14:34.112Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T02:14:34.112Z","proof":"0431755611"},{"label":"Email extracted","date":"2026-02-27T02:14:34.112Z","proof":"infonl@isis.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T02:14:34.112Z","proof":"confidence=92/100"},{"label":"Phone extracted","date":"2026-02-27T02:14:34.112Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T02:14:34.112Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/developpeur-automatisation-verviers-isis-informatique/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0431755611', 'Actif', 'BCE_CSV', '2026-02-27T02:08:40.479Z', '2026-02-27T02:08:40.479Z', 'INTEGRATED SERVICES FOR INFORMATION SYSTEMS', '1987-08-28', 'Personne morale', 'Société anonyme', 'Situation normale', '2026-02-11', '2026-02-27T02:14:34.112Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0431755611'
    AND c_existing.slug <> 'developpeur-automatisation-verviers-isis-informatique'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'gestion-reseaux-sociaux-verviers-compourvous', 'BE-WAL', '.compourvous', 'Gestion Réseaux sociaux', ARRAY['formation réseaux sociaux', 'gestion de communauté', 'contenu pro', 'shooting entreprise', 'stratégie digitale', 'verviers', 'formation aux réseaux sociaux', 'gestion de comptes médias', 'shooting photo vidéo professionnel']::text[], ARRAY['Formation aux réseaux sociaux', 'Gestion de comptes médias', 'Shooting photo vidéo professionnel']::text[], 'sur_devis', NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue des Raines 94 boite 1', 'https://www.compourvous.be/', 'http://facebook.com/compourvous.be', 'http://instagram.com/compourvous.be', 'https://www.linkedin.com/company/-compourvous/', 'https://www.tiktok.com/@compourvousbe', 'contact@fiscassur.be', NULL, '+32489215582', '+32489215582', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de formation aux réseaux sociaux?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":".compourvous se distingue par son approche sur mesure, combinant expertise technique et créativité pour des résultats concrets. Leur suivi post-formation garantit une mise en pratique réussie."}]'::jsonb, '.compourvous, basée à Verviers, accompagne les entreprises dans leur stratégie de réseaux sociaux avec des formations personnalisées et une gestion complète de leurs comptes. Leur équipe crée du contenu impactant pour renforcer votre visibilité en ligne.', 'Gestion réseaux sociaux à Verviers | .compourvous', 'Audit et création de contenu pro pour booster votre présence digitale. Shooting photo/vidéo sur site inclus. Expertise locale à Verviers.', 'Gestion de réseaux sociaux - Verviers', 'Formation, gestion de communauté et shooting professionnel pour entreprises. Approche personnalisée avec suivi post-formation.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":".compourvous","description":"Gestion de réseaux sociaux, formation et création de contenu professionnel à Verviers.","url":"https://revelys.be/entreprises/gestion-reseaux-sociaux-verviers-compourvous","sameAs":["https://www.compourvous.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue des Raines 94 boite 1","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["formation réseaux sociaux","gestion de communauté","contenu pro","shooting entreprise","stratégie digitale","verviers","formation aux réseaux sociaux","gestion de comptes médias","shooting photo vidéo professionnel"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/cover.webp"],"hasOfferCatalog":{"@type":"OfferCatalog","name":"Services","itemListElement":[{"@type":"Offer","name":"Formation aux réseaux sociaux"},{"@type":"Offer","name":"Gestion de comptes médias"},{"@type":"Offer","name":"Shooting photo vidéo professionnel"}]}}'::jsonb, '2026-02-27T02:24:30.383Z', TRUE, 5, '1d20c5580756b4f5a6ff09427d9e90e5971ddaec34b659109c3d9825a4ec07af', '.compourvous se distingue par son approche sur mesure, combinant expertise technique et créativité pour des résultats concrets. Leur suivi post-formation garantit une mise en pratique réussie.', NULL, 'Confiance', '[{"name":"Audit initial des comptes","description":"Analyse approfondie des réseaux sociaux existants pour identifier les axes d''amélioration et définir un plan éditorial adapté.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Création de contenu personnalisé","description":"Rédaction de textes créatifs et sélection d''images/vidéos professionnelles pour refléter l''identité de l''entreprise.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Shooting photo/vidéo sur site","description":"Prise de vue en entreprise avec un matériel professionnel pour des visuels cohérents et esthétiques.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Suivi post-formation mensuel","description":"Accompagnement pendant un mois après la formation pour s''assurer de l''application des bonnes pratiques.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T02:25:25.092Z","proof":"https://www.compourvous.be/"},{"label":"Seed: city hint","date":"2026-02-27T02:25:25.092Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T02:25:25.092Z","proof":"Gestion Réseaux sociaux"},{"label":"Seed: search keyword","date":"2026-02-27T02:25:25.092Z","proof":"Gestion Réseaux sociaux"},{"label":"Extracted: city","date":"2026-02-27T02:25:25.092Z","proof":""},{"label":"BCE: mod97 valid","date":"2026-02-27T02:25:25.092Z","proof":"1012992576"},{"label":"Email extracted","date":"2026-02-27T02:25:25.092Z","proof":"contact@fiscassur.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T02:25:25.092Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T02:25:25.092Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T02:25:25.092Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/gestion-reseaux-sociaux-verviers-compourvous/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE1012992576', 'Actif', 'BCE_CSV', '2026-02-27T02:22:00.029Z', '2026-02-27T02:22:00.029Z', 'CPV', '2024-08-30', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T02:25:25.092Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE1012992576'
    AND c_existing.slug <> 'gestion-reseaux-sociaux-verviers-compourvous'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coiffeur-verviers-xyz', 'BE-WAL', 'XYZ', 'Coiffeur', ARRAY['coiffure personnalisée', 'coloration professionnelle', 'soins capillaires', 'stylisme événementiel', 'réduction fidélité', 'formation continue', 'tendances coiffure', 'coupe de cheveux', 'coloration', 'soin du cheveu', 'coiffure événementielle', 'styling sur mesure']::text[], ARRAY['Coupe de cheveux', 'Coloration', 'Soin du cheveu', 'Coiffure événementielle', 'Styling sur mesure']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Avenue de Spa 15', 'https://www.xyz.be/', 'https://www.facebook.com/XYZCoiffeurCreateur/', 'https://www.instagram.com/xyzcoiffeurcreateur/', NULL, 'https://www.tiktok.com/@heusy', 'ottignies@xyz.be', NULL, '+3287223080', '+3287223080', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coupe de cheveux?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Verviers et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'XYZ Verviers-Heusy, salon de coiffure à Verviers, allie expertise et personnalisation pour des coupes et colorations sur mesure. L''équipe formée aux dernières tendances vous écoute pour créer le look qui vous ressemble. Profitez d''une réduction de 20% avec la Carte Family20.', 'Coiffeur à Verviers | XYZ', 'Coloration professionnelle et soins capillaires sur mesure. Consultation personnalisée pour un résultat unique adapté à votre style. Salon situé Avenue de Spa, Verviers.', 'Salon de coiffure XYZ - Coiffeur à Verviers', 'Coiffeur à Verviers proposant des services sur mesure : coloration professionnelle, soins capillaires et stylisme événementiel. Chaque client bénéficie d''une consultation personnalisée.', '{"@context":"https://schema.org","@type":"HairSalon","name":"XYZ","description":"Coiffeur à Verviers proposant des services sur mesure et une approche artistique pour des coiffures uniques.","url":"https://revelys.be/entreprises/coiffeur-verviers-xyz","sameAs":["https://www.xyz.be/"],"address":{"@type":"PostalAddress","streetAddress":"Avenue de Spa 15","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":"Verviers","keywords":["coiffure personnalisée","coloration professionnelle","soins capillaires","stylisme événementiel","réduction fidélité","formation continue","tendances coiffure","coupe de cheveux","coloration","soin du cheveu","coiffure événementielle","styling sur mesure"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","name":"Services de coiffure","itemListElement":[{"@type":"Offer","name":"Coupe de cheveux"},{"@type":"Offer","name":"Coloration"},{"@type":"Offer","name":"Soin du cheveu"},{"@type":"Offer","name":"Coiffure événementielle"},{"@type":"Offer","name":"Styling sur mesure"}]}}'::jsonb, '2026-02-27T03:21:27.457Z', TRUE, 5, '936a000181eacad441dbcaf394c7d37db1c2f9a86f5f2b7bd6fc6fcacaed0167', 'Chez XYZ Verviers-Heusy, chaque client est écouté pour créer une coiffure unique qui reflète sa personnalité. Notre approche artistique et notre expertise technique font la différence.', NULL, 'Joie', '[{"name":"Consultation personnalisée","description":"Un entretien approfondi avec le client pour comprendre ses attentes et proposer des solutions adaptées à son style de vie et à sa morphologie.","frequency":"100","impact":"50","proof":null},{"name":"Test de couleur avant application","description":"Application d''une mèche test pour vérifier la réaction du cheveu et l''effet final de la coloration, garantissant un résultat sûr et satisfaisant.","frequency":"100","impact":"50","proof":null},{"name":"Nettoyage professionnel après service","description":"Utilisation d''un shampoing et d''un soin adaptés pour éliminer les résidus de produits et laisser les cheveux doux et brillants.","frequency":"100","impact":"50","proof":null},{"name":"Conseils personnalisés","description":"Remise d''une fiche avec des conseils pour l''entretien à domicile, incluant les produits recommandés et la fréquence de soin.","frequency":"100","impact":"50","proof":null},{"name":"Suivi post-rendez-vous","description":"Envoi d''un email de rappel pour le prochain rendez-vous avec des suggestions de soins complémentaires.","frequency":"100","impact":"50","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T03:22:30.593Z","proof":"https://www.xyz.be/xyz-verviers-heusy/"},{"label":"Seed: city hint","date":"2026-02-27T03:22:30.593Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T03:22:30.593Z","proof":"Coiffeur"},{"label":"Seed: search keyword","date":"2026-02-27T03:22:30.593Z","proof":"Coiffeur"},{"label":"Extracted: city","date":"2026-02-27T03:22:30.593Z","proof":""},{"label":"BCE: mod97 valid","date":"2026-02-27T03:22:30.593Z","proof":"0479016781"},{"label":"Email extracted","date":"2026-02-27T03:22:30.593Z","proof":"ottignies@xyz.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T03:22:30.593Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T03:22:30.593Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T03:22:30.593Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-xyz/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0479016781', 'Actif', 'BCE_CSV', '2026-02-27T03:16:43.506Z', '2026-02-27T03:16:43.506Z', 'SEVERINE T.', '2002-12-19', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T03:22:30.593Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0479016781'
    AND c_existing.slug <> 'coiffeur-verviers-xyz'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coiffeur-verviers-just-in-hair', 'BE-WAL', 'Just in Hair', 'Coiffeur', ARRAY['coiffure homme verviers', 'coloration naturelle', 'balayage discret', 'lissage sans dommage', 'conseil personnalisé', 'salon coiffure local', 'coupe homme', 'coupe femme', 'coloration', 'balayage', 'lissage']::text[], ARRAY['Coupe homme', 'Coupe femme', 'Coloration', 'Balayage', 'Lissage']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Rue des Raines 73 CONTACTEZ-MOI HORAIRES MARDI AU SAMEDI 0900 – 1800MENU ○ Accueil ○ A propos ○ Coiffure ○ Coloration/Balay', 'https://justinhair.be/', NULL, 'https://www.instagram.com/just_in_hair_verviers/', NULL, NULL, 'justine.lorquet@hotmail.com', NULL, '+32455170528', '+32455170528', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], 'Sur rendez-vous', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coupe homme?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Gérez-vous les interventions urgentes?","answer":"Oui, l''organisation permet de répondre aux demandes urgentes (Sur rendez-vous)."}]'::jsonb, 'Just in Hair, salon de coiffure à Verviers, se spécialise dans les coupes sur mesure et les soins capillaires personnalisés pour sublimer votre style au quotidien.', 'Coiffeur à Verviers | Just in Hair', 'Coloration naturelle et balayage discret pour des cheveux sains. Consultation préalable personnalisée avant chaque prestation. Salon coiffure local à Verviers.', 'Just in Hair - Coiffeur à Verviers', 'Salon de coiffure à Verviers proposant coupes homme/femme, colorations et lissages sans dommage. Conseils personnalisés pour des résultats durables.', '{"@context":"https://schema.org","@type":"HairSalon","name":"Just in Hair","description":"Coiffeur à Verviers proposant coupes, colorations et lissages personnalisés.","url":"https://revelys.be/entreprises/coiffeur-verviers-just-in-hair","sameAs":["https://justinhair.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue des Raines 73","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":"Verviers","keywords":["coiffure homme verviers","coloration naturelle","balayage discret","lissage sans dommage","conseil personnalisé","salon coiffure local","coupe homme","coupe femme","coloration","balayage","lissage"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/cover.webp"],"hasOfferCatalog":{"@type":"OfferCatalog","name":"Services de coiffure","itemListElement":[{"@type":"Offer","name":"Coupe homme","url":"https://justinhair.be/"},{"@type":"Offer","name":"Coupe femme","url":"https://justinhair.be/"},{"@type":"Offer","name":"Coloration","url":"https://justinhair.be/"},{"@type":"Offer","name":"Balayage","url":"https://justinhair.be/"},{"@type":"Offer","name":"Lissage","url":"https://justinhair.be/"}]}}'::jsonb, '2026-02-27T03:28:48.415Z', TRUE, 5, '10bb42880801be5d7e7232809e4b60ff56032d81713fcd03ce3fbbfd70edced3', 'Chez Just in Hair, chaque client bénéficie d''une attention unique pour des résultats qui reflètent sa personnalité.', NULL, 'Joie', '[{"name":"Consultation préalable","description":"Analyse de la texture et de l''état du cheveu avant toute prestation pour adapter les techniques utilisées.","frequency":"toujours","impact":"personnalisation optimale","proof":null},{"name":"Application produit précis","description":"Utilisation de produits adaptés à chaque type de cheveu, appliqués avec des techniques spécifiques pour un résultat durable.","frequency":"toujours","impact":"résultat professionnel","proof":null},{"name":"Démonstration produit","description":"Explication des soins à domicile recommandés et démonstration de leur application pour entretenir le résultat en salon.","frequency":"toujours","impact":"autonomie client","proof":null}]'::jsonb, 86, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T03:29:51.428Z","proof":"https://justinhair.be/"},{"label":"Seed: city hint","date":"2026-02-27T03:29:51.428Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T03:29:51.428Z","proof":"Coiffeur"},{"label":"Seed: search keyword","date":"2026-02-27T03:29:51.428Z","proof":"Coiffeur"},{"label":"Extracted: city","date":"2026-02-27T03:29:51.428Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T03:29:51.428Z","proof":"0801498726"},{"label":"Email extracted","date":"2026-02-27T03:29:51.428Z","proof":"justine.lorquet@hotmail.com"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T03:29:51.428Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T03:29:51.428Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T03:29:51.428Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-just-in-hair/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0801498726', 'Actif', 'BCE_CSV', '2026-02-27T03:22:49.305Z', '2026-02-27T03:22:49.305Z', 'Lorquet, Justine', '2023-05-02', 'Personne physique', NULL, 'Situation normale', '2026-02-11', '2026-02-27T03:29:51.428Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0801498726'
    AND c_existing.slug <> 'coiffeur-verviers-just-in-hair'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coiffeur-verviers-me-contacter', 'BE-WAL', 'Me contacter', 'Coiffeur', ARRAY['coiffure', 'vegan', 'extensions', 'chignon', 'coloration', 'salons', 'heusy', 'coupe', 'brushing', 'chignons événementiels']::text[], ARRAY['Coupe', 'Coloration', 'Brushing', 'Extensions', 'Chignons événementiels']::text[], 'sur_devis', NULL, NULL, NULL, 'Heusy Verviers', '4802', 'BE', 'Rue de la Tannerie, 25B - HEUSY - VERVIERS', 'https://www.tchouphair.be/', 'https://www.facebook.com/tchouphair', 'https://www.instagram.com/tchouphair', NULL, NULL, 'angela@tchouphair.be', NULL, '+3287773144', '+3287773144', NULL, NULL, NULL, 'Heusy Verviers', ARRAY['français']::text[], 'Sur rendez-vous', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coupe?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Sur quelle zone géographique intervenez-vous?","answer":"Les interventions se déroulent à Heusy Verviers et dans les communes avoisinantes, selon la nature de la demande."},{"question":"Comment la qualité des interventions est-elle assurée?","answer":"La qualité repose sur une méthode structurée, des vérifications en cours d''intervention et un contrôle final avant la remise au client."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Ce qui les distingue localement: Expérience de 25 ans, approche individuelle et produits vegan sans sulfates"}]'::jsonb, 'Ã€ Heusy Verviers (province de Liege), Me contacter intervient sur des besoins de coupe. Les demandes traitées couvrent notamment le coupe, la coloration, le brushing et les extensions, avec une méthode orientée diagnostic et solution durable. Le premier échange sert à cadrer le besoin, expliquer les étapes et confirmer un plan d''action adapté.', 'Coiffeur à Heusy Verviers | Me contacter', 'Salon vegan avec produits sans sulfates. Expertise de 25 ans pour des soins capillaires adaptés à vos cheveux. À Heusy, près de Verviers.', 'Coiffeur vegan à Heusy Verviers', 'Diagnostic capillaire personnalisé et produits sans sulfates. Prestations sur mesure pour tous types de cheveux dans un salon à Heusy.', '{"@context":"https://schema.org","@type":"HairSalon","name":"Me contacter","description":"Coiffeur vegan avec produits sans sulfates et diagnostic capillaire personnalisé.","url":"https://revelys.be/entreprises/coiffeur-verviers-me-contacter","sameAs":["https://www.tchouphair.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue de la Tannerie, 25B","postalCode":"4802","addressLocality":"Heusy Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Heusy Verviers"},"keywords":["coiffure","vegan","extensions","chignon","coloration","salons","heusy","coupe","brushing","chignons événementiels"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/logo.webp"}'::jsonb, '2026-02-27T03:39:43.320Z', TRUE, 5, '242972b8d89c1a0ba7cf707eb2e926f930d6a4086efefc611939d3923a6287e8', 'Expérience de 25 ans, approche individuelle et produits vegan sans sulfates', NULL, 'Accompagnement', '[{"name":"Diagnostic capillaire personnalisé","description":"Évaluation des besoins spécifiques pour chaque client(e)","frequency":"À chaque rendez-vous","impact":"Résultats adaptés et durables","proof":null},{"name":"Utilisation de produits vegan","description":"Sans sulfates, sans formol, sans sel","frequency":"Pour toutes les prestations","impact":"Préservation de la santé des cheveux","proof":null},{"name":"Conseils sur mesure","description":"Recommandations personnalisées pour chaque type de cheveu","frequency":"Pendant et après la prestation","impact":"Entretien optimal entre les rendez-vous","proof":null}]'::jsonb, 37, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T03:40:26.672Z","proof":"https://www.tchouphair.be/"},{"label":"Seed: city hint","date":"2026-02-27T03:40:26.672Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T03:40:26.672Z","proof":"Coiffeur"},{"label":"Seed: search keyword","date":"2026-02-27T03:40:26.672Z","proof":"Coiffeur"},{"label":"Extracted: city","date":"2026-02-27T03:40:26.672Z","proof":"Heusy Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T03:40:26.672Z","proof":"0804998248"},{"label":"Email extracted","date":"2026-02-27T03:40:26.672Z","proof":"angela@tchouphair.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T03:40:26.672Z","proof":"confidence=89/100"},{"label":"Phone extracted","date":"2026-02-27T03:40:26.672Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T03:40:26.672Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-me-contacter/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0804998248', 'Actif', 'BCE_CSV', '2026-02-27T03:33:32.511Z', '2026-02-27T03:33:32.511Z', 'Marchese, Angela', '2023-10-01', 'Personne physique', NULL, 'Situation normale', '2026-02-11', '2026-02-27T03:40:26.672Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0804998248'
    AND c_existing.slug <> 'coiffeur-verviers-me-contacter'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'coiffeur-verviers-k-ro-coiffure', 'BE-WAL', 'k-ro-coiffure', 'Coiffeur', ARRAY['blonds parfaits', 'couleurs sur mesure', 'coupes homme modernes', 'produits kérastase', 'ambiance familiale', 'conseils personnalisés', 'salon verviers-heusy', 'coloration sur mesure', 'coupe homme et barber', 'soins capillaires kérastase', 'coiffure chimique', 'brushing professionnel']::text[], ARRAY['Coloration sur mesure', 'Coupe homme et barber', 'Soins capillaires kérastase', 'Coiffure chimique', 'Brushing professionnel']::text[], NULL, NULL, NULL, NULL, 'Verviers', '4800', 'BE', 'Chaussée de Heusy 214', 'https://k-ro-salon.be/', 'https://www.facebook.com/K.RO.salon', 'https://www.instagram.com/k.ro_salon', NULL, 'https://www.tiktok.com/@k.ro_salon?lang=en', 'info@k-rocoiffure.be', NULL, '+3287850444', '+3287850444', NULL, NULL, NULL, 'Verviers', ARRAY['français']::text[], NULL, '[{"day":"lundi","open":"10:00","close":"17:00","isClosed":false},{"day":"mercredi","open":"09:00","close":"18:00","isClosed":false},{"day":"jeudi","open":"09:00","close":"18:00","isClosed":false},{"day":"vendredi","open":"09:00","close":"18:00","isClosed":false},{"day":"samedi","open":"09:00","close":"18:00","isClosed":false}]'::jsonb, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de coloration sur mesure?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Verviers. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."}]'::jsonb, 'K-Ro Coiffure, salon familial à Verviers-Heusy, allie expertise et convivialité depuis plus de 30 ans. Spécialistes des blonds parfaits, colorations sur mesure et coupes barber modernes, l''équipe utilise des produits Kérastase pour sublimer chaque chevelure avec précision. Un moment détente où conseils personnalisés et ambiance chaleureuse garantissent un résultat à votre image.', 'Coiffeur à Verviers | K-Ro Coiffure', 'Colorations sur mesure avec test de mèche pour éviter les surprises. Salon familial utilisant des produits Kérastase, situé à Verviers-Heusy.', 'K-Ro Coiffure - Salon de coiffure à Verviers', 'Coiffeur à Verviers proposant colorations sur mesure, coupes homme et soins capillaires avec produits Kérastase. Ambiance familiale et conseils personnalisés.', '{"@context":"https://schema.org","@type":"HairSalon","name":"K-Ro Coiffure","description":"Coiffeur à Verviers proposant colorations sur mesure, coupes homme et soins capillaires avec produits Kérastase.","url":"https://revelys.be/entreprises/coiffeur-verviers-k-ro-coiffure","sameAs":["https://k-ro-salon.be/"],"address":{"@type":"PostalAddress","streetAddress":"Chaussée de Heusy 214","postalCode":"4800","addressLocality":"Verviers","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Verviers"},"keywords":["blonds parfaits","couleurs sur mesure","coupes homme modernes","produits kérastase","ambiance familiale","conseils personnalisés","salon verviers-heusy","coloration sur mesure","coupe homme et barber","soins capillaires kérastase","coiffure chimique","brushing professionnel"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","name":"Services K-Ro Coiffure","itemListElement":[{"@type":"Offer","name":"Coloration sur mesure"},{"@type":"Offer","name":"Coupe homme et barber"},{"@type":"Offer","name":"Soins capillaires kérastase"},{"@type":"Offer","name":"Coiffure chimique"},{"@type":"Offer","name":"Brushing professionnel"}]}}'::jsonb, '2026-02-27T03:44:16.995Z', TRUE, 5, '257a9fdecb5c5c1d9614feeb1c70cb180e2b8c6a4b6afed2ab15df0f97d41e99', 'Chez K-Ro Coiffure, chaque client est traité comme un membre de la famille. L''équipe allie savoir-faire technique et écoute attentive pour créer des looks uniques qui reflètent votre personnalité.', NULL, 'Joie', '[{"name":"Test de couleur avant application","description":"Analyse minutieuse de la chevelure et test de mèche pour garantir une coloration parfaite, adaptée à vos cheveux.","frequency":"toujours","impact":"évite les surprises de teinte","proof":null},{"name":"Brushing avec produits Kérastase","description":"Utilisation systématique des soins Kérastase pour un brushing lisse et brillant, protégeant la fibre capillaire.","frequency":"toujours","impact":"résultat professionnel durable","proof":null},{"name":"Conseil personnalisé en fin de séance","description":"Recommandations sur les produits d''entretien et techniques pour préserver le résultat à domicile.","frequency":"toujours","impact":"autonomie du client entre deux rendez-vous","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T03:45:25.457Z","proof":"https://k-ro-salon.be/"},{"label":"Seed: city hint","date":"2026-02-27T03:45:25.457Z","proof":"Verviers"},{"label":"Seed: industry category","date":"2026-02-27T03:45:25.457Z","proof":"Coiffeur"},{"label":"Seed: search keyword","date":"2026-02-27T03:45:25.457Z","proof":"Coiffeur"},{"label":"Extracted: city","date":"2026-02-27T03:45:25.457Z","proof":"Verviers"},{"label":"BCE: mod97 valid","date":"2026-02-27T03:45:25.457Z","proof":"0828407219"},{"label":"Email extracted","date":"2026-02-27T03:45:25.457Z","proof":"info@k-rocoiffure.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T03:45:25.457Z","proof":"confidence=90/100"},{"label":"Phone extracted","date":"2026-02-27T03:45:25.458Z","proof":"source=jsonld"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T03:45:25.458Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/coiffeur-verviers-k-ro-coiffure/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0828407219', 'Actif', 'BCE_CSV', '2026-02-27T03:40:31.703Z', '2026-02-27T03:40:31.703Z', 'CAROLINE V', '2010-08-11', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T03:45:25.458Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0828407219'
    AND c_existing.slug <> 'coiffeur-verviers-k-ro-coiffure'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'climatisation-huy-yooza', 'BE-WAL', 'Yooza', 'Climatisation', ARRAY['dépannage urgent', 'marques fujitsu daikin', 'chambre froide professionnelle', 'certificat technique froid', 'intervention 24h', 'climatisation réversible', 'efficacité énergétique', 'confort thermique été hiver', 'installation de climatisation', 'entretien de systèmes frigorifiques', 'réparation de fuites réfrigérantes', 'dépannage 24 7']::text[], ARRAY['Installation de climatisation', 'Entretien de systèmes frigorifiques', 'Réparation de fuites réfrigérantes', 'Dépannage 24 7', 'Montage de chambres froides sur mesure']::text[], 'forfait', NULL, NULL, NULL, 'Huy', '4500', 'BE', 'Rue de Statte 29', 'https://www.yooza.be/', NULL, 'https://www.instagram.com/yooza_dulieu/', NULL, NULL, 'info@yooza.be', NULL, '+32498856018', '+32498856018', NULL, NULL, NULL, 'Huy', ARRAY['français']::text[], '24h/24 - 7j/7', '[{"day":"mardi","open":"03:00","close":"04:00","isClosed":false}]'::jsonb, NULL, NULL, NULL, '[{"question":"Proposez-vous des services d''installation de climatisation?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Huy et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'Yooza est un spécialiste de la climatisation à Huy, proposant des solutions sur mesure pour les particuliers et professionnels. L''entreprise intervient également en réfrigération et pompes à chaleur avec des marques reconnues comme Fujitsu et Daikin. Son équipe de techniciens certifiés assure installation, entretien et dépannage 24/7.', 'Climatisation à Huy | Yooza', 'Intervention 24/7 pour dépannage urgent de climatisation. Expertise certifiée Fujitsu/Daikin avec test d''étanchéité systématique. Solutions adaptées aux besoins locaux.', 'Yooza - Climatisation et frigorifique à Huy', 'Installation, entretien et réparation de systèmes de climatisation et chambres froides professionnelles. Diagnostic complet avant chaque intervention.', '{"@context":"https://schema.org","@type":"HVACBusiness","name":"Yooza","description":"Installation, entretien et réparation de systèmes de climatisation et frigorifiques à Huy.","url":"https://revelys.be/entreprises/climatisation-huy-yooza","sameAs":["https://www.yooza.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue de Statte 29","postalCode":"4500","addressLocality":"Huy","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Huy"},"keywords":["dépannage urgent","marques fujitsu daikin","chambre froide professionnelle","certificat technique froid","intervention 24h","climatisation réversible","efficacité énergétique","confort thermique été hiver","installation de climatisation","entretien de systèmes frigorifiques","réparation de fuites réfrigérantes","dépannage 24 7"],"image":[{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/logo.webp","width":500,"height":300}],"logo":{"@type":"ImageObject","url":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/logo.webp"},"hasOfferCatalog":{"@type":"OfferCatalog","name":"Services de climatisation et frigorifique","itemListElement":[{"@type":"Offer","name":"Installation de climatisation","url":"https://www.yooza.be/"},{"@type":"Offer","name":"Entretien de systèmes frigorifiques","url":"https://www.yooza.be/"},{"@type":"Offer","name":"Réparation de fuites réfrigérantes","url":"https://www.yooza.be/"},{"@type":"Offer","name":"Dépannage 24/7","url":"https://www.yooza.be/"},{"@type":"Offer","name":"Montage de chambres froides sur mesure","url":"https://www.yooza.be/"}]}}'::jsonb, '2026-02-27T04:59:05.671Z', TRUE, 5, '9c12a2766072af96f33087b226a570619ed39a33a7739a61b31dbd64bcfb4534', 'Yooza se distingue par son expertise en techniques frigorifiques et sa collaboration avec les meilleures marques du marché. L''entreprise propose des solutions adaptées à chaque besoin, alliant performance énergétique et confort durable.', NULL, 'Soulagement', '[{"name":"Diagnostic complet avant intervention","description":"Chaque technicien réalise un diagnostic précis des systèmes réfrigérés pour identifier les problèmes spécifiques et proposer la solution la plus adaptée. Ce protocole permet d''éviter les interventions inutiles et de","frequency":"toujours","impact":"qualite","proof":null},{"name":"Test de pression sur circuits frigorifiques","description":"Après toute intervention, Yooza effectue systématiquement un test de pression pour vérifier l''étanchéité des circuits et prévenir les fuites. Ce contrôle est réalisé avec des outils professionnels spécifiques à la","frequency":"toujours","impact":"securite","proof":null},{"name":"Nettoyage des filtres de climatisation","description":"Lors de chaque entretien, les techniciens procèdent au nettoyage approfondi des filtres et des composants internes pour maintenir l''efficacité énergétique du système. Cette étape est cruciale pour la qualité de l''air et","frequency":"toujours","impact":"performance","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T05:00:19.313Z","proof":"https://www.yooza.be/"},{"label":"Seed: city hint","date":"2026-02-27T05:00:19.313Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T05:00:19.313Z","proof":"Climatisation"},{"label":"Seed: search keyword","date":"2026-02-27T05:00:19.313Z","proof":"Climatisation"},{"label":"Extracted: city","date":"2026-02-27T05:00:19.313Z","proof":"Huyaccueil"},{"label":"BCE: mod97 valid","date":"2026-02-27T05:00:19.313Z","proof":"0748961942"},{"label":"Email extracted","date":"2026-02-27T05:00:19.313Z","proof":"info@yooza.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T05:00:19.313Z","proof":"confidence=85/100"},{"label":"BCE recovered from local identity","date":"2026-02-27T05:00:19.313Z","proof":"score=110"},{"label":"Phone extracted","date":"2026-02-27T05:00:19.313Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T05:00:19.313Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/climatisation-huy-yooza/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0748961942', 'Actif', 'BCE_CSV', '2026-02-27T04:56:50.198Z', '2026-02-27T04:56:50.198Z', 'YOOZA', '2020-06-25', 'Personne morale', 'Société en commandite', 'Situation normale', '2026-02-11', '2026-02-27T05:00:19.313Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0748961942'
    AND c_existing.slug <> 'climatisation-huy-yooza'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'toiture-huy-efl-construction', 'BE-WAL', 'EFL Construct', 'Toiture', ARRAY['ia', 'extraction de données', 'traitement du langage naturel', 'organisation d''information', 'analyse textuelle', 'big data', 'aide à l''extraction', 'organisation et analyse d''informations à partir de données textuelles complexes']::text[], ARRAY['Aide à l''extraction', 'Organisation et analyse d''informations à partir de données textuelles complexes']::text[], 'sur_devis', NULL, NULL, TRUE, 'Huy', '4500', 'BE', 'Rue du Bois-Marie 23', 'https://www.eflconstruct.be/', NULL, NULL, NULL, NULL, 'info@eflconstruct.be', NULL, '+32498047104', '+32498047104', NULL, NULL, NULL, 'Huy', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services d''aide à l''extraction?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Sur quelle zone géographique intervenez-vous?","answer":"Les interventions se déroulent à Huy et dans les communes avoisinantes, selon la nature de la demande."},{"question":"Comment la qualité des interventions est-elle assurée?","answer":"La qualité repose sur une méthode structurée, des vérifications en cours d''intervention et un contrôle final avant la remise au client."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Ce qui les distingue localement: Pour gagner du temps dans l''analyse et la compréhension de données textuelles non structurées"}]'::jsonb, 'Ã€ Huy (province de Liege), EFL Construct intervient sur des besoins de toiture. Les demandes traitées couvrent notamment l''aide à l''extraction et l''organisation et analyse d''informations à partir de données textuelles complexes, avec une méthode orientée diagnostic et solution durable. Le premier échange sert à cadrer le besoin, expliquer les étapes et confirmer un plan d''action adapté.', 'Toiture à Huy | EFL Construct', 'Extraction et analyse d''informations textuelles complexes pour gagner du temps. Spécialisé en traitement de données non structurées, basé à Huy.', 'EFL Construct - Toiture à Huy', 'Entreprise spécialisée dans l''extraction et l''analyse de données textuelles complexes. Basée à Huy, elle propose des solutions pour organiser et comprendre les informations.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"EFL Construct","description":"Spécialisé dans l''extraction et l''analyse de données textuelles complexes.","url":"https://revelys.be/entreprises/toiture-huy-efl-construction","sameAs":["https://www.eflconstruct.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue du Bois-Marie 23","postalCode":"4500","addressLocality":"Huy","addressCountry":"BE"},"areaServed":"Huy","keywords":["ia","extraction de données","traitement du langage naturel","organisation d''information","analyse textuelle","big data","aide à l''extraction","organisation et analyse d''informations à partir de données textuelles complexes"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/logo.webp"}'::jsonb, '2026-02-27T05:34:24.168Z', TRUE, 5, 'eb1918c6bab3b18c9122e9b6599094af284be23c1c3f74c3bca1135d613d66d4', 'Pour gagner du temps dans l''analyse et la compréhension de données textuelles non structurées', NULL, 'Proximité', '[{"name":"Aide à l''extraction","description":"Extrait les éléments clés d''un texte complexe, comme des adresses, numéros de téléphone ou concepts.","frequency":"A chaque demande","impact":"Réduit le temps passé sur la recherche manuelle","proof":null},{"name":"Organisation des données","description":"Structure les informations extraites en catégories logiques et hiérarchisées.","frequency":"Suite à l''extraction","impact":"Facilite l''accès rapide aux données","proof":null},{"name":"Analyse contextuelle","description":"Identifie les relations entre les différentes informations extraites pour une meilleure compréhension globale.","frequency":"Optionnel après organisation","impact":"Permet des insights plus profonds","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T05:35:05.175Z","proof":"https://www.eflconstruct.be/"},{"label":"Seed: city hint","date":"2026-02-27T05:35:05.175Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T05:35:05.175Z","proof":"Toiture"},{"label":"Seed: search keyword","date":"2026-02-27T05:35:05.175Z","proof":"Toiture"},{"label":"Extracted: city","date":"2026-02-27T05:35:05.175Z","proof":"Huy"},{"label":"BCE: mod97 valid","date":"2026-02-27T05:35:05.175Z","proof":"0767502107"},{"label":"Email extracted","date":"2026-02-27T05:35:05.175Z","proof":"info@eflconstruct.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T05:35:05.175Z","proof":"confidence=85/100"},{"label":"Phone extracted","date":"2026-02-27T05:35:05.175Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T05:35:05.175Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-efl-construction/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0767502107', 'Actif', 'BCE_CSV', '2026-02-27T05:24:52.584Z', '2026-02-27T05:24:52.584Z', 'EFL CONSTRUCT', '2021-04-26', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T05:35:05.175Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0767502107'
    AND c_existing.slug <> 'toiture-huy-efl-construction'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'toiture-huy-seba-toiture', 'BE-WAL', 'Seba toiture', 'Toiture', ARRAY['fuite toit', 'étanchéité toiture', 'isolation comble', 'bardage cèdre', 'urgence zinguerie', 'durée de vie toiture', 'région huy', 'matériaux durables', 'toiture plate ou en pente', 'charpente traditionnelle ou préfabriquée', 'bardage de façade', 'zinguerie (gouttières']::text[], ARRAY['Toiture plate ou en pente', 'Charpente traditionnelle ou préfabriquée', 'Bardage de façade', 'Zinguerie (gouttières', 'Descentes d''eau)', 'Aménagement de combles']::text[], NULL, NULL, NULL, NULL, 'Hermalle-sous-huy', '4480', 'BE', 'rue de Chaumont 26 , , BE', 'https://www.seba-toiture.be/', 'https://www.facebook.com/SEBA-toiture-103661715170123', NULL, NULL, NULL, 'info@seba-toiture.be', NULL, '+32497697038', '+32497697038', NULL, NULL, NULL, 'Hermalle-sous-huy', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de toiture plate ou en pente?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Sur quelle zone géographique intervenez-vous?","answer":"Les interventions se déroulent à Hermalle-sous-huy et dans les communes avoisinantes, selon la nature de la demande."},{"question":"Comment la qualité des interventions est-elle assurée?","answer":"La qualité repose sur une méthode structurée, des vérifications en cours d''intervention et un contrôle final avant la remise au client."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Seba Toiture se distingue par son approche personnalisée et son expertise technique, garantissant des réalisations sur mesure qui allient esthétique et performance. L''entreprise mise sur des matériaux de qualité pour assurer la longévité de vos installations."}]'::jsonb, 'Seba Toiture est une entreprise spécialisée dans les travaux de toiture à Hermalle-sous-Huy et ses environs. Elle propose des solutions sur mesure pour la construction, la rénovation ou l''aménagement de combles, avec un savoir-faire reconnu en bardage et zinguerie. L''équipe s''engage à protéger votre habitation avec des matériaux durables et une expertise technique rigoureuse.', 'Toiture à Hermalle-sous-huy | Seba toiture', 'Expert en étanchéité et isolation de toitures avec test d''étanchéité systématique. Bardage cèdre pour une façade durable dans la région Huy.', 'Seba Toiture - Couvreur à Hermalle-sous-huy', 'Spécialiste en toitures plates ou en pente, bardages et zinguerie. Approche personnalisée avec matériaux durables pour des réalisations sur mesure.', '{"@context":"https://schema.org","@type":"RoofingContractor","name":"Seba toiture","description":"Couvreur spécialisé en toitures, bardages et zinguerie à Hermalle-sous-huy.","url":"https://revelys.be/entreprises/toiture-huy-seba-toiture","sameAs":["https://www.seba-toiture.be/"],"address":{"@type":"PostalAddress","streetAddress":"rue de Chaumont 26","postalCode":"4480","addressLocality":"Hermalle-sous-huy","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Hermalle-sous-huy"},"keywords":["fuite toit","étanchéité toiture","isolation comble","bardage cèdre","urgence zinguerie","durée de vie toiture","région huy","matériaux durables","toiture plate ou en pente","charpente traditionnelle ou préfabriquée","bardage de façade","zinguerie (gouttières"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/cover.webp"],"logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/logo.webp","hasOfferCatalog":{"@type":"OfferCatalog","name":"Services de toiture et bardage","itemListElement":[{"@type":"OfferItem","name":"Toiture plate ou en pente"},{"@type":"OfferItem","name":"Charpente traditionnelle ou préfabriquée"},{"@type":"OfferItem","name":"Bardage de façade"},{"@type":"OfferItem","name":"Zinguerie (gouttières, descentes d''eau)"},{"@type":"OfferItem","name":"Aménagement de combles"}]}}'::jsonb, '2026-02-27T05:39:14.402Z', TRUE, 5, '3715f3af1f161e6a93f4a82afb7bc67efaf737391ad104af54bb6ba048fecd85', 'Seba Toiture se distingue par son approche personnalisée et son expertise technique, garantissant des réalisations sur mesure qui allient esthétique et performance. L''entreprise mise sur des matériaux de qualité pour assurer la longévité de vos installations.', NULL, 'Durabilité', '[{"name":"Test d''étanchéité après pose","description":"Après chaque intervention, l''équipe vérifie systématiquement l''étanchéité du toit à l''aide d''un test de pression ou d''une inspection visuelle minutieuse pour garantir une protection optimale contre les infiltrations.","frequency":"toujours","impact":"qualite","proof":null},{"name":"Nettoyage des gouttières avant intervention","description":"Avant de procéder à la zinguerie, les couvreurs nettoient soigneusement les gouttières et descentes d''eau pour éliminer feuilles et débris, assurant ainsi une meilleure adhérence des matériaux et un écoulement optimal","frequency":"toujours","impact":"qualite","proof":null},{"name":"Prise de mesures précises pour bardage","description":"Pour chaque projet de bardage, l''équipe réalise une prise de mesures détaillée sur site afin d''adapter parfaitement les panneaux (ardoise, cèdre ou Trespa) à la structure de votre façade, évitant ainsi tout gaspillage","frequency":"toujours","impact":"qualite","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T05:40:25.959Z","proof":"https://www.seba-toiture.be/"},{"label":"Seed: city hint","date":"2026-02-27T05:40:25.959Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T05:40:25.959Z","proof":"Toiture"},{"label":"Seed: search keyword","date":"2026-02-27T05:40:25.959Z","proof":"Toiture"},{"label":"Extracted: city","date":"2026-02-27T05:40:25.959Z","proof":"Hermalle-sous-huy"},{"label":"BCE: mod97 valid","date":"2026-02-27T05:40:25.959Z","proof":"0843281376"},{"label":"Email extracted","date":"2026-02-27T05:40:25.959Z","proof":"info@seba-toiture.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T05:40:25.959Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T05:40:25.959Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T05:40:25.959Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/toiture-huy-seba-toiture/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0843281376', 'Actif', 'BCE_CSV', '2026-02-27T05:36:17.849Z', '2026-02-27T05:36:17.849Z', 'Pirotte, Sébastien', '2019-10-07', 'Personne physique', NULL, 'Situation normale', '2026-02-11', '2026-02-27T05:40:25.959Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0843281376'
    AND c_existing.slug <> 'toiture-huy-seba-toiture'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'crepi-huy-platre-et-ciment', 'BE-WAL', 'PLATRE ET CIMENT', 'Façadier', ARRAY['crépi façade', 'enduits hydrofuges', 'pose châssis', 'rénovation mur extérieur', 'finitions sur-mesure', 'projection ciment', 'décoration intérieure', 'plafonnage', 'revêtement de murs et plafonds', 'faux plafonds', 'cloisons légères', 'cimentage']::text[], ARRAY['Plafonnage', 'Revêtement de murs et plafonds', 'Faux plafonds', 'Cloisons légères', 'Cimentage', 'Mortex']::text[], 'sur_devis', 2, NULL, TRUE, 'Huy', '4500', 'BE', 'Camp de Corroy 64', 'https://www.platreetciment.be/', NULL, NULL, NULL, NULL, 'adressemail@fournisseur.com', NULL, '+32479947365', '+32479947365', NULL, NULL, NULL, 'Huy', ARRAY['français']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de plafonnage?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Sur quelle zone géographique intervenez-vous?","answer":"Les interventions se déroulent à Huy et dans les communes avoisinantes, selon la nature de la demande."},{"question":"Comment la qualité des interventions est-elle assurée?","answer":"La qualité repose sur une méthode structurée, des vérifications en cours d''intervention et un contrôle final avant la remise au client."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Plâtre & Ciment se distingue par l''engagement personnel du patron sur chaque chantier, combinant expertise technique et conseil personnalisé pour des réalisations durables."}]'::jsonb, 'Plâtre & Ciment est un façadier spécialisé dans les travaux de cimentage, plafonnage et pose de châssis à Huy. L''entreprise propose également la pose de Mortex, un enduit hydrofuge innovant pour murs et sols. Le patron réalise lui-même tous les chantiers, garantissant un travail irréprochable et des finitions sur-mesure.', 'Crépi à Huy | Plâtre & Ciment', 'Préparation minutieuse des supports pour éviter les décollages. Engagement du patron sur chaque chantier à Huy. Spécialiste en crépi façade et enduits hydrofuges.', 'Plâtre & Ciment - Crépi et revêtements à Huy', 'Entreprise spécialisée dans le crépi, les enduits hydrofuges et la rénovation de murs extérieurs. Interventions sur mesure avec conseil personnalisé.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"Plâtre & Ciment","description":"Spécialiste en crépi, enduits hydrofuges et rénovation de murs extérieurs à Huy.","url":"https://revelys.be/entreprises/crepi-huy-platre-et-ciment","sameAs":["https://www.platreetciment.be/"],"address":{"@type":"PostalAddress","streetAddress":"Camp de Corroy 64","postalCode":"4500","addressLocality":"Huy","addressCountry":"BE"},"areaServed":"Huy","keywords":["crépi façade","enduits hydrofuges","pose châssis","rénovation mur extérieur","finitions sur-mesure","projection ciment","décoration intérieure","plafonnage","revêtement de murs et plafonds","faux plafonds","cloisons légères","cimentage"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/cover.webp"]}'::jsonb, '2026-02-27T06:03:46.883Z', TRUE, 5, '8cf573d91c35a44ae6e83088895e1ff7001574693cfd369004ac4a9edd17b57e', 'Plâtre & Ciment se distingue par l''engagement personnel du patron sur chaque chantier, combinant expertise technique et conseil personnalisé pour des réalisations durables.', NULL, 'Sécurité', '[{"name":"Préparation minutieuse des supports","description":"Nettoyage approfondi et ponçage des surfaces avant application de tout enduit ou revêtement, garantissant une adhérence optimale.","frequency":"tous chantiers","impact":"évite les décollages prématurés","proof":null},{"name":"Application par projection","description":"Utilisation de machines à projeter pour un rendu ultra-lisse et des délais raccourcis, notamment sur les grands surfaces.","frequency":"tous chantiers plafonnage","impact":"gain de temps significatif","proof":null},{"name":"Test d''étanchéité Mortex","description":"Vérification systématique des zones traitées avec enduit hydrofuge par projection d''eau, avant séchage final.","frequency":"tous chantiers Mortex","impact":"garantit l''étanchéité","proof":null},{"name":"Choix de pigments sur mesure","description":"Conseil personnalisé pour sélectionner les teintes et textures des enduits, avec échantillons présentés au client.","frequency":"tous chantiers cimentage","impact":"résultat esthétique conforme aux attentes","proof":null},{"name":"Pose de châssis sur mesure","description":"Prise des mesures précises et découpe des cadres en atelier avant installation, pour un ajustement parfait.","frequency":"tous chantiers châssis","impact":"évite les erreurs d''ajustage","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T06:04:35.555Z","proof":"https://www.platreetciment.be/"},{"label":"Seed: city hint","date":"2026-02-27T06:04:35.555Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T06:04:35.555Z","proof":"Façadier"},{"label":"Seed: search keyword","date":"2026-02-27T06:04:35.555Z","proof":"crépi"},{"label":"Extracted: city","date":"2026-02-27T06:04:35.555Z","proof":"Huy"},{"label":"BCE: mod97 valid","date":"2026-02-27T06:04:35.555Z","proof":"0461338433"},{"label":"Email extracted","date":"2026-02-27T06:04:35.555Z","proof":"adressemail@fournisseur.com"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T06:04:35.555Z","proof":"confidence=80/100"},{"label":"BCE recovered from local identity","date":"2026-02-27T06:04:35.555Z","proof":"score=110"},{"label":"Phone extracted","date":"2026-02-27T06:04:35.555Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T06:04:35.555Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-platre-et-ciment/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0461338433', 'Actif', 'BCE_CSV', '2026-02-27T06:00:51.557Z', '2026-02-27T06:00:51.557Z', 'PLATRE ET CIMENT', '1997-08-27', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T06:04:35.555Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0461338433'
    AND c_existing.slug <> 'crepi-huy-platre-et-ciment'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'crepi-huy-bkp-plafonnage', 'BE-WAL', 'BKP Plafonnage', 'Façadier', ARRAY['humidité murs', 'remontée capillaire', 'façade poreuse', 'cloisons sèches', 'plafond suspendu', 'devis gratuit', '25 ans d''expérience', 'plafonnage', 'pose de cloisons', 'installation de faux plafonds', 'traitement de l''humidité', 'crépissage extérieur']::text[], ARRAY['Plafonnage', 'Pose de cloisons', 'Installation de faux plafonds', 'Traitement de l''humidité', 'Crépissage extérieur', 'Cimentage']::text[], 'sur_devis', NULL, NULL, TRUE, 'Huy', '4500', 'BE', 'Chemin de Perwez 4 boite 1', 'https://www.bkpplafonnage.be/', NULL, NULL, NULL, NULL, 'bkp.plafonnage@gmail.com', NULL, '+32471288363', '+32471288363', NULL, NULL, NULL, 'Huy', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de plafonnage?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Huy et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'BKP Plafonnage, spécialiste du plafonnage et des finitions murales à Huy, allie savoir-faire artisanal et techniques modernes pour sublimer vos intérieurs. Depuis 25 ans, cette entreprise familiale maîtrise le crépi extérieur, la pose de cloisons et les traitements contre l''humidité avec une attention méticuleuse aux détails.', 'Crépi à Huy | BKP Plafonnage', 'Traitement durable de l''humidité avec diagnostic précis. Expertise locale depuis 25 ans pour façades et plafonds. Devis gratuit.', 'BKP Plafonnage - Crépi et plafonnage à Huy', 'Entreprise spécialisée dans le traitement de l''humidité, le crépissage extérieur et la pose de faux plafonds à Huy. Diagnostic précis avant intervention.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"BKP Plafonnage","description":"Spécialiste du crépi, plafonnage et traitement de l''humidité à Huy.","url":"https://revelys.be/entreprises/crepi-huy-bkp-plafonnage","sameAs":["https://www.bkpplafonnage.be/"],"address":{"@type":"PostalAddress","streetAddress":"Chemin de Perwez 4 boite 1","postalCode":"4500","addressLocality":"Huy","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Huy"},"keywords":["humidité murs","remontée capillaire","façade poreuse","cloisons sèches","plafond suspendu","devis gratuit","25 ans d''expérience","plafonnage","pose de cloisons","installation de faux plafonds","traitement de l''humidité","crépissage extérieur"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/logo.webp"}'::jsonb, '2026-02-27T06:09:10.194Z', TRUE, 5, '166f39f7945fee6cd2c196a1aad872be13e698369b7312801e9043f3c446d7e5', 'Chez BKP Plafonnage, chaque intervention est réalisée avec des matériaux haut de gamme et une expertise transmise depuis deux générations. Leur approche personnalisée garantit des finitions impeccables, adaptées à vos besoins spécifiques.', NULL, 'Sérénité', '[{"name":"Diagnostic précis avant traitement","description":"Inspection minutieuse des murs et sols pour identifier les causes exactes de l''humidité (remontée capillaire, porosité) avant toute intervention","frequency":"toujours","impact":"évite les traitements inefficaces","proof":null},{"name":"Application d''enduit hydrofuge","description":"Utilisation de résine hydrofuge injectée dans la maçonnerie pour bloquer définitivement l''humidité","frequency":"toujours","impact":"garantit une protection durable","proof":null},{"name":"Préparation des surfaces avant plafonnage","description":"Nettoyage, colmatage des fissures et application de primer pour assurer un support parfait à l''enduit","frequency":"toujours","impact":"évite les défauts après peinture","proof":null}]'::jsonb, 94, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T06:09:59.437Z","proof":"https://www.bkpplafonnage.be/"},{"label":"Seed: city hint","date":"2026-02-27T06:09:59.437Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T06:09:59.437Z","proof":"Façadier"},{"label":"Seed: search keyword","date":"2026-02-27T06:09:59.437Z","proof":"crépi"},{"label":"Extracted: city","date":"2026-02-27T06:09:59.437Z","proof":"Huy"},{"label":"BCE: mod97 valid","date":"2026-02-27T06:09:59.437Z","proof":"1012487879"},{"label":"Email extracted","date":"2026-02-27T06:09:59.437Z","proof":"bkp.plafonnage@gmail.com"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T06:09:59.437Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T06:09:59.437Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T06:09:59.437Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/crepi-huy-bkp-plafonnage/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE1012487879', 'Actif', 'BCE_CSV', '2026-02-27T06:06:56.997Z', '2026-02-27T06:06:56.997Z', 'BKP Plafonnage', '2024-08-14', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T06:09:59.437Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE1012487879'
    AND c_existing.slug <> 'crepi-huy-bkp-plafonnage'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'portes-et-fenetres-huy-reglage-de-porte-huy', 'BE-WAL', 'Réglage de porte Huy', 'Chassis', ARRAY['dépannage urgent', 'porte bloquée', 'fenêtre qui grince', 'châssis pvc alu bois', 'vitrage cassé', '7j/7', 'garantie pièces et main d''œuvre', 'réparation de portes', 'réglage de fenêtres', 'entretien de châssis coulissants', 'remplacement de vitres', 'sécurisation après effraction']::text[], ARRAY['Réparation de portes', 'Réglage de fenêtres', 'Entretien de châssis coulissants', 'Remplacement de vitres', 'Sécurisation après effraction']::text[], 'sur_devis', NULL, NULL, TRUE, 'Overijse', '3090', 'BE', 'Brusselsesteenweg 292', 'https://reglage-porte.be/', NULL, NULL, NULL, NULL, 'info@devisgratuit.euphone', NULL, '+32479900232', '+32479900232', NULL, NULL, NULL, 'Overijse', ARRAY['français']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de réparation de portes?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Sur quelle zone géographique intervenez-vous?","answer":"Les interventions se déroulent à Overijse et dans les communes avoisinantes, selon la nature de la demande."},{"question":"Comment la qualité des interventions est-elle assurée?","answer":"La qualité repose sur une méthode structurée, des vérifications en cours d''intervention et un contrôle final avant la remise au client."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Spécialiste des portes et fenêtres, Réglage de porte Huy combine expertise technique et réactivité pour résoudre tous les problèmes liés aux châssis. Leur approche minutieuse garantit une intervention durable et sécurisée."}]'::jsonb, 'Réglage de porte Huy est spécialisé dans l''entretien et la réparation de portes, fenêtres et châssis à Huy et ses environs. L''entreprise intervient 7j/7 pour des réglages précis, des dépannages urgents ou le remplacement de quincaillerie sur tous types de matériaux (PVC, ALU, bois). Chaque intervention est garantie pièces et main d''œuvre.', 'Réparation portes et fenêtres à Overijse | Réglage de porte Huy', 'Intervention rapide pour portes bloquées ou vitres cassées. Test systématique après réglage pour éviter les retours. Spécialiste local en Brabant flamand.', 'Réparation de portes et fenêtres à Overijse', 'Artisan spécialisé dans le réglage, la réparation et l''entretien des châssis PVC, alu ou bois. Disponible 7j/7 pour dépannages urgents.', '{"@context":"https://schema.org","@type":"LocalBusiness","name":"Réglage de porte Huy","description":"Spécialiste des portes et fenêtres à Overijse, intervenant pour réparations et réglages.","url":"https://revelys.be/entreprises/portes-et-fenetres-huy-reglage-de-porte-huy","sameAs":["https://reglage-porte.be/"],"address":{"@type":"PostalAddress","streetAddress":"Brusselsesteenweg 292","postalCode":"3090","addressLocality":"Overijse","addressCountry":"BE"},"areaServed":{"@type":"Place","name":"Overijse"},"keywords":["dépannage urgent","porte bloquée","fenêtre qui grince","châssis pvc alu bois","vitrage cassé","7j/7","garantie pièces et main d''œuvre","réparation de portes","réglage de fenêtres","entretien de châssis coulissants","remplacement de vitres","sécurisation après effraction"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/logo.webp"}'::jsonb, '2026-02-27T06:41:23.078Z', TRUE, 5, '3d3039002c239be63af06095398b9a2849ca9327f744c1ecc9d93425822a019c', 'Spécialiste des portes et fenêtres, Réglage de porte Huy combine expertise technique et réactivité pour résoudre tous les problèmes liés aux châssis. Leur approche minutieuse garantit une intervention durable et sécurisée.', NULL, 'Durabilité', '[{"name":"Test de fermeture après réglage","description":"Après chaque intervention, l''artisan vérifie systématiquement le bon fonctionnement de la porte ou fenêtre en testant plusieurs fois l''ouverture et la fermeture pour s''assurer d''un réglage parfait.","frequency":"100%","impact":"Évite les retours inutiles et garantit une satisfaction client immédiate.","proof":null},{"name":"Nettoyage des joints avant remplacement","description":"Avant de remplacer un joint usé, l''équipe nettoie soigneusement la rainure pour garantir une adhérence optimale du nouveau joint et prolonger sa durée de vie.","frequency":"100%","impact":"Prévient les infiltrations d''air ou d''eau après installation.","proof":null},{"name":"Vérification des charnières coulissantes","description":"Pour les châssis coulissants, l''artisan inspecte systématiquement le système de roulement et lubrifie les charnières si nécessaire pour un glissement fluide.","frequency":"100%","impact":"Élimine les grincements et facilite la manipulation quotidienne.","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T06:42:10.430Z","proof":"https://reglage-porte.be/liege/huy-4500/"},{"label":"Seed: city hint","date":"2026-02-27T06:42:10.430Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T06:42:10.430Z","proof":"Chassis"},{"label":"Seed: search keyword","date":"2026-02-27T06:42:10.430Z","proof":"portes et fenetres"},{"label":"Extracted: city","date":"2026-02-27T06:42:10.430Z","proof":"Huy Région Wallonneprovince De"},{"label":"BCE: mod97 valid","date":"2026-02-27T06:42:10.430Z","proof":"0688611116"},{"label":"Email extracted","date":"2026-02-27T06:42:10.430Z","proof":"info@devisgratuit.euphone"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T06:42:10.430Z","proof":"confidence=85/100"},{"label":"Phone extracted","date":"2026-02-27T06:42:10.430Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T06:42:10.430Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-reglage-de-porte-huy/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0688611116', 'Actif', 'BCE_CSV', '2026-02-27T06:38:57.338Z', '2026-02-27T06:38:57.338Z', 'CHASSIS VAN BRUXELLES', '2018-01-18', 'Personne morale', 'Société privée à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T06:42:10.430Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0688611116'
    AND c_existing.slug <> 'portes-et-fenetres-huy-reglage-de-porte-huy'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'portes-et-fenetres-huy-abb-bouchat', 'BE-WAL', 'A.b.b. Bouchat', 'Chassis', ARRAY['châssis sur mesure', 'isolation thermique', 'fenêtres sécurisées', 'rénovation toiture', 'projet clé en main', 'expertise locale huy', 'pose de châssis en bois', 'pose de châssis en pvc', 'pose de châssis en aluminium', 'installation de vérandas', 'réparation de pergolas', 'pose de portes sectionnelles']::text[], ARRAY['Pose de châssis en bois', 'Pose de châssis en pvc', 'Pose de châssis en aluminium', 'Installation de vérandas', 'Réparation de pergolas', 'Pose de portes sectionnelles']::text[], NULL, NULL, NULL, NULL, 'Huy', '4500', 'BE', 'Rue du Marais 10', 'https://www.abbbouchat.be/', NULL, NULL, NULL, NULL, 'info@abbbouchat.be', NULL, '+3285231111', '+3285231111', NULL, NULL, NULL, 'Huy', ARRAY['français']::text[], NULL, NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services de pose de châssis en bois?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Quelles communes sont couvertes en priorité?","answer":"Les interventions se déroulent à Huy et dans les communes avoisinantes, selon la nature de la demande."}]'::jsonb, 'A.B.B. Bouchat est un spécialiste des châssis depuis plus de 40 ans, intervenant dans les provinces de Liège et Namur avec une expertise reconnue en pose de fenêtres, portes et solutions d''isolation. L''entreprise familiale basée à Huy propose des produits sur mesure en bois, PVC ou aluminium, adaptés aux projets neufs comme aux rénovations.', 'Portes et fenêtres à Huy | A.b.b. Bouchat', 'Châssis sur mesure avec test d''étanchéité systématique pour une isolation thermique optimale. Expertise locale à Huy depuis des années.', 'A.b.b. Bouchat - Portes et fenêtres à Huy', 'Pose de châssis en bois, PVC ou aluminium, vérandas et portes sectionnelles. Conseil personnalisé et nettoyage post-installation inclus.', '{"@context":"https://schema.org","@type":"HomeAndConstructionBusiness","name":"A.b.b. Bouchat","description":"Pose de châssis, vérandas et portes sectionnelles à Huy avec expertise locale.","url":"https://revelys.be/entreprises/portes-et-fenetres-huy-abb-bouchat","sameAs":["https://www.abbbouchat.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue du Marais 10","postalCode":"4500","addressLocality":"Huy","addressCountry":"BE"},"areaServed":"Huy","keywords":["châssis sur mesure","isolation thermique","fenêtres sécurisées","rénovation toiture","projet clé en main","expertise locale huy","pose de châssis en bois","pose de châssis en pvc","pose de châssis en aluminium","installation de vérandas","réparation de pergolas","pose de portes sectionnelles"],"image":["https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/logo.webp","https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/cover.webp"]}'::jsonb, '2026-02-27T06:46:44.746Z', TRUE, 5, '104f0d508cf8d0609dde83e0acc5eed664ec087ba33f6d92e5c261ffd0c69005', 'Chez A.B.B. Bouchat, nous combinons savoir-faire artisanal et produits haut de gamme pour des solutions durables qui préservent votre confort et votre budget.', NULL, 'Sérénité', '[{"name":"Test d''étanchéité","description":"Chaque châssis installé est soumis à un test de pression pour vérifier l''absence de fuites avant la finalisation des travaux.","frequency":"toujours","impact":"garantie qualité","proof":null},{"name":"Conseil personnalisé","description":"Un technicien se déplace pour analyser les besoins spécifiques du projet et proposer des solutions adaptées à l''architecture existante.","frequency":"toujours","impact":"solution optimale","proof":null},{"name":"Nettoyage post-installation","description":"Les équipes enlèvent systématiquement les déchets et nettoient les surfaces après la pose des châssis pour un rendu impeccable.","frequency":"toujours","impact":"finition soignée","proof":null}]'::jsonb, 90, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T06:47:33.770Z","proof":"https://www.abbbouchat.be/"},{"label":"Seed: city hint","date":"2026-02-27T06:47:33.770Z","proof":"Huy"},{"label":"Seed: industry category","date":"2026-02-27T06:47:33.770Z","proof":"Chassis"},{"label":"Seed: search keyword","date":"2026-02-27T06:47:33.770Z","proof":"portes et fenetres"},{"label":"Extracted: city","date":"2026-02-27T06:47:33.770Z","proof":""},{"label":"BCE: mod97 valid","date":"2026-02-27T06:47:33.770Z","proof":"0437978457"},{"label":"Email extracted","date":"2026-02-27T06:47:33.770Z","proof":"info@abbbouchat.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T06:47:33.770Z","proof":"confidence=80/100"},{"label":"Phone extracted","date":"2026-02-27T06:47:33.770Z","proof":"source=tel_link"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T06:47:33.770Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/portes-et-fenetres-huy-abb-bouchat/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0437978457', 'Actif', 'BCE_CSV', '2026-02-27T06:42:12.196Z', '2026-02-27T06:42:12.196Z', 'A.B.B. BOUCHAT', '1989-08-01', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T06:47:33.770Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0437978457'
    AND c_existing.slug <> 'portes-et-fenetres-huy-abb-bouchat'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

INSERT INTO companies (slug, market, name, industry, tags, services, pricing_model, budget_level, price_indication, devis_gratuit, city, postal_code, country, address, website, facebook, instagram, linkedin, tiktok, contact_email, contact_name, contact_phone, public_phone, founder_name, founder_role, founder_photo_url, ideal_zone, languages, availability, opening_hours, google_rating, google_reviews_count, google_reviews, company_faq, description, seo_title, seo_description, og_title, og_description, seo_jsonld, seo_generated_at, seo_ai_used, seo_version, seo_last_inputs_hash, why_company, why_entrepreneur, emotional_need_label, rituals, ras_score, logo_url, cover_image_url, gallery_urls, video_urls, video_embed_url, tier, verification_status, verification_checks, content_status, is_claimed, opt_out_status, bce_number, bce_status, bce_source, bce_verified_at, bce_last_checked_at, bce_legal_name, founded_on, bce_type_of_enterprise, bce_juridical_form, bce_juridical_situation, bce_source_update_date, created_at)
SELECT 'chauffagiste-seraing-comfort-gilson', 'BE-WAL', 'Comfort Gilson', 'Chauffagiste', ARRAY['désembouage radiateurs', 'urgence chauffage', 'ventilation double flux', 'salle de bain moderne', 'intervention rapide', 'produits fernox', 'disponibilité week-end', 'installation de chaudières gaz & mazout', 'entretien de annuel certifié peb', 'pompes à chaleur & chauffage par le sol', 'dépannage chauffage 7j 7', 'installation de & rénovation de salles de bain']::text[], ARRAY['Installation de chaudières gaz & mazout', 'Entretien de annuel certifié peb', 'Pompes à chaleur & chauffage par le sol', 'Dépannage chauffage 7j 7', 'Installation de & rénovation de salles de bain', 'Réparation de fuites et tuyauteries']::text[], 'sur_devis', NULL, NULL, NULL, 'Seraing', '4100', 'BE', 'Rue Jean de Seraing 97', 'https://comfortgilson.be/', NULL, NULL, NULL, NULL, 'info@comfortgilson.be', NULL, '+3243372441', '+3243372441', NULL, NULL, NULL, 'Seraing', ARRAY['français']::text[], '24h/24 - 7j/7', NULL, NULL, NULL, NULL, '[{"question":"Proposez-vous des services d''installation de chaudières gaz & mazout?","answer":"Oui, cette prestation fait partie des interventions proposées, avec vérification sur place avant réalisation."},{"question":"Intervenez-vous au-delà de la zone principale?","answer":"La zone principale est Seraing. Les interventions peuvent s''étendre aux communes limitrophes selon le besoin."},{"question":"Comment contrôlez-vous la qualité de votre travail?","answer":"Des vérifications sont effectuées à chaque étape de l''intervention, avec un contrôle final avant la clôture du chantier."},{"question":"Gérez-vous les interventions urgentes?","answer":"Oui, l''organisation permet de répondre aux demandes urgentes (24h/24 - 7j/7)."},{"question":"Qu''est-ce qui vous distingue sur votre marche local?","answer":"Chez Comfort Gilson, nous mettons notre expertise familiale et notre réactivité au service de votre confort. Notre engagement personnel garantit des interventions soignées et un suivi attentif pour toutes vos installations."}]'::jsonb, 'Comfort Gilson est une entreprise familiale spécialisée dans les installations de chauffage, sanitaires et ventilation à Seraing et en province de Liège. Dirigée par deux frères passionnés depuis plus de 20 ans, elle propose des solutions sur mesure pour particuliers et professionnels, avec une disponibilité 7j/7 pour les urgences.', 'Chauffagiste à Seraing | Comfort Gilson', 'Intervention rapide pour dépannage chauffage 7j/7. Utilisation de produits Fernox certifiés. Expertise locale à Seraing.', 'Comfort Gilson - Chauffagiste à Seraing', 'Installation, entretien et dépannage de chaudières gaz & mazout. Pompes à chaleur et rénovation de salles de bain à Seraing.', '{"@context":"https://schema.org","@type":"HeatingAndAirConditioningHVACBusiness","name":"Comfort Gilson","description":"Chauffagiste spécialisé en installation, entretien et dépannage de systèmes de chauffage à Seraing.","url":"https://revelys.be/entreprises/chauffagiste-seraing-comfort-gilson","sameAs":["https://comfortgilson.be/"],"address":{"@type":"PostalAddress","streetAddress":"Rue Jean de Seraing 97","postalCode":"4100","addressLocality":"Seraing","addressCountry":"BE"},"areaServed":{"@type":"City","name":"Seraing"},"keywords":["désembouage radiateurs","urgence chauffage","ventilation double flux","salle de bain moderne","intervention rapide","produits fernox","disponibilité week-end","installation de chaudières gaz & mazout","entretien de annuel certifié peb","pompes à chaleur & chauffage par le sol","dépannage chauffage 7j 7","installation de & rénovation de salles de bain"],"image":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/logo.webp","logo":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/logo.webp"}'::jsonb, '2026-02-27T07:50:48.429Z', TRUE, 5, '7ace49c4aef14c249025244462e47d3403b03234c8fc2fea7be33aefd14a82f8', 'Chez Comfort Gilson, nous mettons notre expertise familiale et notre réactivité au service de votre confort. Notre engagement personnel garantit des interventions soignées et un suivi attentif pour toutes vos installations.', NULL, 'Soulagement', '[{"name":"Désembouage complet avec Fernox","description":"Nous utilisons les produits Fernox, référence du secteur, pour nettoyer en profondeur vos radiateurs et améliorer l''efficacité de votre chauffage. Cette opération élimine la boue accumulée qui réduit la chaleur et","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Test de pression sur canalisations","description":"Après toute réparation ou installation, nous effectuons un test de pression pour vérifier l''étanchéité des tuyauteries et prévenir les fuites futures.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null},{"name":"Nettoyage des conduits de ventilation","description":"Nous procédons à un nettoyage minutieux des conduits pour garantir une qualité d''air optimale et le bon fonctionnement de vos systèmes de ventilation.","frequency":"Selon le besoin","impact":"Améliore la fiabilité et la qualité d''exécution.","proof":null}]'::jsonb, 98, 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/logo.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/cover.webp', ARRAY['https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/g1.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/g2.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/g3.webp', 'https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/g4.webp']::text[], ARRAY[]::text[], NULL, 'listed', 'pending', '[{"label":"Seed: site crawl","date":"2026-02-27T07:51:40.678Z","proof":"https://comfortgilson.be/"},{"label":"Seed: city hint","date":"2026-02-27T07:51:40.678Z","proof":"Seraing"},{"label":"Seed: industry category","date":"2026-02-27T07:51:40.678Z","proof":"Chauffagiste"},{"label":"Seed: search keyword","date":"2026-02-27T07:51:40.678Z","proof":"Chauffagiste"},{"label":"Extracted: city","date":"2026-02-27T07:51:40.678Z","proof":"Seraing"},{"label":"BCE: mod97 valid","date":"2026-02-27T07:51:40.678Z","proof":"0825382007"},{"label":"Email extracted","date":"2026-02-27T07:51:40.678Z","proof":"info@comfortgilson.be"},{"label":"LLM structured (mistral-small3.2:24b-instruct-q5_k_m)","date":"2026-02-27T07:51:40.678Z","proof":"confidence=90/100"},{"label":"Phone extracted","date":"2026-02-27T07:51:40.678Z","proof":"source=text"},{"label":"Images uploaded (Supabase Storage)","date":"2026-02-27T07:51:40.678Z","proof":"https://wijfqcxgpixftxcarczq.supabase.co/storage/v1/object/public/company-assets/companies/chauffagiste-seraing-comfort-gilson/cover.webp"}]'::jsonb, 'published', FALSE, 'none', 'BE0825382007', 'Actif', 'BCE_CSV', '2026-02-27T07:48:06.980Z', '2026-02-27T07:48:06.980Z', 'COMFORT GILSON', '2010-04-27', 'Personne morale', 'Société à responsabilité limitée', 'Situation normale', '2026-02-11', '2026-02-27T07:51:40.678Z'
WHERE NOT EXISTS (
  SELECT 1
  FROM companies c_existing
  WHERE c_existing.bce_number = 'BE0825382007'
    AND c_existing.slug <> 'chauffagiste-seraing-comfort-gilson'
)
ON CONFLICT (slug) DO UPDATE SET market = EXCLUDED.market, name = EXCLUDED.name, industry = EXCLUDED.industry, tags = EXCLUDED.tags, services = EXCLUDED.services, pricing_model = EXCLUDED.pricing_model, budget_level = EXCLUDED.budget_level, price_indication = EXCLUDED.price_indication, devis_gratuit = EXCLUDED.devis_gratuit, city = EXCLUDED.city, postal_code = EXCLUDED.postal_code, country = EXCLUDED.country, address = EXCLUDED.address, website = EXCLUDED.website, facebook = EXCLUDED.facebook, instagram = EXCLUDED.instagram, linkedin = EXCLUDED.linkedin, tiktok = EXCLUDED.tiktok, contact_email = EXCLUDED.contact_email, contact_name = EXCLUDED.contact_name, contact_phone = EXCLUDED.contact_phone, public_phone = EXCLUDED.public_phone, founder_name = EXCLUDED.founder_name, founder_role = EXCLUDED.founder_role, founder_photo_url = EXCLUDED.founder_photo_url, ideal_zone = EXCLUDED.ideal_zone, languages = EXCLUDED.languages, availability = EXCLUDED.availability, opening_hours = EXCLUDED.opening_hours, google_rating = EXCLUDED.google_rating, google_reviews_count = EXCLUDED.google_reviews_count, google_reviews = EXCLUDED.google_reviews, company_faq = EXCLUDED.company_faq, description = EXCLUDED.description, seo_title = EXCLUDED.seo_title, seo_description = EXCLUDED.seo_description, og_title = EXCLUDED.og_title, og_description = EXCLUDED.og_description, seo_jsonld = EXCLUDED.seo_jsonld, seo_generated_at = EXCLUDED.seo_generated_at, seo_ai_used = EXCLUDED.seo_ai_used, seo_version = EXCLUDED.seo_version, seo_last_inputs_hash = EXCLUDED.seo_last_inputs_hash, why_company = EXCLUDED.why_company, why_entrepreneur = EXCLUDED.why_entrepreneur, emotional_need_label = EXCLUDED.emotional_need_label, rituals = EXCLUDED.rituals, ras_score = EXCLUDED.ras_score, logo_url = EXCLUDED.logo_url, cover_image_url = EXCLUDED.cover_image_url, gallery_urls = EXCLUDED.gallery_urls, video_urls = EXCLUDED.video_urls, video_embed_url = EXCLUDED.video_embed_url, tier = EXCLUDED.tier, verification_status = EXCLUDED.verification_status, verification_checks = EXCLUDED.verification_checks, content_status = EXCLUDED.content_status, is_claimed = EXCLUDED.is_claimed, opt_out_status = EXCLUDED.opt_out_status, bce_number = EXCLUDED.bce_number, bce_status = EXCLUDED.bce_status, bce_source = EXCLUDED.bce_source, bce_verified_at = EXCLUDED.bce_verified_at, bce_last_checked_at = EXCLUDED.bce_last_checked_at, bce_legal_name = EXCLUDED.bce_legal_name, founded_on = EXCLUDED.founded_on, bce_type_of_enterprise = EXCLUDED.bce_type_of_enterprise, bce_juridical_form = EXCLUDED.bce_juridical_form, bce_juridical_situation = EXCLUDED.bce_juridical_situation, bce_source_update_date = EXCLUDED.bce_source_update_date
WHERE companies.is_claimed IS NOT TRUE;

