SVH2+rc3ijNTNSi5kbQQuZtwTFoyb/rfX+7YsMzhwzIRj83iaFqSCdFJ6ryaPOTwltjE/On5LVXZwAXvYOnFV7oA3vjLon0Rgigjj4WGpWUM4oljJoPLMxh9kvt6kdnamwn32XgEqiZ9fOPiVKWpaxUhficbTcrLAtHFtRwkQ0aulJMFOomlH0a2W8XZNeBccjzWwEuUYMd5GLHdCbVYFjT8CvI4k4Ut6XQ1JF9GAetgnZxaPzXqlX8IZmBjDvHHeBHOLki1YgmHCkI2xvAASTerKbttdI5LT0ATUzTap2c01frkejVsJ/v5fJrKVCQrlhP60+WJ4Mpc8pMAzC9Rj1nKTd3xFWf3EfpWAvh/bzB95zEToo5cbAWjjLU0LY7SACc2cQuy6QKiKE37UoamWlSLnPBWpFhcXXSomp2ZcodpIy5e0Pk2APtAJcZWN3SeycRkiSg+xMPagqOi7ZvV+M3ELo5iz/ESGlG0CqtcENSCxT8orSlp8m09UlQ89zUt3DGKls3Ryl/7cl+7Z4EX3CgX9VP6Afxp5pzwAzbfKKbfi+U/VJoD9SlOkAJ8e1JAKWES+Vh3y7qbk606gVHWF6b0lol5uxFIjLs+hRNBOqS1iq8ggx2m63/QHGDmI4H9nn+y8g4NIDQRbt58EEj7rDqSOhj3Nm5CLaWnsEiZkIRMxMC6p9N97OIt6QsTgPNiNSnMLDKzAKXmFT2W6zQaMxOKh0Psz2iV3Zlz2UVDyNXhn+LxwrQ9RVp7AB9nuimCoESWWgojTrwPrIpWicA5B5OPYTp+mlomSZnXoz8Vvvlkwq9c3Y+RNDrg9XUHtCKSskkqIOwXVr86fyhaVs9fHkQOh+UtU7eJ5x+4CUwYQ3mxsWJe2lCg8OyvBIxQbcIb2WebFwcr39cAJbotVoIn31j8lazvRDG43srfL2p5zx2O4jg27zFwidQHQ/Ek/XB2UItmtudSPNIBIcx3trW8UW11ypfU9q1RYo2z5OLYJH0k6gR2zqpuAKVRmKe5P6zLjClIcygzImz+fqYQEXvlvj+YAmEPKOXA5LUa9/Dv7OS62ujPyP4f/+hDWUp/N8V9F6t5o5l2ANmYPpIgN0OqqDMYz5rFEv5RpvMY87fS92Qi09E3v+DI0RkitYroRHj78rHavLRoMnq5EwM8+pUjTMMiFcYb2lXS/Kc6FXPAdGE/X31esN6cNtQJablyN2iyeO+w19LQ7pQgv7qJw1jCqkJjVR2feur+boYuW1m0qLSmuDqRz+mociVG4ti6sNX1YzZkScadroQXM+k7FmgXe70KIcKgnmFQ+3rH7nWsvag/gPF1ovNHmOrY8oYAcS/Oj6wtVZhXQNzFhZdXpqpxMqCxtoEdhO3Ngek+9ubg9nOIz54lhAWF0IgGCRiNF0OtUUotmwDCSC7ZB+dUMyoSEAnu4b/sYxWSjbpkcPojAfkWcrjiiqIpUhK0uZ0ba0tRimHWFrxNA2c5a3RGnCO5Xcae8/MYJ0avR63sy+sIerF9X0pe5Zv8Wz2HNGvZXQC9amRoWbqAptR47FzBPq+dWB18drcOtZxkv5tSJ/wqO9LUDqx95hJoLJkgj78aofii9CN9y0MIl4tNKWbhdSx9ztT1sNiOg4CVQoYeYvxC7+zUKWMumRfqoBRiVUTiO0FYLNbBspZA6Eo1EjMOAlBazhguWzSpp8wVSLoiBJRoUrUG7DOKyNg0lNck9Xk=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100