vCLdvdtgjaWFwjgrCW/ijkHKqVKOgH7x2Iv1cUPFXw+RyY+J7vJLnY/1gn2ez2FW2Pbj1OzW+ogeGilCEfFQACTVmhz8CcygH+bH485jnehhjQ2k3hCRR0FXNSfVX7WVPgXZwNqoc4kNbrFpiDFB1BiHAZIk0YAyazu+DBdw6tSRcOf23y8S3rJ22iEusVXg0jPr2TMJTHmWBffMAmxuBFWMJJ7WIZz2Ys+ixTFZws/xNfSOdXXbg6ocStsTU7GzRsC5s9UbaakiCiIiArdn/4j1u3diWJF7afhQopiraSaxg+2POl3Me9ZXq8Yr/jqTTg3gT8ONK1zDCqtdXS/R+693sk2kHy5Q2QXMQKBBNOGwTth9enA25KgC3W62hRe3TC0Kd0hmu3BYvh4CtbCtk43vYdCIu+GlWD2xoeJl0NXo0srUf6XVUksScDKLhkNPx8zrbwCqoXwprZwLqPALI1zbVrWtkIcJVeGQAyjqDjCECug2q9WaN52zf5DvUuDvkW8eWBTGt262aG0+Em2B+kejsPu7U3hsKkyC2wuCUXfLjNOHxK2QePXd7dD/TVGbeu6NLXFFuIDCUTSYFCbldfztcUd9rQn8opL2WPFO8fcR6WZJOgpj4MwbFrzeNYQUFUGyoFYwFN4t7ITSCLohYI5jR7bWnbClnRtiYozMSPL+m/8ouPq6eVXLB4ClMndysSU5TWVL92Qs/9L8aPRXRz0O0z4wu7a6Gyc4zMzfYt3zlrcp6I155p2IYJNOlpI9eLD8wOWaBUVVxbIZbIP0TG/LLnpYw4i3MVRWIzIh6h3WU2GSalvSJhYVAvnWwWpZ3optNy3uPxRBs/RTXIacFGkPzFKWbkH91ecxfw4ZUqQlr7KxTc08c2l7ufS2D/atXSlIVeG6CGSQXR8PXcC3rxePQKY86FrXFEXMi4se7mfKRC04yg1HQqjX5B/UfM3HJedhW3eh5OlwoQ+tOQpVgP9OrJYxzQma6hR8QvIjgARUMb2XlUzCDMfqIIQ1FCAFDJnuWBWUmjF4o0W0mbpVogkFfww4T8nYL5+ybwsRV3EnTyI+mvjojG6gzFUDONCk7H5CNDkFzLxxtKn4WnVOPfV/XvXv5F6qOLBXYLFW8wUb3DrsuAAtB3GpkgubIUJOSHq0lorxRtCAjnM48fqV85oCtScCz3BfReVrMkeReTh/qeXgQGHmTzddjuFvomODvmAGBKerydI65uKXLk398FHvBn90xw2nSCiS44cANmQle/hTjx74kpVr0c5qzeWJEYq5nZQ01pONvxdNeeHtgSIL5iI0ElUD1m+FvoiEy8nyc+ug5O27nlVtfswayFQW+MvqHAMacAqU4OsBUSAQDVVhRnQri5pzb4bfVpw=
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