5Hm+c//umV/AzF6lda8RHTr/ZEWNyd5cLhHRZHxIxY22OJFwDY5MYlK/0m2p2U1UrBNo6kyTQ22tOsrqMRFsG0iTzMdkyGMIyFCYXOFlSbgDSNxs71gNqJyz+pzbKgQoApGUuuTNOHayQO3Dht+wXT1mb4TnQlwZ05m7A+2Lmtebd3UaTYZ/Q1AndLGC43xi2lUhpiiPWNhSi96L9ajnrPAtq3JPIPxElgrOP2sgKT/2zVBuWtTxgZGJcp2dOskWJKayEzWm6n/3EoPRnpVOUTSgiIl6PobpFfHeioTvjuuct6ROSN+zChEprP7coLGxfKFjTMXddT9Eg9BDHL5spxRCqAJ5thfJF+ZxqvBFim452CTGfwSPLmqnlKqijUIK5Xv3kS2rt0s8bfobYUVCon28fw4w3AmbGRu2tD3LPvmcrDYAcam8shjts1wQA1AROxglEE79TTPu2Zxizis7EIA0KcAE3o0ocLMd2zx+xtVtvnGQEb7XKdqv0wElYwQiLCL1pBrSEDIcy5yhqs5c0/pZP0buwbM+g3/TEq0fLeljqpsrb8JG+ioui3ehNWT9N3/cxcFeuAV+IrpjVRNet19/E0o0i5U8x7rvZVevhX9i4i6f9pPWEBx48efANHsQY4fLCzjpx8tbwNmAQlSrD8MV1rwp5MdnP+XTbsX//JR2p2nJ2MgmK2XU9DLocfWMWrapH3d3g9La++/lt7+fz+JUJBONVVCKFrT8DBgWtg5JzkYTI1bwSjZM8KKaV0wdnHglboY/CtOgAUW9uqZysOuij5c2kCiMEmPj5K4/Cqo9g2+gBDxU41juAa6TItTPURGCv2cLjUyztw2Gl1mK8r433S0YYT35Dv1+tnsAAkaiKBLbnNDjjljDL5S8mAAwv0o8DCWhxeUqeMHxXsgIjx2pLkvjifQi1LwZN2Tx1YIKPjtOow7IaPfuMgR4Db/Z+OtUO1HEc6lGNP0105yPgMIaFxbkeLtQEjuS3yCPvgmPgrNiAwBHCDuu0/YCiWGlPW4sHbX7ggcuTseiDRw2JxGeXTQpJPSW23fBicSlj0kC3uCXuv+0smEeUC1j/WbHUi4WKlbSEfFjWvoaztl08LV3eIe34NWAng+iZozp5zeHMTXnvJRlKMKdgmkJ8+o9B9R7CWGgVfPz8vYcC5rXNj7FRroMWsV6j2xeA5xc0RicX3EfAJrPAkKBLpi1kbqmokdrgxwC2Zgvm6Ib+CHFW/AA425lSl9sqd741c36sGSUhzirgRxMICSLa/joRr+ANKfK3tLRnJ2JuVDgnbS7b+2rPjiwoQ+43RgRw10/r5IIKCyI3bfga7+ew9xFeoGPW5UxBodywnVhDcw06UO0I+bg9FDqeqxXTGUA6rs=
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