3s6gk1v2OfUAKM9Q4ePUD7wZtOoKTPV/lS/rJFXXVpUH1Gm1nMePi/R7gcg+ytWQmnzWshJuZwlEvvLJRPftBmdk49GSNsq56kzqPwwOKy4DkJDMiGQds39dOLCUhFfSeGEsb8TpHJ0V+j51Se2Pn2PPK0agDuoVpTQ47w6ctqfKQFZEWd2G/VGjr3riUed5hxNQhp50RIK+xFPzhzPH0Oha0Nm8w0ZyV3ZR3HiFFZ+MEUFbZTj6VhW4rTjR43bUcJMO8XsGNIaJyH65wnVO52YsYa3nI9tyI+ORlDoYO9zV66A4ASr6emvbKprmq+ZqGDUd7UDsZW6WyRtE5NNM9C5ovFrYKkOO8ihsv3cExd61QgOnLJtDlpWJeVP2zqnv0fhTfUIn6Q3bsxzZl3UJ1/naN9S1/38Rqdin9XbBA6yhQ0fvm2P0YiGyGMj2RRikp2Xiodl+7ynl3zgHW/QXjcSkh082uA/s+dNkK6QlBSAL3fzZOwKxjwHBkYjidEFX3lwHWm025Wje81iowE21/PVFN2RIz2Yj98v/sJDcd7mWWD3l15MOIAt+gMEQuwGGfZJRLnEKUGx/VmjZktdma5pvOBMU7I0dQgbc6Gll9xrpJwWYLns+WfPPtciyodJbAU0YyGj6NZTdlF1hJAGGqN0DEWWFSzt0qA+H8I7KXHV2QHIgxBS6PCToYcMeSNkQV/RokF3ET60ZK8pau1zWDJYeGB6Iwg8MS5NIp6PtMANEhsPpB/TpckYoQKJmpHgyVF53iWtz+OIKRfByHfFkAoq7Ajza9B0wyvcY820InPF5lQFMcvMdTknStInjjzZpMkwBod+YY3dWLU5YN+sA4NVZv0ACXmp2CHAW3wu8kyHteaZw4MO1G57Ff8fBtKSTtljat/+1CSNl9Rap7CFiEwGHxFx+x3LiSHpncwhlbj4Zsplw5J6OH8D+F9FUQNHZcOww6cHn7NhFR1OEZFK7fzvw+Srjh3YwqFvR9cPhxti1bd4VooNmOXP85DLRfSlIKBiV1KKchF4xMfShD6arDLlUftXrQJLham0GF2269H1oKg6I4NeldRW6PSKTF69b9Fots7KOYTd64WqaeDR0VaRjnb/+PNDTDTYXULGVfJ5y6XZK44jzsogV6u4ykxSG38pv+pW2QefmlFz4zp1wC6ynqozdjsQetbMBO2dCLJMw9wfgXDj8QNY9uGcRWYVIzDAV7NaEjkdmquHh4UGY+CrHNqHReRKhHyeVrB+4D7z0GfK0VITIJhGTB98BQFJmvoCS+KKNAjWTf2n0NJYEARr3A+sx8HUY3aaCC8GAtGGeQSrmeD13iYnmF+n0BtMxq4rZVSv9nqzOZELeTcYU61jD7iHrZXNK6pehwVI=
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