Ax/vhsHlW+SNrQOAzITHMjA+tr7D67/SwQEb6hCSJQ2vMjsVFVrVzqzS97BM4xzhbdPPYg90ooCbecwqJmVcDfkHns2YV4Vrb0M9Pfk2pTAnOPlh3VtRWEBpPaX74AwPoDvif1wmLq/dbJtq3AeD91fkTfNU3QHuazLoVi3pGPGQagdC4HuwJqaWqLCaAx34V3u9XYS0gGWWMA6uis+mGSf62cgHExto+65x/zwXLjJ7R6eI/YB7jfscn3ch/iLINUzYwdgCiIbJkOWpq1HrLCzkdHfg0g60tvmUEwscpqbwuymlvL1S1IvStQmIUGHsafSAvJaSQTznKer66yrnAK1WE51p5SQKdFJsgI0mq0sUsHufMhblveLWVv0NWLSB7PElBWadpt/l3MhK2NLa+kqX7uY2Pxoot9h2DG0nYUp2zdVf2TEOxwPr0OauLVszwrb/nkcvEvokU2U9WDrHQaGriTgDhw+vf4h8n6kR40PYCRALh/8gylOBgE6fG/f4s6bGCt6Xibnmioav3KUgSn+vD3FcPE5bCqjLhQWz2u5OdOw5d+2zfwPKuOB2r8hHNiniZqizH8UFsz5AGGAXxsIayVHmbOiK6CSvDw5Q0stb0E30/GXx7ItMfYi2VCDyfUAFlRhBdkXIzJIJc5uYJPV76n+YPzMCjli2vpfBbFfbbBe0x6TB0D3qn5KDsDoXqfylKLwq0BDmmkPsoOCuXEZ3jkEXkI4d7+w5M8QOmbutALGK4hWXECiboK5Kl5GdxMrdSj2YvB0HY36yjVY3VVFAtDMx8yJZqbyhtfi5v3RJcBVQRTfRFg9UgEuYlkdj0gt16eKE1JkI3pcbtjs9D0msauFjXKhQnlYbB7o2c5bOGEL8zRUmS1OrVjrIyki6Yyaeto0gaH3+99ibVM6aRe8cElcV2W9sqCI8mTb3SvUlLeI2DVmc/4Q/iVJgpm9rNZZjood+MggQtMiTpupWj43I/Ko1uleLTy5x4xmaMlpqDWf9zY1xNMk77naxmt3oZ6S6rf++TX4h3GP1bcrdAI1fM8ANHNDEYepxHVSo/ma8mykScj1tyJUyW3d9SgLq3QVdDZRyrWGDAz20aj7HyXC2g8otRvKzYtPJ+H3l1Je97/QMF7VDzfNx1WTuRPyfLQX1v/BVNDbtbIsRli1eY7ZkHuuTfNMOXgDGY6L/xhVU8hjeu+J7wOwEPlxTVXAultyCAm+vlDHheSs9YtncH6Ab/vbUlBvQTFle8rAAzpfSHQb4fpKf0P3/EpePIn8i4rz+3+MQ8Yd6AAKOeCDih50lcMARXsifS96ovRznwAxiHrR+SGo9VN6GO+7YqDSKZfMQrAl9IdZdktDX2WMkMXTYkbH6m4jUowdUK+M=
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