5zSkK71y1zNs1+JxXJPG+2c+wgGe+3p7OP1CXhRoBWLLfpMChLFd73JA9SwvtRapiz10K/TJ3j7V5UTZg2tMkGoilzRR9oV83K5GxAgCVmbs/aLmSpLGbqaERTcoU59XVbxYQtixmp1Mt5EMRWMXkpu/cEZfa7+5HLCPW6HDysv8cGhIuIYLo+eW+X2yvgaCD5Qnlg2dyUxB7sHvyIfjj5sruCfaM1tFufYwWrRUu+XpmdFzC6+6eiNjj/dUVKIHL1YsJkCXOT8IQ0Lw18CzLWSfTmrjlTz6sIHiJoJxOM6ZSqOz0ELP3yuoID3/oz1iT4TObEeUxPGk2LGiBJsTTnQNSNwYtmxGJklzL3nBz/Bpp+8YN8FUiVK4mX/sZZGjri+s/TxZzolk2qNLf/1rbiuv/EOxW8luPwM3X5/O0L1CYXC3BrL+p3Zx5HD9XgIld7G8IFFL8JEDfurzNFTftiYmv9W0xg+hlseiak/fJYXI7Usf98btSgSYQKrimdVxrxIeFk5rgDYIqSX1c44m+TX1JZcYTF+BFNthEe0Lk5QlL1XSdhYl3lxbp5P3gepkntvtF935rdnIhYQ5vDrPPcfFQ1cNDEQCxaaUlv4PbDW5+TKP9lFLouNdSOT7+yPRXVRwe3jND2tZUxoPm3FzhcSoUYt4FPL5onQBg0TxJF295ILUBvK3RnWyCfbW5s1pN+kHJ+ZNsx+/avevCJrDLX4/RabR8kB8K7q+5kyZnzjl/Ckn+ZnErdSygSEcZtP7RV8hZmrXTHzyRlRKCq7h0VWtdd1oYywZe/H8bQ3sZbWRHEA9TFkK9aF3g8QLgXWYB6KEolHmA6NzwKahLx1btdn4mzXQzRiWnzzh8ymR+bXVb5+1QaESOF6glz98v2Voq670U5ODTNoLWXgbPqlsxg9GVtVXRsa1jDSISdM272mGOcCqprW/rrrxheurFkXK0MskmPJQZRDwVIwJHx6RxL31j+jJPh12NXe3oTwbe8XYGzptjRsV8Xk6iF0VNuSE5Iyl8nTI/LE1oO5YPWqAjnKddg3B7dkV7kQB2FDifywQNl4TxMnaJpC92CrtBgrc4ADUlmHT9/Jw/F5RYKESECv6ycz5Z2i/LeELlqGOgOO6V77QXhi0KOS/4d+9mLQVvhNANa4Wvm2lx+tFVR37kHjdcVN8T6rrEWOOsQETpixfSSLkDpQD92Tl8/Q/BzAl3VSMGWR68luDISiD0KnaL5N1swEuHhku6QS7vMpcRXlFL7grFS7guInpxG1klHBG2ITt60+Fv5vi7MOWL32Yg4LxBngnuxd6/OaBGIIqhxXPQNHtLwE+1NtGuiHnRmVGRuQRu2fiEileKOv0kxI1DRtAqziASzv48OErBdE=
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