[2026-09-18 14:09:14] local.DEBUG: getAnnuaire admin {"total":2000,"typologies":{"ETUDE":1751,"PRO":245,"Franchise":1,"INSTALL":1,"TP":2},"types_filter":["Projets","Installateurs"]} 
[2026-09-18 14:11:40] local.DEBUG: getAnnuaire admin {"total":2000,"typologies":{"ETUDE":1751,"PRO":245,"Franchise":1,"INSTALL":1,"TP":2},"types_filter":["Projets","Installateurs"]} 
[2026-09-18 14:19:41] local.DEBUG: getAnnuaire admin {"total":2000,"typologies":{"PRO":1697,"Franchise":64,"INSTALL":92,"TP":65,"IR":77,"BE":3,"ETUDE":1,"AUTRE":1},"types_filter":["Projets","Installateurs"]} 
[2026-09-18 14:28:36] local.DEBUG: getAnnuaire admin {"total":7379,"typologies":{"PRO":3989,"Franchise":133,"INSTALL":112,"TP":1517,"IR":186,"BE":67,"ETUDE":23,"AUTRE":552,"INSTALL_HS":27,"":770,"INSTALL_HR":3},"types_filter":["TP"]} 
[2026-09-18 14:29:07] local.DEBUG: getAnnuaire admin {"total":7379,"typologies":{"PRO":3989,"Franchise":133,"INSTALL":112,"TP":1517,"IR":186,"BE":67,"ETUDE":23,"AUTRE":552,"INSTALL_HS":27,"":770,"INSTALL_HR":3},"types_filter":["IR"]} 
[2026-09-18 14:36:21] local.DEBUG: getAnnuaire admin {"total":7379,"typologies":{"PRO":3989,"Franchise":133,"INSTALL":112,"TP":1517,"IR":186,"BE":67,"ETUDE":23,"AUTRE":552,"INSTALL_HS":27,"":770,"INSTALL_HR":3},"types_filter":["SPANCS"]} 
[2026-09-18 15:19:50] production.DEBUG: SQL {"query":"select 
                    cc.RefClientUnique AS id,
                    cc.Nom             AS nom,
                    cc.Prenom          AS prenom,
                    cc.RaisonSociale   AS raison_sociale,
                    cc.Ville           AS ville,
                    cc.CodePostal      AS code_postal,
                    cc.latitude,
                    cc.longitude,
                    CASE
                        WHEN cc.RefBEClient    > 0 THEN 'Franchise'
                        WHEN cc.RefInstallUnique > 0 AND EXISTS (
                            SELECT 1 FROM TInstallateursCompte ic
                            WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                        ) THEN 'IR'
                        WHEN cb.isTP           > 0 THEN 'TP'
                        ELSE cb.TypeClient
                    END AS Typologie
                 from `TClientsBE` as `cb` inner join `TClientsCompte` as `cc` on `cb`.`RefClientUnique` = `cc`.`RefClientUnique` where `cb`.`RefBE` = 25 and `cb`.`Actif` = 1 and `cb`.`TypeClient` != 'ETUDE' and `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0"} 
[2026-09-18 15:19:55] production.DEBUG: SQL {"query":"select 
                    cc.RefClientUnique AS id,
                    cc.Nom             AS nom,
                    cc.Prenom          AS prenom,
                    cc.RaisonSociale   AS raison_sociale,
                    cc.Ville           AS ville,
                    cc.CodePostal      AS code_postal,
                    cc.latitude,
                    cc.longitude,
                    CASE
                        WHEN cc.RefBEClient    > 0 THEN 'Franchise'
                        WHEN cc.RefInstallUnique > 0 AND EXISTS (
                            SELECT 1 FROM TInstallateursCompte ic
                            WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                        ) THEN 'IR'
                        WHEN cb.isTP           > 0 THEN 'TP'
                        ELSE cb.TypeClient
                    END AS Typologie
                 from `TClientsBE` as `cb` inner join `TClientsCompte` as `cc` on `cb`.`RefClientUnique` = `cc`.`RefClientUnique` where `cb`.`RefBE` = 25 and `cb`.`Actif` = 1 and `cb`.`TypeClient` != 'ETUDE' and `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0"} 
[2026-09-18 15:28:53] production.DEBUG: SQL {"query":"select 
                    cc.RefClientUnique AS id,
                    cc.Nom             AS nom,
                    cc.Prenom          AS prenom,
                    cc.RaisonSociale   AS raison_sociale,
                    cc.Ville           AS ville,
                    cc.CodePostal      AS code_postal,
                    cc.latitude,
                    cc.longitude,
                    CASE
                        WHEN cc.RefBEClient    > 0 THEN 'Franchise'
                        WHEN cc.RefInstallUnique > 0 AND EXISTS (
                            SELECT 1 FROM TInstallateursCompte ic
                            WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                        ) THEN 'IR'
                        WHEN cb.isTP           > 0 THEN 'TP'
                        ELSE cb.TypeClient
                    END AS Typologie
                 from `TClientsBE` as `cb` inner join `TClientsCompte` as `cc` on `cb`.`RefClientUnique` = `cc`.`RefClientUnique` where `cb`.`RefBE` = 25 and `cb`.`Actif` = 1 and `cb`.`TypeClient` != 'ETUDE' and `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0"}