Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      priorite_19
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.nom AS nom_1,
          p0_.numero AS numero_2,
          p0_.voie AS voie_3,
          p0_.complement AS complement_4,
          p0_.boite_postal AS boite_postal_5,
          p0_.commune AS commune_6,
          p0_.image AS image_7,
          p0_.description AS description_8,
          p0_.analyse AS analyse_9,
          p0_.pc_salarie AS pc_salarie_10,
          p0_.date_livraison_text AS date_livraison_text_11,
          p0_.date_livraison_date AS date_livraison_date_12,
          p0_.id_programme_promoteur AS id_programme_promoteur_13,
          p0_.actif AS actif_14,
          p0_.lat AS lat_15,
          p0_.lng AS lng_16,
          p0_.regle_prix AS regle_prix_17,
          p0_.visible AS visible_18,
          p0_.priorite AS priorite_19,
          p0_.regle_prix_allotement AS regle_prix_allotement_20,
          p0_.creer_le AS creer_le_21,
          l1_.id AS id_22,
          l1_.numero_lot AS numero_lot_23,
          l1_.piece AS piece_24,
          l1_.surface AS surface_25,
          l1_.surface_ponderee AS surface_ponderee_26,
          l1_.etage AS etage_27,
          l1_.exposition AS exposition_28,
          l1_.type_bien AS type_bien_29,
          l1_.prix_ttc AS prix_ttc_30,
          l1_.prix_ht AS prix_ht_31,
          l1_.loyer AS loyer_32,
          l1_.nb_option AS nb_option_33,
          l1_.allotement AS allotement_34,
          l1_.imported_at AS imported_at_35,
          l1_.actif AS actif_36
        FROM
          Programme p0_
          LEFT JOIN Lot l1_ ON p0_.id = l1_.programme_id
          LEFT JOIN RegionDepCP r2_ ON p0_.code_postal_id = r2_.code_postal
          INNER JOIN Promoteur p3_ ON p0_.promoteur_id = p3_.id
          LEFT JOIN lot_annexe l5_ ON l1_.id = l5_.lot_id
          LEFT JOIN Annexe a4_ ON a4_.id = l5_.annexe_id
          LEFT JOIN lot_fiscalite l7_ ON l1_.id = l7_.lot_id
          LEFT JOIN Fiscalite f6_ ON f6_.id = l7_.fiscalite_id
          LEFT JOIN lot_options l8_ ON l1_.active_option = l8_.id
        WHERE
          (
            p0_.actif = ?
            AND l1_.actif = ?
          )
          AND l1_.allotement = ?
      ) dctrn_result_inner
    ORDER BY
      priorite_19 DESC
  ) dctrn_result
LIMIT
  50
OFFSET
  100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, priorite_19 FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.numero AS numero_2, p0_.voie AS voie_3, p0_.complement AS complement_4, p0_.boite_postal AS boite_postal_5, p0_.commune AS commune_6, p0_.image AS image_7, p0_.description AS description_8, p0_.analyse AS analyse_9, p0_.pc_salarie AS pc_salarie_10, p0_.date_livraison_text AS date_livraison_text_11, p0_.date_livraison_date AS date_livraison_date_12, p0_.id_programme_promoteur AS id_programme_promoteur_13, p0_.actif AS actif_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.regle_prix AS regle_prix_17, p0_.visible AS visible_18, p0_.priorite AS priorite_19, p0_.regle_prix_allotement AS regle_prix_allotement_20, p0_.creer_le AS creer_le_21, l1_.id AS id_22, l1_.numero_lot AS numero_lot_23, l1_.piece AS piece_24, l1_.surface AS surface_25, l1_.surface_ponderee AS surface_ponderee_26, l1_.etage AS etage_27, l1_.exposition AS exposition_28, l1_.type_bien AS type_bien_29, l1_.prix_ttc AS prix_ttc_30, l1_.prix_ht AS prix_ht_31, l1_.loyer AS loyer_32, l1_.nb_option AS nb_option_33, l1_.allotement AS allotement_34, l1_.imported_at AS imported_at_35, l1_.actif AS actif_36 FROM Programme p0_ LEFT JOIN Lot l1_ ON p0_.id = l1_.programme_id LEFT JOIN RegionDepCP r2_ ON p0_.code_postal_id = r2_.code_postal INNER JOIN Promoteur p3_ ON p0_.promoteur_id = p3_.id LEFT JOIN lot_annexe l5_ ON l1_.id = l5_.lot_id LEFT JOIN Annexe a4_ ON a4_.id = l5_.annexe_id LEFT JOIN lot_fiscalite l7_ ON l1_.id = l7_.lot_id LEFT JOIN Fiscalite f6_ ON f6_.id = l7_.fiscalite_id LEFT JOIN lot_options l8_ ON l1_.active_option = l8_.id WHERE (p0_.actif = 1 AND l1_.actif = 1) AND l1_.allotement = 0) dctrn_result_inner ORDER BY priorite_19 DESC) dctrn_result LIMIT 50 OFFSET 100;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.numero AS numero_2,
  p0_.voie AS voie_3,
  p0_.complement AS complement_4,
  p0_.boite_postal AS boite_postal_5,
  p0_.commune AS commune_6,
  p0_.image AS image_7,
  p0_.description AS description_8,
  p0_.analyse AS analyse_9,
  p0_.pc_salarie AS pc_salarie_10,
  p0_.date_livraison_text AS date_livraison_text_11,
  p0_.date_livraison_date AS date_livraison_date_12,
  p0_.id_programme_promoteur AS id_programme_promoteur_13,
  p0_.actif AS actif_14,
  p0_.lat AS lat_15,
  p0_.lng AS lng_16,
  p0_.regle_prix AS regle_prix_17,
  p0_.visible AS visible_18,
  p0_.priorite AS priorite_19,
  p0_.regle_prix_allotement AS regle_prix_allotement_20,
  p0_.creer_le AS creer_le_21,
  p0_.code_postal_id AS code_postal_id_22,
  p0_.promoteur_id AS promoteur_id_23,
  p0_.cover_id AS cover_id_24
FROM
  Programme p0_
  LEFT JOIN Lot l1_ ON p0_.id = l1_.programme_id
  LEFT JOIN RegionDepCP r2_ ON p0_.code_postal_id = r2_.code_postal
  INNER JOIN Promoteur p3_ ON p0_.promoteur_id = p3_.id
  LEFT JOIN lot_annexe l5_ ON l1_.id = l5_.lot_id
  LEFT JOIN Annexe a4_ ON a4_.id = l5_.annexe_id
  LEFT JOIN lot_fiscalite l7_ ON l1_.id = l7_.lot_id
  LEFT JOIN Fiscalite f6_ ON f6_.id = l7_.fiscalite_id
  LEFT JOIN lot_options l8_ ON l1_.active_option = l8_.id
WHERE
  (
    p0_.actif = ?
    AND l1_.actif = ?
  )
  AND l1_.allotement = ?
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.priorite DESC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.numero AS numero_2, p0_.voie AS voie_3, p0_.complement AS complement_4, p0_.boite_postal AS boite_postal_5, p0_.commune AS commune_6, p0_.image AS image_7, p0_.description AS description_8, p0_.analyse AS analyse_9, p0_.pc_salarie AS pc_salarie_10, p0_.date_livraison_text AS date_livraison_text_11, p0_.date_livraison_date AS date_livraison_date_12, p0_.id_programme_promoteur AS id_programme_promoteur_13, p0_.actif AS actif_14, p0_.lat AS lat_15, p0_.lng AS lng_16, p0_.regle_prix AS regle_prix_17, p0_.visible AS visible_18, p0_.priorite AS priorite_19, p0_.regle_prix_allotement AS regle_prix_allotement_20, p0_.creer_le AS creer_le_21, p0_.code_postal_id AS code_postal_id_22, p0_.promoteur_id AS promoteur_id_23, p0_.cover_id AS cover_id_24 FROM Programme p0_ LEFT JOIN Lot l1_ ON p0_.id = l1_.programme_id LEFT JOIN RegionDepCP r2_ ON p0_.code_postal_id = r2_.code_postal INNER JOIN Promoteur p3_ ON p0_.promoteur_id = p3_.id LEFT JOIN lot_annexe l5_ ON l1_.id = l5_.lot_id LEFT JOIN Annexe a4_ ON a4_.id = l5_.annexe_id LEFT JOIN lot_fiscalite l7_ ON l1_.id = l7_.lot_id LEFT JOIN Fiscalite f6_ ON f6_.id = l7_.fiscalite_id LEFT JOIN lot_options l8_ ON l1_.active_option = l8_.id WHERE (p0_.actif = 1 AND l1_.actif = 1) AND l1_.allotement = 0 AND p0_.id IN (4224, 3470, 3925, 2018, 2932, 4149, 1776, 2630, 4113, 1528, 1607, 1917, 2061, 2680, 2909, 3518, 3681, 3899, 4017, 4125, 2459, 1895, 1573, 2538, 3331, 3853, 4043, 2242, 2306, 2793, 2955, 3711, 4014, 4187, 4241, 4295, 4250, 3097, 3167, 3204, 3239, 3272, 3326, 3651, 3972, 4056, 4131, 967, 1559, 2778) ORDER BY p0_.priorite DESC;

SELECT
  t0.code_postal AS code_postal_1,
  t0.code_departement AS code_departement_2,
  t0.nom_departement AS nom_departement_3,
  t0.code_region AS code_region_4,
  t0.nom_region AS nom_region_5
FROM
  RegionDepCP t0
WHERE
  t0.code_postal = ?

SELECT t0.code_postal AS code_postal_1, t0.code_departement AS code_departement_2, t0.nom_departement AS nom_departement_3, t0.code_region AS code_region_4, t0.nom_region AS nom_region_5 FROM RegionDepCP t0 WHERE t0.code_postal = '54100';

SELECT
  t0.id AS id_1,
  t0.numero_lot AS numero_lot_2,
  t0.piece AS piece_3,
  t0.surface AS surface_4,
  t0.surface_ponderee AS surface_ponderee_5,
  t0.etage AS etage_6,
  t0.exposition AS exposition_7,
  t0.type_bien AS type_bien_8,
  t0.prix_ttc AS prix_ttc_9,
  t0.prix_ht AS prix_ht_10,
  t0.loyer AS loyer_11,
  t0.nb_option AS nb_option_12,
  t0.allotement AS allotement_13,
  t0.imported_at AS imported_at_14,
  t0.actif AS actif_15,
  t0.statut_id AS statut_id_16,
  t0.fiscalite_id AS fiscalite_id_17,
  t0.programme_id AS programme_id_18,
  t0.active_option AS active_option_19
FROM
  Lot t0
WHERE
  t0.programme_id = ?

SELECT t0.id AS id_1, t0.numero_lot AS numero_lot_2, t0.piece AS piece_3, t0.surface AS surface_4, t0.surface_ponderee AS surface_ponderee_5, t0.etage AS etage_6, t0.exposition AS exposition_7, t0.type_bien AS type_bien_8, t0.prix_ttc AS prix_ttc_9, t0.prix_ht AS prix_ht_10, t0.loyer AS loyer_11, t0.nb_option AS nb_option_12, t0.allotement AS allotement_13, t0.imported_at AS imported_at_14, t0.actif AS actif_15, t0.statut_id AS statut_id_16, t0.fiscalite_id AS fiscalite_id_17, t0.programme_id AS programme_id_18, t0.active_option AS active_option_19 FROM Lot t0 WHERE t0.programme_id = 1528;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero AS numero_3,
  t0.voie AS voie_4,
  t0.complement AS complement_5,
  t0.boite_postal AS boite_postal_6,
  t0.code_postal AS code_postal_7,
  t0.commune AS commune_8,
  t0.telephone AS telephone_9,
  t0.site_partenaire AS site_partenaire_10,
  t0.url_xml AS url_xml_11,
  t0.fix_xml AS fix_xml_12,
  t0.regle_prix AS regle_prix_13,
  t0.keep_flux_documents AS keep_flux_documents_14,
  t0.account_id AS account_id_15
FROM
  Promoteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero AS numero_3, t0.voie AS voie_4, t0.complement AS complement_5, t0.boite_postal AS boite_postal_6, t0.code_postal AS code_postal_7, t0.commune AS commune_8, t0.telephone AS telephone_9, t0.site_partenaire AS site_partenaire_10, t0.url_xml AS url_xml_11, t0.fix_xml AS fix_xml_12, t0.regle_prix AS regle_prix_13, t0.keep_flux_documents AS keep_flux_documents_14, t0.account_id AS account_id_15 FROM Promoteur t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.programme_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.programme_id = 1528;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75147;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75147;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75147;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75152;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75152;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75152;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75153;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75153;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75153;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75154;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75154;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75154;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75155;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75155;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75155;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75156;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75156;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75156;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75159;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75159;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Annexe t0
  INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id
WHERE
  lot_annexe.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Annexe t0 INNER JOIN lot_annexe ON t0.id = lot_annexe.annexe_id WHERE lot_annexe.lot_id = 75159;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  Fiscalite t0
  INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id
WHERE
  lot_fiscalite.lot_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM Fiscalite t0 INNER JOIN lot_fiscalite ON t0.id = lot_fiscalite.fiscalite_id WHERE lot_fiscalite.lot_id = 75161;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.origin AS origin_4,
  t0.local AS local_5,
  t0.lot_id AS lot_id_6,
  t0.programme_id AS programme_id_7,
  t0.scpi_id AS scpi_id_8,
  t0.mea_id AS mea_id_9,
  t0.opci_id AS opci_id_10,
  t0.unite_compte_id AS unite_compte_id_11,
  t0.assurance_vie_id AS assurance_vie_id_12,
  t0.per_id AS per_id_13,
  t0.produit_fi_id AS produit_fi_id_14,
  t0.author_id AS author_id_15
FROM
  Document t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.origin AS origin_4, t0.local AS local_5, t0.lot_id AS lot_id_6, t0.programme_id AS programme_id_7, t0.scpi_id AS scpi_id_8, t0.mea_id AS mea_id_9, t0.opci_id AS opci_id_10, t0.unite_compte_id AS unite_compte_id_11, t0.assurance_vie_id AS assurance_vie_id_12, t0.per_id AS per_id_13, t0.produit_fi_id AS produit_fi_id_14, t0.author_id AS author_id_15 FROM Document t0 WHERE t0.lot_id = 75161;