vGJ2B2vGk2c5uBofsi271eOTNcVUgnaQLTqZw25xFhuvXqCvACyXpg7eZBnlv0t7nnmpYUKrKVVkTP3PeSbo1n+Iot6E0n80UY62S//FAis5BgHyBwvkKqHIKa518NFbtEiZCXaviMMZPpNJuriOxxxj8+5cDJnwZ+OfMI3qNLSHMKPGO1BQiyXf2lAOPNrw3AavZN+pPQ+YpUsSuRsHjX5/2+RbzNqUS0roq4v+/MWRrkQIJR3euqyMhFhCq4np3eiJ2EH+YQmxBLKOwmdPZZAEHJKB1or/7zb7bN670+0KbVjvfhN+n2I1tFdCB3mPhGK4jKCdxb48Q5B8Hf+Lzz/52iYvV0el3eOwSxCbSah/f4GylOi2JRILugNU5L+8HoIzP1UIdkrMcRVDlWN/U5NB7dvGzKrCTPqPwoL6A6nfh2gzg27cpIodvIxi1AdYXbdG+lwzkVXVOQXhlysV3zXQPkzQ6kuYAomAvy2qnoF+32Lz4TRq1ivxMciAnDjvOkE3dqM61+Kb3z7Je+VOL/XL2N11eh8sr5bY55uXoxcoeqRbPNwFRTdLUPZOMLcUSePhc7X6jIPNlFgdLzxNLVfh1d8AuCanYmpvzC7H4N9g+yekQ7SAqwBVseHvsJE/dbb7kB7V/HjKMX1X6lxc9xB5B2Xf1s0NUeT2a0/Wb1cz74F2+7a2ISEX066ZR5SJYdrZo4QirbPvqENacqF9znMiIVe3EsNzXi36sxzVYeqZqq05WXbm/72p0tx+skpyLAh7p66C4RzGhf84vfvT7CPEht0uOkr2roakLye7nwyGFr5Cn9DJ2lZeslyVe1Gibw//4UfwfH5nYnGet1ZhZYWxswcvshq8cFxTNvOhaNmo0HIneoAbJQEMtkNikcNACT2V/577J6CiZzQzLWcWk7wDKOPjzQGSK0exbr2WEAhGotIfn+wpEqVtum1vwSaTFcZhafQZXy2Kf0Pc5ko+vfALLtIMiUxfznPFIQFvKTHOnXmW23PLnjc02zfHNWVVdi4iB4tKaf9Xd2N9fYNmFzuxkhOKDQmcCj+DYpx21HXhcU/jCm4zcfmF/LdoVfZXcpB24qU+n3eGdzIPYcUW5aKQbmqbVJYWcVsRDmbLh8k3DJ2tBAwKK1FBFap9trl5zYExNhI/Uo81WiEioylZTrlPk0GTg+zpGgrN+Sd7FHwqfQJGWJWz+2t/Azn/TxcFlag+VY79XL/Nu16B9fEk1G+BzIc5rCfNKcv+zlW6kpO2qkRfvUze05oz0t/l7brGOfnjJ+1OqiOFd4dYHOf48ZrtIW+LXoHIqIeBfZmbAHt0jPe6TNQancQRA9ad4HGzTWd7LizcEAy5OBJdENGsRYjrYlhK32lBiDxJ4UU=
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