uHjzCXFCi4k2yB/bxgewBkpcxIcKfdkurMf8WYSa3DOIlUHLcJ9tIPGpluYCQ9chEv06MeaMXpUhvttSd0ImB1dFXrqeG4vhR8oMRmwAFNgTWDOTdB1d1n/I9mc67l/TbGi+k4I4sV2OUMs5bQ3vJe8yrcGU7nDcUB3czjTzCqlCjycMZel3GLlrRSQKzJBfeIUWQO0xQ72b/gUaymAEIrWasSHxY2njiYDciCReA+qDVqHD4ldujr2akg84DgstmYC/dzERe2QJFR3isTXHVtBof+dy5Vk39kZO0q4plAKpH7J2gbmdWJyxNkdZNBStV2TTtXAafxc+vIiLrFqb2tX0Ak0ZxY6OzYULJSct7u1vcm5BoxwNdWbEWQuoq8CU+Oz/nsPmcnyilClDibdEn0IPpBVa78yXMS/bjr9lnJVy87J/LOeSsnIqKgEBOUYfbmR32ocdO/DyKftIOSATmjRToMuMLS4PYwuffblKfVqL+GCXav4bR/FH7qhOv30/Z+Qvth6j8ogHA71kaqH7+xiN0YKol06Pgz4erf/JE/HPO4aoLExZdHRMqumKQLj11l2joqpoL4FXY+jE7LPF5+/nXa6gNejkJzZ5zwQmbTCTbJOlPOt+ViGSIjHRRLxI7s+CphwEL/gFqkuuphDuUohPMMmTZdKFRum0/xsoUr0YWdNWoFyO5Obr3U8Gfh3ruIac5qM/Mck0iASw+FNrkMa5GvA8YmSWkgSLS19bSoRozoWxOycIEVRSII21j0HoHLrNWyVV/xw4xm0rzu4GjDuK0fHjZKymnLi+BPF2Wi7gcFUL6xoi3kg0lNWhauX9wjp6HPnuRggcE70ftv3QS1dPiEk8Q2IcupkOvsz1aOlwFF9JY0YtOgAoB+vjShSIZ9NcMQVHT4H0XoQkfY9+LT5L6Yz5MR+hg6UeN25qs2siXMDr9Z4ETeuWM1E+15G8irNB7S3hLF9MTewaneMuYoeGCndqLNaGb/cOByk8UpzPNyhvb+V3iiM62Hss36y8WDh0Q6lWAsDdkj9CGmPTRCM4qMmBCZroRk5N00/EzE0BXjybObdWud1IfrpCdiG1TLP+sjH5usCK6G6gk7GNrrzxTUZxy9pYNAVrQcXEsMB44sdek/3kE61bqeJC7h9JY5n9ibMZtMafzgGM6ntWfo7y9Bdz2TA2+jXGsrU032SmRcW28Z7oNz4aztPx7T6O4nOAMAw4k70Jr51bvxa9+pjt5o0NeXKDKSS86cS3BP+TPZQ7IhZjs5eTJ14AkNXa5QK13rleeUYa0qy7joMJ+uhCCI9P0mEa4AjYsYBvi8Ux4OThKOB4nF9tYS62uCgjRYeKxwzZQ/MDV6IcxZPoYFuSiYm9yCbKwBxLatA=
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