Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 ORDER BY a0_.id DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.ala_une = 1
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  14

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.ala_une = 1 AND a0_.id <> 37 ORDER BY a0_.created_at DESC LIMIT 14;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
  AND a0_.id <> ?
ORDER BY
  a0_.created_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Sport' AND a0_.id <> 37 ORDER BY a0_.created_at DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.titre = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.titre = 'CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Urbanisme' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 1
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (37, 36, 35, 34, 33, 32) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Aménagement du territoire' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 2
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (31, 30, 29, 20, 18, 1) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3
FROM
  thematique t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3 FROM thematique t0 WHERE t0.libelle = 'Environnement' LIMIT 1;

SELECT
  id
FROM
  (
    SELECT
      a.id,
      a.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          a.sous_thematique_id
        ORDER BY
          a.created_at DESC
      ) AS rn
    FROM
      actualite a
      INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
    WHERE
      st.thematique_id = ?
  ) ranked
WHERE
  rn <= ?
ORDER BY
  created_at DESC
LIMIT
  ?

SELECT id FROM (
            SELECT a.id, a.created_at,
                   ROW_NUMBER() OVER (
                       PARTITION BY a.sous_thematique_id
                       ORDER BY a.created_at DESC
                   ) AS rn
            FROM actualite a
            INNER JOIN sous_thematique st ON st.id = a.sous_thematique_id
            WHERE st.thematique_id = 3
        ) ranked
        WHERE rn <= 2
        ORDER BY created_at DESC
        LIMIT 6
    ;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ WHERE a0_.id IN (26, 13, 12, 11, 10) ORDER BY a0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Economie' ORDER BY a0_.id DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Cadre de vie' ORDER BY a0_.id DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  2
OFFSET
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Economie' ORDER BY a0_.id DESC LIMIT 2 OFFSET 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
WHERE
  s1_.libelle = ?
ORDER BY
  a0_.id DESC
LIMIT
  2
OFFSET
  1

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id WHERE s1_.libelle = 'Cadre de vie' ORDER BY a0_.id DESC LIMIT 2 OFFSET 1;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Urbanisme' ORDER BY s0_.libelle ASC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Aménagement du territoire' ORDER BY s0_.libelle ASC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Environnement' ORDER BY s0_.libelle ASC;