3ro+xcVQF01nonLGIsqzXJJ3aEah5jpphDRLIe4/4nc/CCQ82536BDCa+GWsscF4CCl+UnnG+Vj5UcM2cce35lrElpEhlxjtLndVBUCVZnrUTDGv/9QNELfRc6/OkdRom1ySewaJEaCUwSPH4DRzCLoRks6nfADoepJ2RPqk2OrMgPAs/3GQMPUtHuxf/3IGgUCOWKThOGEpyBtp71Rlqt+w148d73uWYcGu9fppr8bTKV8xyRHEOBiftoCX/OfAhZu/dHJHLWyPZNmWMUjRGIpkc/A+KxYfhC7UXKvdfUk1J5Rf2nULCZVjE9hyB+qGNZcFOyfQHD8i4B79wo9+3UhdSxB/v6d8ui96cQ4egyi+I6NLBVxcEJBXi4B7DgXwZqLk3hCalxLIHm2nzA98DJJ1PSkSZP3t7h4Cwph0TU4FVmQnDe/Qt4HrYPtdSE43Vl9beXdhXTp51TcmdMY6XMH6O5+vMG/D+E2VOAbZtYfwYXSFNrShl6JKx5Z6xMnvPvSiIYyP97UFMdnjYOaBsCDYuVj/alWxI7Amp+Pbd91JdmE9VSdyeJql88Wai10l8elkZBQpUFJ/fyOZYSiK6faXAgdDZShV6nGr9rZePaTf+k0UweUXZXZgvxtLNI9uu+sAGX0eLtlbQGzgGDYsnXHkKFmNYqCensHc7vqN87HZJyZc2/pzW9643MqOkrchiGGCsJTdkqghTUQ8R2tCOvT9Wdy0zwYp60UZsfPPZ1uiiSaEU33X050FBn/UEqX4Di1zkCPs7dGHDwxoDuAqG7OF+HflsfXrg2QIcLDy0d4Ob7p9JV7Pe2jWHtqvr8rmrBQ//2ogTvkE0frS6QJfibyViBITb/EgEcY7VF4crTr7L5aybAkowklmkQrbe6E0qBkz8x5EsfzFUBJrMny3oDkmgBpK3mJ26PFQBpAKZX6Vx7hRi4Cz8Cb17aOaKGoPFvWsTe1VrU7tXaiI3H1fjuzboP9ci2tKajJNfW5tvQvfymJoXbBXoCOdu9P78h3k2MFPoT8m+OEvpEQ6zKWKSvzf1/kqCJe6nvbf8BeubrqRciZn3bg/aiOs2wiBDr2dlMYkpU1S87Gk4VAMAtS+J/DcfnpxEnSOuENWbCqYMkmSPjDDr+bQy5Ogd97giw2iZOWq3RwWdi9mQZX3Pqg6/nyzv0dRkJ6nPULNp6TB3amclpHnjTa7cL1Fi6JrvuLBn384PgOOuJzmBmzbkybgfwx4yqtFPKHb4L2PgJWYoLe8SEHcLBsr2V6SaNPaM9VlMfCGilsIFo5dklzBEiyMNZfUqwt+9UCWQktC5QWwDvHoHSdyRk9JXzFBdPoVelbGS6y02fIHb1+3XVAx3MY9Su+//w69V+YJz9lAncU=
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