jRVOYJMHIqfcyMJPsfIlKrMHdq/Qk5rthRZP9b5JCHt1WH1jXco7xPHmFvz4oHDjT9eN+8bHYposlyneSyw1JIdzm7uIuXaLsS5bpOmqQliQBHG4LTCZ2mPfVYC/fPcT6pboPvxMUwOjIt60bA7JCq7S939ZGwW79NON1SswIIMAdO4ljkccsNFvZfdqPJf0cGqta45TmFPibNtEPcFTCzg4Rcse6hydRGUB3N3kReCgIU7o+lwTcjD51SGHtcQC1M9BsljspqaUBdUpGrQtqtURfQStEBahmHSWdFyJk8fWxWHcTcsuJdDRyDEkj+QNRHBljL5CszowGXNE6AErbMNsWLBNq8pObcsBFNQnDm2HSgCM3YR0WQnax+/cPshY6M5aXKucMDkQQ3/NoK+qimP4ypgj1L8dZtCdbFCNp5fAD/gfJF4myQBzlxzRd6ITiujDMtpho+Ebk5aZ/jpu2RUSFG0TS8dn7USFopCtK9KJduyhZxJGYvrb2HIzrupX3kM4vJX3PSUv+LH5CKhBofwm1GGPflBzPWu21r2Ac5HP5lVbuycDhTPfAx11yREqQW/GlERv0Ep5oDg5+CZiBzLEFJKjALVoiUMLtx1Kp99KRCOLAZ0bY/kBCLqrwN7ekZQbRRJ2qzNa4OsqUq+apSKECRATf7YcDW9bsBLJ5ORUAuOAhXG/LTnAwBSo7+Ffrd2vnF7cYfpiziML0P6uvgpzhasf7A1TtxWeGv+L2ASKPfwSX0b+cvd87mMBnisGpa8H6Mg4GxqYL50IjCNp0zTxEwYHWzeZYSgoLXW91PIbTpaI+bfsyM5KGmdf9pONrkKdHBVGncIHot1TW3JJQ1MWfAL9JgkPijT7P4zz4uH1BBY6f8biIul+8eZPpc99m3YGlUDI8VtxZcsjRRhA/O84IK654b4yQbnOSgrD9DmxZMsq1sc4fQOjL+TNJ97eyhqZDUJwra3G7yoZqSYZjjOgAkywHiURzxBkMZ+LArmkz746WKhmtGEauxoNOJq+bWwsjqERs6G9As7DPNjJ3yblmc3ROGvHy0gZ/dCFHuNHloBw5V6ncr/c6gdFvm+4IhdE3gfF2QLqPMz/4LC9L8TCiOJ64hwD+a/exZZUPo5FvYtB4uwiPOOQXZNijpTw4wx88jKhh35AHVNP8HrMjPx1Aodf2ud/F8FknGDHNkEDzz+BDcpLGk8MU97E7c2QGDgBDlE+20Nq/zCSLkpIYrdVh401SH1I8N6jZF7i9GfbBpgZcZ0TYDXHWDgx4nWkDlotzlCPZDfL9SonPGJsLUmS88fgR9cNJcq0dKMDJjmZ9ae/C+13fXEtMZhCgB44VRuyTI0AyLPnbmHUphnqTG9OZBBudrPA0nf/LE4=
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