J6+eowhosntUa6Urawt4HXzPYcnMu5zGAB5wBrh3fQnduZD4UCweeKKDKbEm5fiQJwKT8r3+z4oAxCAKNXrtfjb8qTD3PB0aOISbukjam4jTkfLqLyTptFBbXNar2BQsMPNHxMtQiJW4G5rcRu8oD/bSHXxdHn+XkRVdbNaAs90ukAdpW6MiHW6r2M6iOOAOdO3cscelrOb85EBIq2IR9swqmefOlXnOLPQdnEyALFnKSVIQVN6qgbJsl3E3JLM/Fv0Jry/CGumvqCzqi+/1C4qjl7DohKBciL+MdS77fJIPqzMPklOhTq+aNkpHXKQLf9RyHov3ni1MLk5pUawXcuFDmg3i8DkzTVLttVsQ+h2ucvcWjURrEWTD45iQYOcB4iQcSAbBeM8iuzDosbqoi+poGwZBt00jUd6NVyQKACiyPCm7hUI9AQgtYGIT/Zq0X5ya261H5keuwlzc+NMABRNE0M3c779Ygc43X2RsOy1puLszN3NLJFD8ckg15fgQAIEb1fHXjCpEeK/k6a5++dRz3UiK4uRxJpV59HI3mavs9/9en941mNnQxi2TOn6QqSdaVCTRlfhBQq9OxvV4QSpS4M7WY8g+SAY21tT9g9bIg9FQD4/TazIHQ1U20AM1I8Dhhg4t7kV1jXg4zTHYzzuNOtXaGoTg4mSBRcEObX/LH+AehQgKjisf2lFJ9AFjPJl5bybo2iXuHZpzkrCzDCDUt9Crg9t9Qc9tmHk8wdzBUIpvRHce/XnrnHI7D3o4rdGBshqejgxuvMoGefArR2HTyr2fsGlV9m+uQ5X0XBGWnSVlSUq1+ScNS5dsc+0//Hua50WBtg2Dv1PCesPCHhjKtFfh6z1c7i9Q2r3Dr6pcJt8RmnrLMyDB/ZR7vNp8IFBwle0f1jFXpuq3hdWyhCjexMXVfsevIP6zHri26PvyT1R/g/gly5HbNUy+bCiEbEZ7qstIL2y/1BI4hg9xfoaJY5z1AJh2zL9cJidIftUCFlnNotxm/c5jet8KXGoH4D/Bx6d1lZbSZ4452NCYWNN9nJCtLVq0K9xj5huL1xZI08dOoAp4UXOfMxsglgw1dQiSE+/cFwJkvW36xaMx6sTPjuw95i/TW2o00VrbDoZvIxo//Z0a+O00n1H9BjLZhvDK0LDawR2ShthbNfqO64zxjsuoK9WDItIPyh+SRDGsH4aAWW7lApP6/4lNFZc7N+cG5ZcqPHsy9Y1TKrSFBUXvfXxrPrdH6syU/Bb+vMQvenE4f0cHzThPuDvz8SVGZoJ+c+FZTlErhXS+ZubJ+OdlNNqByjZDo8NhFKzJfeupY+ue+vgrjYKdn0H3Yas5FAqrwJdbEpRgJeCAvkHXbpCr+DH8+3rtRIAPeCk=
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