Symfony Profiler

SELECT
  sub.id,
  sub.name,
  count(sub.id) as counter
FROM
  (
    SELECT
      pa.id as id,
      pa.intitule AS name
    FROM
      PartnerAction pa
      INNER JOIN ficheAction_actionPartners fa_ap ON pa.id = fa_ap.partner_action_id
    UNION ALL
    SELECT
      pa.id as id,
      pa.intitule AS name
    FROM
      PartnerAction pa
      INNER JOIN ficheAction_financialPartners fa_fp ON pa.id = fa_fp.partner_action_id
  ) as sub
GROUP BY
  id
ORDER BY
  name

SELECT sub.id, sub.name, count(sub.id) as counter FROM (
                SELECT pa.id as id, pa .intitule AS name
                FROM PartnerAction pa
                INNER JOIN ficheAction_actionPartners fa_ap ON pa.id = fa_ap.partner_action_id
                UNION ALL
                SELECT pa.id as id, pa .intitule AS name
                FROM PartnerAction pa
                INNER JOIN ficheAction_financialPartners fa_fp ON pa.id = fa_fp.partner_action_id
                ) as sub
                GROUP BY id
                ORDER BY name;

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '25'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='25';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '01'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='01';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '11'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='11';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '94'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='94';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '02'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='02';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '68'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='68';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '12'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='12';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '13'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='13';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '14'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='14';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '04'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='04';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '15'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='15';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '08'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='08';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '06'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='06';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '07'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='07';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '09'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='09';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '10'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='10';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '05'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='05';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '03'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='03';

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  count(k0_.id) AS sclr_2
FROM
  Keyword k0_
  INNER JOIN ficheAction_keyword f2_ ON k0_.id = f2_.keyword_id
  INNER JOIN FicheAction f1_ ON f1_.id = f2_.fiche_action_id
GROUP BY
  k0_.id
ORDER BY
  k0_.name ASC

SELECT k0_.id AS id_0, k0_.name AS name_1, count(k0_.id) AS sclr_2 FROM Keyword k0_ INNER JOIN ficheAction_keyword f2_ ON k0_.id = f2_.keyword_id INNER JOIN FicheAction f1_ ON f1_.id = f2_.fiche_action_id GROUP BY k0_.id ORDER BY k0_.name ASC;

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '95'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='95';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '32'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='32';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '49'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='49';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '69'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='69';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '26'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='26';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '31'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='31';

SELECT
  *
FROM
  imap_departements

SELECT * FROM imap_departements;

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '65'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='65';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '53'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='53';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '50'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='50';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '77'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='77';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '42'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='42';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '76'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='76';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '44'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='44';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '78'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='78';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '17'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='17';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '91'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='91';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '38'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='38';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '74'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='74';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '27'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='27';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '72'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='72';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '16'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='16';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '90'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='90';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '43'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='43';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '33'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='33';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '45'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='45';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '93'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='93';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '70'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='70';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '89'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='89';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '51'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='51';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '30'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='30';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '86'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='86';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '59'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='59';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '62'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='62';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '58'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='58';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '75'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='75';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '54'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='54';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '2B'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='2B';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '34'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='34';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '46'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='46';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '87'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='87';

SELECT
  *
FROM
  FicheAction a
  LEFT JOIN Structure s ON a.structure_id = s.id
  LEFT JOIN Departement d ON s.departement_id = d.id
WHERE
  d.num = '85'

SELECT * FROM FicheAction a LEFT JOIN Structure s ON a.structure_id = s.id LEFT JOIN Departement d ON s.departement_id=d.id  WHERE d.num='85';