QHartKaUS8aPOfBmw+43+1FF34t+qvPzSJLQ63vyTBs55Mt5zMWghjBpfSmfsDHz1J4UrMy1/vGu+bSF/JWlrDyvmZPJj2cnvgGJ5GFgIAWqNfL8nn3nUEzhTAvwUfOf448wk/sX+vbFidHdfcd9H8+GPT7llWrJyum13HjOutirSz6GFt3VfU2rTxOnwlO1jvtIGVpeSVZfjVvXZybuF0cVd9QfVafSCZYAo/Cx8TuqSwPfAFgdbX5JQ1JoTSAVGvr2pMCmyBISe1PdxsTsClslHmlK60Hh+fQT80gsZ8dG3s7SrFlek1ASvDkmaLaO0eBO8aToP3BehkdlcXFHOSnse3GhD9rqJkCYEKMbOVzsBda9mlthD4TNdXrZEQ1b1mxqeWT6YHjfCwAyJ/2l6BYHYMyyImiGUcxLbTv1Lf3+iNyufXz1vuUHGaQxK6VfhUzGeTYwcRMyxa5z2q+yLqDAttCalv7i1FlRoXUXFiGhyPVZLybVcOHY3PwnU1WkQTQrZFVfNswZFMCGsvTALWQ5u9eQQDR4z8epwjf/9wFEQ0ZVn5bPfZYaOuIzrekKzzA9xwI4Dz5A+A/w789D+u8fQ0k9zqtQqCINhYL/e01Pq/H32cdeQXqyM/EybJ6go7O6OZl0RIaeNhMipc43cucmlog1eEtJ411Gbz0yrCQ937x5yZI3oF0tmTOul2BqvGmrpvVyrB7PvV8SYPv6vnSA7d3Xls66l9JUF36WVyuiFLrAjaN1ut4w6wmqXKjRhDi9PGubWvZslcCyt9K1JR2H/mvZ9V7SRBSnx9kR54o1kjnp85SqLqrak7QTvV4ZN9g+e7BHwvWjJu1x2XEF1/oikaH/D31uLyFu00aZ9prvY+K0vO2nX47juYgDD6m0rw/E7BSf2qIlHERy9W3uFFYDqLzsePQ+nOMEJE0uJcKWaNTpaGPFkipgkvmQ5EqaIfi2SMcekbTPTM68IqNCkXDx5/T9XhMxdYbt+EDqgVDUOUr9ZjWH247iqjnsDQQ0ceqf0u/c5Ufxvf/WNJFZ21LJcvyEOLUowFlWTo5bZd/ODlUGD6Mj7H7Qow21DjoyXt5glor+ll8MZT1+NrfjyiN2FHSfwOmqZ4+hNGNcAdkqr7dqlfzeoKGCDKTEaAIbvOQ6uFncctO9Y8DIvIpo3bnlPwiJvRhF+hhGdZWGCzY0NjHAWhw/sCWR/354BWlGpI7BGwb84V+YTRMb9uGL1PFjSglB2eae6xKEiSUHBIBSeSvTkcoKSV6qNR3sEOVfnw+JlVH+pc8r4OUpK/UH+q67IUNyEgtzr/q4gej/axzNNXf8SUSMHDtF153t2XG+gxHnBNVU6M51B7mFzERg5JVWWw4ChweRxyPGk+0=
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