Symfony Profiler

SELECT
  v0_.nom_ville AS nom_ville_0
FROM
  fusacq_dbo.villes v0_
WHERE
  v0_.code_departement LIKE ?
ORDER BY
  v0_.population DESC
LIMIT
  3

SELECT v0_.nom_ville AS nom_ville_0 FROM fusacq_dbo.villes v0_ WHERE v0_.code_departement LIKE '41_04%' ORDER BY v0_.population DESC LIMIT 3;

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_localisations_recherchees LIKE '41,%' OR a0_.id_localisations_recherchees LIKE '41' OR a0_.id_localisations_recherchees LIKE '%,41,%' OR a0_.id_localisations_recherchees LIKE '%,41' OR a0_.id_localisations_recherchees LIKE '41_04,%' OR a0_.id_localisations_recherchees LIKE '41_04' OR a0_.id_localisations_recherchees LIKE '%,41_04,%' OR a0_.id_localisations_recherchees LIKE '%,41_04' OR a0_.id_localisations_recherchees LIKE '%,41_04_01%' OR a0_.id_localisations_recherchees LIKE '41_04_01%');

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    (
      a0_.id_departement = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND ((a0_.id_departement = '41_04_01' OR a0_.autres_localisations LIKE '41_04_01%' OR a0_.autres_localisations LIKE '%,41_04_01%')) AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s2_ ON (
    s2_.id_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '41_04');

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND (
    (
      a0_.id_departement = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND ((a0_.id_departement = '41_04_01' OR a0_.autres_localisations LIKE '41_04_01%' OR a0_.autres_localisations LIKE '%,41_04_01%'));

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.id_localisations_recherchees LIKE '41,%' OR a0_.id_localisations_recherchees LIKE '41' OR a0_.id_localisations_recherchees LIKE '%,41,%' OR a0_.id_localisations_recherchees LIKE '%,41' OR a0_.id_localisations_recherchees LIKE '41_04,%' OR a0_.id_localisations_recherchees LIKE '41_04' OR a0_.id_localisations_recherchees LIKE '%,41_04,%' OR a0_.id_localisations_recherchees LIKE '%,41_04' OR a0_.id_localisations_recherchees LIKE '%,41_04_99%' OR a0_.id_localisations_recherchees LIKE '41_04_99%');

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    (
      a0_.id_departement = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND ((a0_.id_departement = '41_04_99' OR a0_.autres_localisations LIKE '41_04_99%' OR a0_.autres_localisations LIKE '%,41_04_99%')) AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s2_ ON (
    s2_.id_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '41_04');

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND (
    (
      a0_.id_departement = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND ((a0_.id_departement = '41_04_99' OR a0_.autres_localisations LIKE '41_04_99%' OR a0_.autres_localisations LIKE '%,41_04_99%'));

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND (
    (
      a0_.id_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
      )
    )
  )
  AND (
    a0_.demarche LIKE '%reprise_majoritaire%'
    OR a0_.demarche LIKE '%association_minoritaire%'
  )
  AND (
    a0_.investissement_possible = 'oui'
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND ((a0_.id_region = '41_04' OR a0_.id_region = '41_99' OR a0_.autres_localisations LIKE '41_04%' OR a0_.autres_localisations LIKE '%,41_04%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '41' OR a0_.autres_localisations LIKE '41' OR a0_.autres_localisations LIKE '41%' OR a0_.autres_localisations LIKE '%,41%' OR a0_.autres_localisations LIKE '%,41'))) AND (a0_.demarche LIKE '%reprise_majoritaire%' OR a0_.demarche LIKE '%association_minoritaire%') AND (a0_.investissement_possible = 'oui');

SELECT
  COUNT(DISTINCT a0_.id_repreneur) AS sclr_0
FROM
  fusacq_dbo.annuaire_repreneurs a0_
WHERE
  (a0_.mode_profil = 'publique')
  AND (
    a0_.demarche LIKE '%3%'
    OR a0_.demarche LIKE '%4%'
  )
  AND (
    a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
    OR a0_.id_localisations_recherchees LIKE ?
  )

SELECT COUNT(DISTINCT a0_.id_repreneur) AS sclr_0 FROM fusacq_dbo.annuaire_repreneurs a0_ WHERE (a0_.mode_profil = 'publique') AND (a0_.demarche LIKE '%3%' OR a0_.demarche LIKE '%4%') AND (a0_.id_localisations_recherchees LIKE '41,%' OR a0_.id_localisations_recherchees LIKE '41' OR a0_.id_localisations_recherchees LIKE '%,41,%' OR a0_.id_localisations_recherchees LIKE '%,41' OR a0_.id_localisations_recherchees LIKE '%,41_04%' OR a0_.id_localisations_recherchees LIKE '41_04%');

SELECT
  COUNT(
    DISTINCT s0_.id_gestionnaire_fonds
  ) AS sclr_0
FROM
  fusacq_dbo.societe_gestionnaire_fonds s0_
  INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (
    l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds
  )
  INNER JOIN fusacq_dbo.societes s2_ ON (
    s2_.id_societe = l1_.id_participation
  )
WHERE
  s2_.mode_participation = 'publique'
  AND l1_.mode = 'publique'
  AND s0_.mode = 'publique'
  AND s2_.mode_societe = 'publique'
  AND s0_.stade_investissement LIKE '%4%'
  AND (s0_.id_region = ?)

SELECT COUNT(DISTINCT s0_.id_gestionnaire_fonds) AS sclr_0 FROM fusacq_dbo.societe_gestionnaire_fonds s0_ INNER JOIN fusacq_dbo.lien_participations_fonds l1_ ON (l1_.id_gestionnaire_fonds = s0_.id_gestionnaire_fonds) INNER JOIN fusacq_dbo.societes s2_ ON (s2_.id_societe = l1_.id_participation) WHERE s2_.mode_participation = 'publique' AND l1_.mode = 'publique' AND s0_.mode = 'publique' AND s2_.mode_societe = 'publique' AND s0_.stade_investissement LIKE '%4%' AND (s0_.id_region = '41_04');

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC;

SELECT
  COUNT(
    DISTINCT a0_.id_annonce_acheteur
  ) AS sclr_0
FROM
  fusacq_dbo.annonces_acheteur a0_
WHERE
  a0_.date_parution_initiale IS NOT NULL
  AND a0_.mode_annonce = 'publique'
  AND a0_.tpe_pme = 'oui'
  AND a0_.type_raprochement = 'partenaire'
  AND (
    (
      a0_.id_region = ?
      OR a0_.id_region = ?
      OR a0_.autres_localisations LIKE ?
      OR a0_.autres_localisations LIKE ?
    )
    OR (
      (
        a0_.id_region LIKE ''
        OR a0_.id_region IS NULL
      )
      AND (
        a0_.id_pays = ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
        OR a0_.autres_localisations LIKE ?
      )
    )
  )

SELECT COUNT(DISTINCT a0_.id_annonce_acheteur) AS sclr_0 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.date_parution_initiale IS NOT NULL AND a0_.mode_annonce = 'publique' AND a0_.tpe_pme = 'oui' AND a0_.type_raprochement = 'partenaire' AND ((a0_.id_region = '41_04' OR a0_.id_region = '41_99' OR a0_.autres_localisations LIKE '41_04%' OR a0_.autres_localisations LIKE '%,41_04%') OR ((a0_.id_region LIKE '' OR a0_.id_region IS NULL) AND (a0_.id_pays = '41' OR a0_.autres_localisations LIKE '41' OR a0_.autres_localisations LIKE '41%' OR a0_.autres_localisations LIKE '%,41%' OR a0_.autres_localisations LIKE '%,41')));

SELECT
  COUNT(DISTINCT i0_.id_investisseur) AS sclr_0
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )

SELECT COUNT(DISTINCT i0_.id_investisseur) AS sclr_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL);

SELECT
  DISTINCT i0_.id_investisseur AS id_investisseur_0,
  i0_.id_investisseur AS id_investisseur_1
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
ORDER BY
  i0_.id_investisseur DESC
LIMIT
  10

SELECT DISTINCT i0_.id_investisseur AS id_investisseur_0, i0_.id_investisseur AS id_investisseur_1 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL) ORDER BY i0_.id_investisseur DESC LIMIT 10;

SELECT
  i0_.id_investisseur AS id_investisseur_0,
  i0_.id_localisations_recherchees AS id_localisations_recherchees_1,
  i0_.titre_investisseur AS titre_investisseur_2,
  i0_.id_secteurs_activite AS id_secteurs_activite_3,
  i0_.prenom_contact AS prenom_contact_4,
  i0_.nom_contact AS nom_contact_5,
  i0_.type_investisseur AS type_investisseur_6,
  i0_.montant_investissement_min AS montant_investissement_min_7,
  i0_.montant_investissement_max AS montant_investissement_max_8,
  i0_.capital_detenu AS capital_detenu_9
FROM
  fusacq_dbo.investisseurs_prives i0_
WHERE
  i0_.mode = 'publique'
  AND (
    i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees LIKE ?
    OR i0_.id_localisations_recherchees IS NULL
  )
  AND i0_.id_investisseur IN (?, ?, ?, ?)
ORDER BY
  i0_.id_investisseur DESC

SELECT i0_.id_investisseur AS id_investisseur_0, i0_.id_localisations_recherchees AS id_localisations_recherchees_1, i0_.titre_investisseur AS titre_investisseur_2, i0_.id_secteurs_activite AS id_secteurs_activite_3, i0_.prenom_contact AS prenom_contact_4, i0_.nom_contact AS nom_contact_5, i0_.type_investisseur AS type_investisseur_6, i0_.montant_investissement_min AS montant_investissement_min_7, i0_.montant_investissement_max AS montant_investissement_max_8, i0_.capital_detenu AS capital_detenu_9 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND (i0_.id_localisations_recherchees LIKE '%,41_04%' OR i0_.id_localisations_recherchees LIKE '%,41,%' OR i0_.id_localisations_recherchees LIKE '%,41' OR i0_.id_localisations_recherchees IS NULL) AND i0_.id_investisseur IN (548, 538, 513, 281) ORDER BY i0_.id_investisseur DESC;

SELECT
  c0_.id_commande AS id_commande_0
FROM
  fusacq_dbo.details_commande d1_
  INNER JOIN fusacq_dbo.commandes c0_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  c0_.id_cpte_utilisateur = ''
  AND d1_.id_annonce = 548
  AND d1_.type_annonce = 'investisseur_prive'
  AND (
    c0_.etat = 'facture_envoyee'
    OR c0_.etat = 'information_transmise'
    OR c0_.etat = 'cmde_valide'
    OR c0_.etat = 'commande_livree'
  )
LIMIT
  1

SELECT c0_.id_commande AS id_commande_0 FROM fusacq_dbo.details_commande d1_ INNER JOIN fusacq_dbo.commandes c0_ ON (d1_.id_commande = c0_.id_commande) WHERE c0_.id_cpte_utilisateur = '' AND d1_.id_annonce = 548 AND d1_.type_annonce = 'investisseur_prive' AND (c0_.etat = 'facture_envoyee' OR c0_.etat = 'information_transmise' OR c0_.etat = 'cmde_valide' OR c0_.etat = 'commande_livree') LIMIT 1;

SELECT
  c0_.id_commande AS id_commande_0
FROM
  fusacq_dbo.details_commande d1_
  INNER JOIN fusacq_dbo.commandes c0_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  c0_.id_cpte_utilisateur = ''
  AND d1_.id_annonce = 538
  AND d1_.type_annonce = 'investisseur_prive'
  AND (
    c0_.etat = 'facture_envoyee'
    OR c0_.etat = 'information_transmise'
    OR c0_.etat = 'cmde_valide'
    OR c0_.etat = 'commande_livree'
  )
LIMIT
  1

SELECT c0_.id_commande AS id_commande_0 FROM fusacq_dbo.details_commande d1_ INNER JOIN fusacq_dbo.commandes c0_ ON (d1_.id_commande = c0_.id_commande) WHERE c0_.id_cpte_utilisateur = '' AND d1_.id_annonce = 538 AND d1_.type_annonce = 'investisseur_prive' AND (c0_.etat = 'facture_envoyee' OR c0_.etat = 'information_transmise' OR c0_.etat = 'cmde_valide' OR c0_.etat = 'commande_livree') LIMIT 1;

SELECT
  c0_.id_commande AS id_commande_0
FROM
  fusacq_dbo.details_commande d1_
  INNER JOIN fusacq_dbo.commandes c0_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  c0_.id_cpte_utilisateur = ''
  AND d1_.id_annonce = 513
  AND d1_.type_annonce = 'investisseur_prive'
  AND (
    c0_.etat = 'facture_envoyee'
    OR c0_.etat = 'information_transmise'
    OR c0_.etat = 'cmde_valide'
    OR c0_.etat = 'commande_livree'
  )
LIMIT
  1

SELECT c0_.id_commande AS id_commande_0 FROM fusacq_dbo.details_commande d1_ INNER JOIN fusacq_dbo.commandes c0_ ON (d1_.id_commande = c0_.id_commande) WHERE c0_.id_cpte_utilisateur = '' AND d1_.id_annonce = 513 AND d1_.type_annonce = 'investisseur_prive' AND (c0_.etat = 'facture_envoyee' OR c0_.etat = 'information_transmise' OR c0_.etat = 'cmde_valide' OR c0_.etat = 'commande_livree') LIMIT 1;

SELECT
  c0_.id_commande AS id_commande_0
FROM
  fusacq_dbo.details_commande d1_
  INNER JOIN fusacq_dbo.commandes c0_ ON (
    d1_.id_commande = c0_.id_commande
  )
WHERE
  c0_.id_cpte_utilisateur = ''
  AND d1_.id_annonce = 281
  AND d1_.type_annonce = 'investisseur_prive'
  AND (
    c0_.etat = 'facture_envoyee'
    OR c0_.etat = 'information_transmise'
    OR c0_.etat = 'cmde_valide'
    OR c0_.etat = 'commande_livree'
  )
LIMIT
  1

SELECT c0_.id_commande AS id_commande_0 FROM fusacq_dbo.details_commande d1_ INNER JOIN fusacq_dbo.commandes c0_ ON (d1_.id_commande = c0_.id_commande) WHERE c0_.id_cpte_utilisateur = '' AND d1_.id_annonce = 281 AND d1_.type_annonce = 'investisseur_prive' AND (c0_.etat = 'facture_envoyee' OR c0_.etat = 'information_transmise' OR c0_.etat = 'cmde_valide' OR c0_.etat = 'commande_livree') LIMIT 1;