PPOI6Y14J1Ka0wnnn7N3VCLQCEGTOmJB0TKEUqikTj4yBFVdAlUmKpvnHtVRdLfzCPDz9uYDHAZwPxUkD/Xc9WOMhPbtqak5RJPU1FCfZ08sbGR3Ps4dftZm86UCs2r9Cx6cUi7S03jP2oB/Sy7Xxb4f4C8FXYsZ+1fhgJzOlrDXFQ7U58jAuLbIWj3sxLcH+k2MTh2V5uSklxkvozMkP1ApJkzDllQ6jNb3vvqg0C6TrIoorGosrr5z8kgc1huQWIZMmuTpkZq1Qbq9PT3wxdIl5K93TMjErPWnhs/dp/SatsCNSV2WZoJlKxgBAzRR+fwTzsRY6zGhDUgJGJiEkEVXY5qVGJh3LCSYsgZ5nxO644RRplsWzyDTxTUtowW98Swjr0cEbS8E1LaY+cCAWXZSn+HoQ38v2h8bndL05bVUc1yukidpVWR3NgLCkq0lYdodRe/r/1umN1nO4wfh2WIrRW4vHkmNKt2Fj8StAjA+EC/HsUnXih/jXVeXTBRPTGKKzWlRPk2l7DeLv0X6nFno228TKSR0tCYspPwwZ192xNJX8/0FLLoOORfCP167q1VGju9yiQr5PEEuXbvgKAbVzb4FF8ep1tUPXbWJNCpLmA61CCR6NCaVseS5SwPIYCMwjGRiWomjt9+7puoKJ4KJbDq4zf+uYdvh3QXa/S3r0Q984b8mzmdin6+AYu/729TMFzdTeARIJ43c4yvdEm7M2OjoE5+OfVRo5GdCt18TreQxQjw0e6CgUFnwBPnPXub6ja0D85qtJGYGNeh+8ENZ4kh3tGMq3eSTyg86NWBKnANuBECKFCfTVhHIG2oY1sv6daF9H1L4AKaRZcXjBDkrBIJehRSUlPUBJWO7lecBWP19nxwojxbZYVnSBOchuz7MJR7bdWTCT8YGXaG3ZZHgQ4obkOI+9T+cRlLvAvdgb23ECDFqe9ghB3VI9rOHaKgcuO1J88gKOZzqSbOuQT9o98oAUtUQKoZrfZC1cVZ56OEBoYx/GMt7Jb3faG8AhuK4/mkvjBYtr8wUQTMTIm0x7g7ZiusxbxDyF+f+NM65TDjWUNVr8QjEFSvji4OzR2XZPSfKQk5uNJuDOVhKFiImHr6PSQkX1HFV+HDg9bXvKMu/R1BVaiOKN5an4JWUDYwAYRw4rl0+343q/AB983odIsDCHHjGSNjqVQkwWORUVE5caZjJnBa6VdZ3+r9wL+uWT14tfsU0iRqoVlf/KD/l20S+oHSGJYsF13ZOEG0v+zkOKpLcxvpgvQIpIcn69kXRcjrHg3/G3bg1eMjuCP517CNndrOM/g+vbpMvawhiNSrFRdW6I1VnfHOqMrzAq4xk58elOaWZEpqv2iv6m1NX2VorhqrNI+J+Pmk=
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