4kcJiBtQ2+49kqHL2rgIDItkB74kHkXeGDf/cch/TixTNqy+J5RwRbpcxHdQuAVHCyQaNMc8oDIj78tMLGweiQgap1lJ/JLpd11g2XZjtFjdC1H3wq4wxQIVJGbk3VzPZYPH6c85IJgvEvcbl3OyYSp7WuGuKuNxeWqCnD/3KopeE6TAh/Dr/++J9aNSFAjPnUfOS5WUetqdK7K1g3xxsn1kgYw13IFsej8NXcSnM1XiCEV5jhfyjumZi0DK03l4oYUe9wLibz5RtXHvlxQisPBUtAJ1k9VSWnte1UwkoW7g3GaeEDd17ZirJXj/sd+SNDs1S7hLittV9K7ZVUXdsBTCNIUUlApZLUPfxFxd87R5mJP2U99pHXStTpNQqSvRkPGK97Ai08UO7PEkNd2W/ioXR2ltbPgkzE3ROEy8CxpRd5lfV/A/KVGQYIvDihoeJAWC/LSWjRXFC1WJ6pqsiHKGIXlFNqD6ZmMi4SpPUh3VIxq3z6OOCXzyx+dZTVFE6yBaio0EjzCZUxTIUipTz/0Qpij9grvnGnLAIsDzcXTpgMto6uvZGwtwxqN8H7Wjqf+DVjSFCDsuD2pnu6SAP7ELSxv9LohFOE1CsqJNjq15FNUl4eNsv/AfXEslMBTe1T3VOx1UeJIByksNEsRJMg7l/2GBXmas9umK4/zGfPw/QB4EHya5eM4ji8vUz47WMtWranqx4Ok7nyC4zv3NFkpzMJ10ruP78Zm/wVJH4C/7lKehwdE9SlrEfAOzIkT83xTfCpJ2lmlY/T7kzlPRtHRlij3EwXICiydC9DjDLGfZ05+lGT4j8y9Prj7LOU1slrVRls9IwIU/Y6XhkNzE9lVFMrltH9cf7XdKioKB3Pi2r60l5A9XKAhvPJydE7tQRN999iTYOvURhSmFEt28jkXZTmsk2ADfWUz7icfyRd+Zv8edWoQYoBTRoLVYZrJYXuryNRiCladra+SIf7JQGkoc3dI1qMPEBoBEla3c9/888vGEjMWoerCXw6kSO8fjjUsTbPsxO/s8wDUkB26Ym8MpklwluLdI0jIZRsvuOU92ZWYMhYPbnbRes1WUrDKM/3wfE4TX4nhtdn9mrLzLcheuls1Zi/Q4x8OM9jM9dmm0jxkL0xPFGedBo0Zgxs7cPg214fJfx1TKMePC0hdNux7apAfdvlNEseLrPCUjr48Sx2IB/hQA6N7JrAQ9uPZtZT/hDxg1OLDSOI14JFrf1sbU5Xbz6+dh7JWFJp6cESj5YZ22Zx4Jz0Ifr/VR9cnuMtjLJHP/XM0iDdPeH3jk+JRzJGe3leHh0Q6fgeQtl1Lt3aJYibGw8Zfv+BR4GQAdNjsV2SfiKa8p7CxH9EKx4MKAA/BBnQrIjKBl+tM=
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