dsCfkzUm0r8IMiy2xnV4AcehxBJPPI3mRxW2dTc3PJ7/NKeX633qLmkQ7o7SLQ+q319Pc4BNKVoIKMxGfJ17ZLcXa4JiA88TlMyqNansFCRYc3TFFEQ9qGPfx+Joq5N/6fAs0kmntGWyud6aXp6dgLLLyPmyfH9ExczLw5w8KIiy92MZoUcaEUNF6WjKdp1C/1b9Np0h7Z/RM/r7RKZdrzqbKUzMIRaegp0PEds6WUanIEtUyBG3W2gQyCei+hcsiQvii4V1Vw/AuqrX4xY9joB6rbMtuMgz2+k9AKiUNbQet76HhNsAnkug9NCUNzEsLI/42he15JelQi1CKGYHho24X+b5vVbVluwUyy+UfcQgSXlNFE+1wmltxgTTms3jqlJ71Kvb7E6CsBHjxOizyXGRwNkeIAoDE4kImZbZ5MHEX3aSCtmwbjlNHkSnyQWRMxzSZ1WWtDaDjt/CGeF7r+ZOUuCuPZSg2zw3DmiWRNksiiKmzEFexm1gxjEHr5ilKrG09zDjRi09SfIOu6VlJU4fHeWSvSrR2lMIXoum6nYXjFCddi2e0bpDxIgGLzN6N7q5R53HU1EFi4Wnfc5Nny/Zicp9kkFH1VIBBVhkcrepRFzSnmLbhSyvqz3cMApzB3/5dqAmArZcNKgDA5s3OwA2dqVWV/fUx4Y2/MPbVURBaemK3ZvfY4rwS+qO5k4vB5eZ966KhBiHEqnYlU6nWCPOijm5H+Qf3IQbfHqGsoz4KUnaTbAWezJQfwS8b6reWh57CzqXPXDR/M2jdbLHz4Py/0P1gtyOsHsfbQkwtQcUqsoOOMUY/MHJx2xRSuYUjQ07mSYJARyXcqZXNcn4yGwh2GgzBvIjLdLZSMM5t8vAH1vsXTXw96MU16Ce2J28nnJH9oW42C+Du4n0zgbbz+vcMMw6I54wMKYdO9cVGX2brXGTC/1Slsc6Nul1scIAg7TgYS2VHFYK692wvtCxfHVKni0SnLaYFcL5hukkmN2BnpLa4cXT/wUTR2muVJsj7WmWVgSxTeQhKZx3o1SyTJqvuIhd2R74c0eouU5eEc2qw9q9c0QKd1zCsntggyMyKmpt2u822GxnOk73D3qd6kusW6iVyMPbQIOVjpUK/T+3+qwVHgeNSSye50YJsYZWRtliIroreutD9wY+d9ajrj4k0cu4doQFsnHjxVPuFoyQe+sapVDA4UyAnbeDQbiUbIjcOiE9GZE5UdYR2NUHBwKQO4nwf/83970XAM0j5x6MTGyEX8bXcz8kahJq39OPm44rkO/yrzArcSUQN8Qf8wmC9BX5npZuYVs5FB+0TLIlWqSrM1UJ4sLuD5UnHjFu9XBa1HYtQ3OaUFfB66QhYdbmaGC47E+jxIyqrZw=
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