En625wvWDmmqNdqV3yebU+/fqIbTwn46uqniTjeCkDaOAOqt399cu/i8gPQB9kCNVSM8/tra1lTe9zEA/zfI3q4X30Wf5fLZWRUUqWkdcxys+6GEAtqCagBGV7OATAtcgjr7qaPTgQ0YiOCRFqyOMya2otHVZX2famk2gbZ09eRT6RRn8Uz9ITpI0JbjXIjixzoI3e9nVAwtReJDnF5035immdpp6/4LHDqLxLc6CXgKprBTpAuK7SKqPN7gQhFviSF3csLr0i2UIIQwnat/z9hPILAQvgsBSAMpyPQa9heYYJZOj8HJ0uYXDWWI3JIhFndandWMN+x7a1+azAB3L+QRuvHkoVVqMr0jDyAGzNcCth/UH5kKr+BmlUjzjK5ZmAUXoOTA0YHxpUq7Ul6zXJAFLgK06YnfUqhpJyJPkSNtJNXwTbKdVTFovLE1G/t8UFJ/GnTncqsl/W/7+PxIdguIjzPp/aFp79GPMMRi7yd+VSrmTttdoNboTu+MgeXqQMKg5cJkNriQjedzYoidvVRM55NWA6+rn9TUkSjqkejrHlHx2Mly8iRCO7FkscZpsXXOSCkexhmgpjGiuxHdN6PJg1NK2XzawsbY8g1xo62r0UXfmI6ZM+w1anbTpXfyiYgWJewB0XTAq+nulrT1pFrneP9y2PGrdpa9+1aGFBlgQo84EJMQwB4Mufa2Tf5zEGiOU1qU6x4LuiqAL5qE3OLiR9Zhy07d+DBa3r76JqsmFtos9dVVcU7Gc8R/yZkTfwlOJvnvJh43IwRDyoFNsvIFJRYnjrrFBu06mwXveOxYBH5UEP3yRhy0dCGGP9TnrT1qU402EaBJBl1edrVSJx2cRwl3B6kBmHzCn/7+321sOGlqfW2z3PwpqEyKSLHISDGYqBTQvu2OcC8y+XIfDfb7bsY5gthtUAC/13B7VIbKM1lsP5agmzrOzAMmz7MXGYHBo153aDVKxhzoLaRpp6pDlOQPZupsZAcIVtbOgP8Yt7qMl76eYdXTrv67ij2jeP8e2Y8TpqZVCgLfk/WN3nqktSHiqRfKFGBdfRwnTb+x3x0j628TImhWkKKwoSqgJ5RmiRrqBQfUmWAR/2GG6NbHI6QgwYZG4kjrs08EaueH2eP2Nvm/AO/cHaPsdM99bXF/BJa/CHt2QrD0yMSp8Qjhh7AHbluxZWKNZtOVV0cM0VlWHCfe/dodC6n5DNEr/0iX+yxh8tjq6G0DzqmGBKp3sfEQhcNZ8e/j0+ymM6ihlI1vXB2oaOwEqhYDe1xsjYIl+ridqc1hTv9uWRfxzaPZnUOg5pC3dZGagr3m0jKBIln94Uaa8vbcASwhOTcTIlJ/vl/Dl++pTq00/V8AtJqRY/23Q4WFC8skbJ8=
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