[2026-09-18 09:36:54] local.DEBUG: REQUETE {"sql":"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 THEN 'IR'
                        WHEN (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = ? and `cc`.`latitude` is not null and `cc`.`latitude` != ? and `cc`.`longitude` is not null and `cc`.`longitude` != ? limit 2000","bindings":[1,0,0]} 
[2026-09-18 09:39:43] local.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 THEN 'IR'
                        WHEN (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 11:59:36] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 12:02:34] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 12:56:46] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 14:09:13] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 14:11:40] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 limit 2000"} 
[2026-09-18 14:19:40] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 and (
                    cc.RefBEClient > 0
                    OR (cc.RefInstallUnique > 0 AND EXISTS (
                        SELECT 1 FROM TInstallateursCompte ic
                        WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                    ))
                    OR EXISTS (SELECT 1 FROM TClientsBE cb2 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1 AND cb2.isTP > 0)
                    OR COALESCE((SELECT cb2.TypeClient FROM TClientsBE cb2
                                 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                                 ORDER BY cb2.RefBE LIMIT 1), 'PRO') != 'ETUDE'
                ) limit 2000"} 
[2026-09-18 14:28:35] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 and (
                    cc.RefBEClient > 0
                    OR (cc.RefInstallUnique > 0 AND EXISTS (
                        SELECT 1 FROM TInstallateursCompte ic
                        WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                    ))
                    OR EXISTS (SELECT 1 FROM TClientsBE cb2 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1 AND cb2.isTP > 0)
                    OR COALESCE((SELECT cb2.TypeClient FROM TClientsBE cb2
                                 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                                 ORDER BY cb2.RefBE LIMIT 1), 'PRO') != 'ETUDE'
                )"} 
[2026-09-18 14:29:06] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 and (
                    cc.RefBEClient > 0
                    OR (cc.RefInstallUnique > 0 AND EXISTS (
                        SELECT 1 FROM TInstallateursCompte ic
                        WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                    ))
                    OR EXISTS (SELECT 1 FROM TClientsBE cb2 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1 AND cb2.isTP > 0)
                    OR COALESCE((SELECT cb2.TypeClient FROM TClientsBE cb2
                                 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                                 ORDER BY cb2.RefBE LIMIT 1), 'PRO') != 'ETUDE'
                )"} 
[2026-09-18 14:36:20] local.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 (SELECT cb2.isTP FROM TClientsBE cb2
                              WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                              ORDER BY cb2.RefBE LIMIT 1) > 0 THEN 'TP'
                        ELSE COALESCE(
                            (SELECT cb2.TypeClient FROM TClientsBE cb2
                             WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                             ORDER BY cb2.RefBE LIMIT 1),
                            'PRO'
                        )
                    END AS Typologie
                 from `TClientsCompte` as `cc` where `cc`.`Actif` = 1 and `cc`.`latitude` is not null and `cc`.`latitude` != 0 and `cc`.`longitude` is not null and `cc`.`longitude` != 0 and (
                    cc.RefBEClient > 0
                    OR (cc.RefInstallUnique > 0 AND EXISTS (
                        SELECT 1 FROM TInstallateursCompte ic
                        WHERE ic.RefInstallUnique = cc.RefInstallUnique AND ic.Actif = 1
                    ))
                    OR EXISTS (SELECT 1 FROM TClientsBE cb2 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1 AND cb2.isTP > 0)
                    OR COALESCE((SELECT cb2.TypeClient FROM TClientsBE cb2
                                 WHERE cb2.RefClientUnique = cc.RefClientUnique AND cb2.Actif = 1
                                 ORDER BY cb2.RefBE LIMIT 1), 'PRO') != 'ETUDE'
                )"}