+39cxGpfRkGNgDFsGzhzWrk2MeDtUQxTJbGngFbvCKYxnukasfG5nQc0Rnypc/RJZIYTIn/e+T/yStu5+MFe7gkwofnmbBW56szHeLBUM5WIeg2vrQBlCTYqWYTpsmNBbD83FkpiibItH7oINnLL/3+kQnUxKSofMDo6NmdSsqpzVwq2yqlEr+mHgaz9IyCZxxOjoBq9YhNFFQEDCF/pjpTnlw3einllSGd0EnRtCxaFJ9Qn7fNFsZROMex94+HOm5BhILkB0uHb3q/i3H/gpmxP9ahqDfjF6NU0TdDwNbIz7Kut24iJT+DiXKcokaOJwBL+cAeumSmLej/JG4Ok0IxcMbghcQOV5Qw8PI6JVzuA02d9hePQOEmn5GhkVYdZMgNizx0I/fou+gN26UmHUnK66hOCveOH+NjdCmZM4elPNB0E1vHgPOdUSXBFn/8Ldx04meTsKT6WxsXIvaZyY2Y714K0epwLQy4S3cktrf5ppAUKx79s+LzDRZke834Qcdwn0D1UwoneAxDr7VsUanCYSqc5ZztKFU/SX54YDjvd27+goT5wOdlQnWhpSo17FadMzcM1QI9NK4N/ewrydgim7No5X6/gTBkHOtAkrwJZP8ayUZ5ykUi/5KSEyR54gJKI7KGjA1/s32oAENM/ecdKFvPneLANW5iiHFx6zDQbECOEBaqldquY3XvCyCvpFnEO7BbTu85LUJw7OByznpGIdqxg6hLRYpDfz0D3uLzYi14J3cYOYmCZ9LgvHcaHsxvId7Rd+OJwEBF68g8xSW/zHKXAGn17e6eE/UQAxMnTM0NrIlVASeRxQns0aSBeT89rRZVGaCsNnPYHYH5/ILI2RTYqZu64bxhY/gNXjOk/M8GJ76kizcyxonN4Aoq8V7jA07x9MiCwLKBoLqXoV3CY9jKM7BYTSI8S8OXSEXXO0mLdYoHO9nHg5yfc2RgSSqx4+kCUm/04kcRQNhsch775hLUra/vdPBZA6hLpQJYyAmnMEpehQxv85KGQWkD1Bhx90oftR4vYBsV2VyMXUQUt47ejthnKBRYs5RqOnXRFEIgKSSq7AfXnofPFzxuCJXFXRmdnX0657ctlxG7V8nBsjVOraGEydO0GkddmHGAIsNIYvx7eoU6C1+EzdsXXeslv627z07RpCbBlELIE3ZfZP4HmaEZjccVc1X1JVKhYHFGtaWb9Ku8iDhKHs3A+G4N/3Jbrl+HT9D91BwsnhiYt1dwnzpcOS2JECMoEnH5DW+7nbxYTPPxjXF8u57cMII3ORSz4iXlv7kgGGukXWzEvZ8hMZt8nQw7xL9ZX1ywaJ+saGclRzH750sVB2bW5sjbT8BX9BQmzDA16iX3H4EoJDErQ+4B3cXVIbBE=
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