tTpvu2/U0N9bsQ/BgP4ndRKr4K4+h1UvgiqYwnJm+XZppqvBZkgoiQt/juCnDrCOfbslsZAc/Yz9ZJTewK4ubBUntUP0V2S7CJ6nJUTFxQ6Cz3bs/w82revMXk+P9UyKAvenTxaBe70YDR/jH9sC/bodk71qkyKnZDWDxDaOSNOqKRiNm6UQ51m5FfNHFdUqggX+sVopTfSOLLptWvnHx8Ql7j1QrxB1spx3t1FqICB+kLDB7Ph8IPAusvrVlPtICI+HgLaMD9jhoTWQ8lsbYRL3YeDcSiFGV6E28yv0Aqf2U/8XUzeXYkBduRfrNtm8oiD0HmP9kewjT38CEt7L3ldXK7TQis9u/pOpjC8FcYOLVd9ORFVtgHmfGHdWUe5TWpv4MXbHF2PAmgIY2I+j47qUAKlHk/BM9xS9PDq2phwYLpZB22wFamZyIDgwuzXPYh4owHLM2Eb7vF3moW2nswQJ9FlyTMzDa5BpY4NrJt/aAIhAOMHHBO5xKUYBfYzqhvyv2sPM10lvSfVktuwVUXAWLDsuDCGkgol/bstWQ5b8zO32kezmAdLBxYB2Ktr4fmUx7fEIBOkYBF67QDjYXkLFAkunjYx5kWn0Dl7Wz7n0OqufTrAwX4u0loqbTYPP3nHV0/ITucys2GkYyy+4ltnyZEFz43MefNqM4e184gDWuMus7Yn0DyNADVFq8tmcGaBNBq3xZLiyX8/P4yESRO7hX4g2gcbwT8mGi4KBwvx7fcwK3s6ERR4ixe+JeRlDYzjKPnHLmsX6EYfO/VQBgj0nYGbUEvkA9yBOBhXfniZkvx6Pf9GKT//Ri3eLJe5UyOACBsPSs5gHTLPVvxIiehWrjWWcLgaGdgNIHWM897MssWFwiDPGXu4qJVKQViKwCOWcOQ6m8yZHbKLu2bgYTblB4iC4IRa6TT+dTyyItpIl4fGipodn9la3x8ZJrExFjuowDeoYIGKhOIJcho5KfKVcOvuArRIEU/ATY9/+3Rc6CHScUVK6fM6MP9E8o+KZYrN/iwTxm/SbchmvBOYOVpPO0lsjW4BF4NQy/5gRe3tr77XERzg7TzJp8v3zhRgaBMlOU6/2UAPfplbxYwipTUZSO4Ypmg2KzLZZnBekjXs96Y0cUQQXWzNuCt7e5/tanYC9wIjuwP8joCFtUzqLCnscFvZuphQ+5rf8z9qA4v7PWMg7OlYLzcJF+yosEDz3+fUThFpesJNKY06UVLm/YKh5Xq5OiMz82c+CrsxGzuKPbaoogLMk3D9buzoGvNiJ8opjfQumuzx4Vo7cslwW6kRQTXeIoC9O13dgAOxHdlHVmNiR0T4juZH9XUa1s7RoULKtLMuMUZvkHGGv7zlXw9wLf3t4BiaOKK281D0=
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