DbMLdRO+z7OTHuzsp6GL0PlRVySxP2YgqJ+AL1XoHU/PFx66rXgarMmLPP/+8J/YoK+m7rpcQ+VwPDViqddvu/kOgVR99uA9AnjsLMN/p62FQVp2SLH4i1STsgF9g/We2I92omCB4CVHwuSBjUSSSYw5t5iC4SQ5aSlKLGQRRqnorMt5TVKJ3g0VKc0PheVRCg0eEu/4h337plSCsSYeLCUqqzS/cPeI/Ty17gkqKxJzE3SvAgnsqDnNpEjlVwjfos1ccMfn2G9N1tJWvGk9BCRiDIC400BQqqmY5rhe5ItkrlZGwLHo1GipTX05OSJ+IR67gIt8+fCJ5HgGSmEwOtiNmwODkPQ5nDfzZOxx/xSIJGgzvQ7Cl1j82n3F0KR4ebDNIuoccPtMpDfZIqTnxC1ONANslfy2qCXLDWlKTADJElzsl2vH6CujnuLNio2rb+qhP1DTJR9qMcjdXDIMsmzLpfaaSYChE5GgTvF9TX+taU+KFWCiTWZobVipmlk6UXf+8cUFBFVPnHqg6ETkWnRUGtmM4qn1TPzUHQjNp1D8gxZaYbo3BQ9GnCHqPOD70tJMEj9Jl6SvxzLb7yplmpebtZv5Gy80AQOHnAFuU8LEgAnEK4qSkeJRG6lYvYfRc6npbfwlYrGy1oIS294MeMUZ8NaR4ZyHKBHmn9Bnwa95JIDrWRfJXsoo2HRSdPL6sxHot4NDO5jOwgewMktPJexosaUtSJfbHIbz3k3ls006IhRa/VFtqsJWEwkrT+DJfC9W+bEzU5nN1nZeee46Ybyt2ZXNcumHd+9kNHaF9uyOK4+9WzKkun9Gh3/THhhzLuaoP6AABY74or2891Ad1rDJOLobx8+zAIgAzvxvbTzkimQCrKwT8ZEUljVYZlRVUbHHxzDlLd2y+mU/JqhBw2qk0+4+7V9osHVgoZ9oaOEkQAAGJPKgr7bV/42fGhGIKU1WJq4lie71DCrwBnpyFuiqBBC0WgQpiUMVx3vRSLKrwtW37LmoZl2MWGW6Wy5MSuLqZyEVZagYj0OhyDrOqjeR0oowSpbZbVqByphLXTKy6VqZGJJHt7VI+vHa8/PIh8S+UvHFEneb9vVuwJongdLUFWmQGkfoyezkngJfmZpjAtKFR3mj/r4CVLSibzhOKDB/xZBu0AiRck9+IV7V9f9n9Q8WG0T3ufAk7vvP9adjybwMZswPIXz4Z0zjlcGKArHdmIQJMnZTFIX5tfJqOo+yDrkFENk5Bz2PzQLgolb+rTKxgXuTocyDSwFPe18jcjo8QGHMHnnOiVsGPsSrOf+vifX8ZRBI89Iz9B3Zkn18IYbE7ArMv2JsZ40K/h/0qV0yGjcK3fv1qov8/5nB/4Lw8SpFbXU6osMynlc=
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