O5PsUpZ6oNlzGCAm2/owCipygH79oHEpAkqJ+hEDB89J7mv+Sy8ybR9+lc2g21/6LoGuJqRk6Aw4TMAjtg872XU9o129jLtkZ990MgtXABZ8f+TghML7chwpbmuAFJ5vQuwMzvfn0JrX5KXP9X6YEwq08qPgN39engGORYhvXBWYjMI1h1qBXM3JS5eZGkTMP3+VhCcMz8cR5TNKhhOVNjSRk/oAL48xGDOJIaUy1b5s0zdWXqhG7Lm3wUBr716onHmeKO27Gg5VfQ2MxU+0hKEJouWimXcf88H9mB1Z8UjSVF7I7c+V1r8QEXJ0af6x7PQhHXKI7jQT42N7T2y1b9d0lOH/FJBGL8GSsWh+ewtaFCUVKqdbC0m+jgko9a4eum8iqzroc5aAh3f81g1bAF6+ab2RpYBkoHOsZfl3deq7aKDoaavqwtd3plwz3WLDh1Qdmesh84G5y084JwZWajQIXXmrrGT0sCKqIJgZZxKwfzErLUG3P/lSd7aMvFuefxl70wonPIRz2B7Ss5E2usUdjoax7QobToCZpeFxpzQmT0u3RXtfFzShNyOyNG1M9KDuQs/wis6Rc+nyMu773BBFpnWeJ4cCXUTp6WAvBPnnlA2y6OnP0RnEM0Mcr5W/DUuv4mHpv6m3IjOT013RKtSiYHffNGQNKKerUOuiL3ja2pQkFs6YkyEOBt9XcQDdo9JjDGVe5epWr/Fmy3tEvd8m/WryeyhGIhumodiamsGE2ZZsPhH5MtCy9DIsILMI1vZMqOvYxm/kIOysf3aCG99WoabQfJz4DtrRLJUu2VR9uwPb7eN3tuuv0xPvC+gPhfRifEYwJgwKQ2oeZ47FtxWwkoi7HSfbQyvG8YC3d7S6rxZpkvYuYpOg9WJDwkYOS1nQdNiY6GUDPh0VU5n1BGKNIfKz9aYowkGoFCFweE/HM9g26y5UN+dSIJyf+/OzueowxuRmV9uOJV3+UjCHon83Kahv7l02siTI+aU4gKrj6S0LLT/qtZzCV8/WeYIoP53yuM13l36vQrLBRpT/SutU06SJpUNjypkGphARC2hQkQjKXWGkrp4dSSDYJJOGpcTjFdS8ZsfGedn6s4VFxk3jioL4ED3eGUcBoT/4wHxaxE+z5qpJhgn/6l5K/UVMeBKndHZvW6DMOQ87v/NyiB+s8HMeEBcRZBr0QeYi+JHCDnuM2vuSDmJ23TTGtd9eQW2XcDuxVBGb7NS6dtsdoQfPJ6hFRGR9ulXCv8a/FPTM+oZlwRFQAOms3EbgivYHVqdCb9avcDMVaeny8liupmJl7s5KyDLyCfhBcVInBULA4KBE8WGFbYK+URT8WxkFL/XxB1l53c0VxBtuIEbt/yx+lhCyDEZv2z1YZ4I=
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