X96AjmU3h89EoPxtLj+aXJAMqK5RqhZF/IfIyICnvT1G6sTLjuIGuTX1c7DLaOfF2OW30nJLx14SB90iIOq4/oGaOcEEEk3r0RO6ZVkAlmkABFGfD1Cwi+H1deXIpXiR41ieP97dzmXcNgzS+6Vu2+tR1e63NnKPdVRhWGSQuhJQvhA8OZKWksJOkwQO24mrp6ZNk+Pd8nGqeQct1VW/p1N/BNCk3smR0IAGHWlQ6QrfJ85kUO2KUZDs0CtZkCL7cDwQE14+ZE08jOgJcQRfm7Zk0Q93lqrJH63/UYuXTDL2/1cPUX4GqxTskEDYr2PmcFuVrdPUka/dJkK32vLDnlrZ2cbs8i0ONuGy33QnID+c/uFD9nxP7949gQlAtwrtoay+GdQQ5YjKv2g+TOd4Vc9MjG+iA7dia6L8r+ACerAaMWIMMU8J6FH/YVP96ZqhKjobnr3WhN+iwY8h1cf3mktjGrT8RTNaMAl5tyJApDDlIBvQWxy5k7EmTRP4HK4eJbydibz9cuATJpNnna9NDI7fgnwZaSzcHFR6mRNp3f/ZVOdqIxY7LUXvN3kOJfolu+ILhc7tRmTwx7bhc+0ofS2ivJUCR9E7jVLTKXRPpdCdUXBAPTSDEzCM3q4tzaFJbOORDw4nv5UC2T6ejSe0V405onLnTSTDnL6lU07CSttEBrAtDQbhXgANh6t5/HtaUlnk3ulw+H0Fsln8NbThiIzO5SMG6u7Mndzq8bcZ3f+M81I/I10bRrwuBvdQaw/nyqqespszBMvzBWnU9naDAldQ8EHXzhGO6USX7KkYJSrNb4UVZOApUIrNrKso6BHKnNu91/5dwVc9TyAkyW+moHg/iWU3QJI9iq8OMiB84excaStIim5d96SqPgWWSsuGRprrMmtg0weBOwITvr2cCw3NPC70+3rZMe4PJ12ei4eElkByEG/ODeR0ftM0V8JV+9pDhYsMHHhqK2r3zTKG5Q+Qc0+bMAt+ZBdGyyhu6XELrHbZWpYcno4RNuI/iqnoL2oHLTpJvfnwYSNKwoNUGHhA4Ul0Uq47CIvaFp4WuTWAxN4ALBz8V2khSBfT0lzN+7zCxMzR4L66999UU1974Eawpxa6tHeKHKQ70P3eliXK4qNI/MypttiWdjG00O0L7OPoCXUtdOqrBFYn3cwCadDueJBeQKGP0xRjEUZyNi1EJ808D9+Bz+MSOCirr8iJGHWU9ZVPbaWJWpPeODWX42yDgsJ255ZBIoeJv8CU77SvmFDf5yBMSw109v8G0iHQJeLK/CeJlCYTozeTU7uVd1smIU66Ukswhg26f1xJNiWg8krc1yLJ/2B1vpVVE0Bj8kew5CHpMu5Bmjtc6W7wPQnYxNB9BVK/c4sv5H4=
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