DiXnSnzE21DhZAyyHPkcxMqP8lO0v3a7A/nwl5Iq0CS/Jqt5Psq3ggGz/302OWi3odcHqAR3e0n5jJEvRaggaPregH6hRG6VGVrLaKKc0qkA2awlF6Pc2ASpt0voGnwxQXG49VbGwIHX4qjVLT3WLPIomtzUU49IoQQLtxTdrqzF315TCW6mTnEMITSYUEZYCRzWNuWvWgT161X1z4aWHP1sFao5j14PhGLZa8pv4v3KIjj8yHwgV7yInhwNcXM7aGR1lOq/P3SsD4BGbqGPBAQoTxIML0xpF1EAQN+gF1w6XZoyidY2X418pnJrsiqumMvLcfYRXxI4AoTbBnEwmsSTqY4CP7+hkJOolapuIEqqR9RbH2flBoTrmaiQoQXo4aU5C0ur+l0WrTF3TW42V2HdYVXgxuFuwObDGpp1mhCNC3xO41awspRxeaqVD2X1GXFi/ZjO4io/a9IJ0QzMRi3BJ29gLT+LHMlAMivmzq1uwRShR8E27Uu+OBwqAV0j7Z32E9e0EoKP2nR9F2TYDgzme2sme14lyWc2f3hvTL4mSATtmOt/MDr57+A99XNu3HLy9zzkhBnfHVR3Dn4rQwqRZOWNtTMRuThsByuYolrWFsdXhiMpon6htM5Gq711uFnZD9RYkHZJI53EUrKfCnpRcpETaSXHG6J5Eo1QTexSe8+VtAg0Ocz7M2zBf5RN3rL/Bv2/sI9RdG/mYIOFH+Qi00jp3N1VBviP6AqatsyvoHL6eR9mpG17dpuohxGV1wJ8UUgiovKj/K/xrikjiB7/A+WQPFZmUwV2+KNNBUFEjlOjfxk7vgRRbw3io2ubMQ4+wEEOsQCrzs0X74nFOxSw1xIX5zr4BafcxK/ylwCetpzRodwI9KjUI5FDBAo5fSshWumt05eFiVmbsyhOLsBZU8XOA4kkVCypceDin6J0sV2n6ipArn/xOULUOuGmz7DxVp6sJYd6+CitCVmk+OXELJDCjM52MWgxnit3tnehSMV7LY8pCI/84N0W0RPYR4skzddWiX5rgLgu/S9ZIVuPw9UjnOi9//MLoEYIpBrYy8cOnCcE+WHYPktozcuaQCRMBBJeMBf+4f2xSlcwqcg0rr7Ndtw67HsL6q1k+0VkPJeIdL4m0MESjtGnjme2qNytUABOLePQ0So0Bv707gzQGHFvFnGLaqZisY2Ad9ZNS3eWGKjm/d/sx8N3oME7prYXKiYlYbKuLJtib2eT2/OVCoqHPNrT56YO+aKQdO87JwpP5N+g3qws97WsZqzOqU9PGSCIVQVtRdpQ/1JPvHvJI9D+47mdsXoAvgnCh7jJoLF75N28qW3EgkwPlm1ZHvzgoHvQXhbAwjZzklQVeaOMDD/ot1rSch+8I3s=
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