q+0IKc9xTIlMBgWRP4WfsyMRKFxFqzTWXEAiRRYKU2lh9oP7kfKoY1lvet+x2KgU9f/I52W5jFV98SNFOQaMplG7Sh9b4x6k8Hc5ex3iV1ArzWjFqVAB/31sthJPLYaW4HKH3BEspEglcaP4lOAbNoO8jml7p0JOp/gE53djBSRYuSivokt2mqI+6ZBAdudbiy1PNUtDnqFPKYUHQegMF2W3fGp7UZUfzIg/O3x6E+oxggACHPZCs5vCUMilGbsWxaG1ChyB0AWPSVcuiTpfarwv0Rfx8hp1L67kqY6p3aOlta4tpvn/a8Wu3XU5UnyeETCOvz8oVyBAkC5uQaQhnsW6Bd2N0v0RI8kzEFwvcjIO/dhhDCfqjjhR2085MJ5ofsswcnlLwag1Pn4e5koDPlxOY56Z+RvbpoCGbA7otpwDn+0cpl7UY0Kh/U4czuM08RJwcvya+rU4Mq/TRLCY85iG0yw3UkgZMvuNTnjVfkkJC5fAos3PJV2FvJTJqFWNBp9i4jsi3LAL3rbpT96dAcLLSPU4056CtF/Vt55Bw+pTI0UQawMI3LmuLrrYNKK4v9/nMhsRSWLGejrYm/oi8k3H1H+GlOwsGE04gMVzkgUr8HbwNoXKJXcj8tSPAeLutWLp26cHVWNoDgivsDHPlhnGgBlEkLE9wrc+KoL4KCMNK5WzWzXlSTjbAdBXxMOC4X2tvniPJLPzyKiDerJlcRxf9wE9pTce6b1L23ndkttOii4y8bQywcjaZ2syhV+xAb2C83ho/hM3pybOnQA9qI0pG4FlPfb4Kd1HeQcs4vb8JyHkusgcyvlVcA99PHWA1dvL5ZQTACzzS1rC8teK1q7w6g7szGoJ6HIgz/bJuvFvNnVfEYczPm56bjOJmV9dD6sIKDVNhvYnm0e3uX5AREkMGXAe806bjr3wuzDGNsxj01MUwYPhdNYsfntvqLTCdQn3PRtLlzf4DYSLgJa6Utyvt2bGRL6sGun/8bqJT9znAqtiUpbGWYm1ff6+VJBnv4qKepHwgpD6zGEiQH8JchmX0ok3NlBlRo3G3uZH3TEFZb+LKyx12iwm15Sz2ICL1fg08vQGFwqP/2W1wwGw+IYCBc76yDPu2XDT9R3je9L8CQ7mWASZoXbJUoDgUSwbru4uOmI23aQc4DSMRh8yK+JjeXQRQ9SE30PJqoPA+b5nzKBpIk7Y8vxEJy3FsuIETgrTCou+v0IzeK/BvoRFj2TZY+AMf5fJQ96zuy9O2KfIK9X49mKyKQcFW6fwt7+ex4L1hfZFpIwvu8Q1zukf4M8z5TOM6f9/8Q/ZC70WPVE3ulrx3kl4PYyJKbvGYHe4LmfSm7jky0+95fnzduoE4uJuH8iPBOsCEc1TNFM=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100