x/PWYgwpY54mXuMgXCBtMeeErBtCbDtqjBBLTnocHhZlDBsr7LMpYlO32pheysmU59/BJ07qFazsTf4LM7ws4r/v3fX4vWxVnHLcTSd/a7Vgin4EMkWhFOSY/KaeGoDOOiGloJej4t7DD+FjM/Kbuhir90uR/fF/4obaPdGexbxv/9sm5ubjhrKRh31ynhgEu1yC5w4UjqIUVTD7cOec0GEcIWmc5WzPXR8kTBUh9IGCAIsJl5iMY9gb43F8hhHREtmhECT2tT0Uumatu7WlRE4WajTEGJ7nWt6DIF/Ot5xLE9daNjLeQEEzjxJBKy7gyEY/7dRsFoNwZKzHxK9048zjmHOk8Qwsat3ymLHN9kgHKTSVT0Gj8R+7CLpJVzuzTvY+Mg1FdN+yknxsum3KW7033FmhyZBWmn+fY+v9+aL39QNy8JsSzCHbwzzZY/8lArnu0zR5Nkw45M+EA4wcTPjqlji0BkhZ5JkmVtkWnSEUuKOxGzxFpF5OwOTCBuRnFhlS4oU2KTyJyo80ov0ewPqsmlg6icEbAXbPR++xASnr/go8p0LnAerKifLRUdK1T5hXpJdKjH38CaqGE0MpreZMGH9jcAOrlTTHJIDVF5Az/V92Owm17fcoRV11/l2RDdvPj4VQBab1c9qX6Kl10+cZuuk3jO9+w5iBuJewT0AotZPJtMzRqHGFr315ucQYS2JQTuI8kuUCedFIEhK/DJoVhGnrZ6iE+w4El/C/jtfEMHl6IWL4AILyKE8sUMq0ETDJNaWsqPIZ80mciwXf0ukBpOMQij4RwxYJpdacyEr/o4F308U7OAKOcYXixHwOwiXOsaWMVkAnqHJJ0dL+lPoUhJdcQP+z/5Scy0wmxXcUXoRtWYI0G7g4v142a2AuetlBzAqK4gxXCss5+bybQEjLtizbXl0yD4uiLI/Xkku+hqzvEs6O/LH5aDEvTEjO0GifOTkVfe7yv0c59meoUBkyZr+4qQ0rJfE31sVNOvgc4gDAYGiWiZ32bjhnkOKJ49k8v5lFlDiPrikJ8TL4Rw0v4idxqj8lbFVpZiTH1Cb6MR/uHrSWyrUq4cXwjcnU6YTZTuMrMiDSo85PEWcMRVvjNbdU1Voux4iMXddT0GfyYxrUgQxLGuWHw4KoWoYtuROPj7/KxSFEp8M4L6zwmiyNkfKvi8enGjeS+aBGGPivR+J2GijItZztCOYF291IyhKX9SIZxoiEkRPo1b/sQYiAyGEZdAd03Vo6td2PeMugvCuWno60Yc59LYIU61Ir03cvoRJ0F5qS2WCgndx96s/flCwMRMePTWCBGLn5FQLLdaXJjSwTj5eckQUXZSV3F1XVRnmxfqd+mZ86AcaqnK48vbyF5kmt+TTMaGM=
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