BjAyEzYkz3dOFdeYQRB8L2p0dQsLAG01iDohNOUa10otJFESr8UbyuF45F9blv6G9vRQkoP4TU63RCpEGdruarA3WadCt8aJ+b5yfb4wyQXYXqij7pLd+LGZG1JpoeclOoGUV7NOcbmFoGcy+i0lhDnNiXlYqUudJWCjRRsYnwWQMVPv7jqWtehgNEWSV0pO3NtKcYJUnXGl0W1mFjiJFj9jJEUr55eeIKutX96aT+TT/x5Gz2lejVh6bMa+FSf93LTkyVGEziCwovblMDfcFy3VwrW2steFJT7SsyTSWrKeIvAMy8sxLwfXUwmHfi4TqOrAdpi/Wj3Hwtrto0YDMQFAdaOriOnd/QrtR1ZLsX9UwpGPBUgus8ZHSYQn4WzunhUaOublQREx3BMnTmSzg53gDq2UueJGAQ5sIOsMK02bT3eyvzd3VDg7M56Jof0ysyXwyv/cXthXsCtLLMN5bkIvznKMou3fUIQUgTMj+54qlKKaBiFxc01+YFkkrZZl03Ldix1EyaIHTMTM8994T2t94eHUBdn6YS87tlj8lSZdK37O9FgLQhTqBY1SqQEmW6gWtsZ2QnnkQ8KsCyBB5PZmVk+ovG+tYS2eBmL+0Nfi06XOQJe4M+iYx4QwN2QDXGNyTnkNMvsGHphddQZ2zWorkq0vsdMYiAXM/gPaXUDOlcmGM4MDnKQ8A+fL+THvKAQ7AaSfW+jbBHwjLBJTCY4MH+MfqBR74UIwVa2ipecxpLwychQ2bJmp27EMpbpVr58Dtid4bVW5aZCmHNJmmrmvrEDpNOlLcLeD/0WPu4uMNffqeYvhCU0gcHi6+/Kvp40CPbvKR75EdM3iROOQFvtc8apC06tcY1pr/qf44HTjlZeiikX4HoEiCvCvQ4PhsliHFHbYlGnOy3IhSGk+7pnc/G2jy1kvdkNV34NbNpby+r4ImuGgNnydzasgOTcP7k0RVxe1kAnOGt/CUuDtSfOhm6EMLXP0smCjZF9tKhcazAdG4zT8GlicwSLKT0b0bH7yLYMrDuYOYbrQqJwJlduhqMW1rWShky1/+8SgA6awD15Wp2WRS1NSTingKHRj/Ld8lY7xOhmXzX5bJKkOzkfjHKYdi/O1bpZcCFTr3KfKMl0OKwdMEo9OGQZbhFEdJepqrK/o7KAnm+Ek/lr1eEScyBtDsDy3CGM1OSBSAeZLWWHC5Yj3Q/OY2KGYGrqnEm/ySpxUso87yWj4lksz9viNg3VP+Mqa0E3kslSHN7t5Oh86SxGfHh+opVN4/q7m43S33Uv0kRmyEbwffwLA1zTbw4Z3d0dS9QAMrFb5bWRCBJbZSwd6wYvQX2v0ELBVCzTqjTNO8aOns0T+wt5KHk0fQpaa3aW+WtnaYy4=
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