gTSMl7yLgoQLhda+WZc2gFD4TGZWhIopZMKSyjxwlUdit90DwRMiN58ZZqVUrtUmpOME3QesOAwrHjJ/0Bd1guMLCJ/5vxUrv5zIVrDsTcHLsyxpfmeoS/VteZxLTqfghPnzOxirpo3iMehSHZSHFFnZ1iFQ9Gzj0HpEmNh0nodCx9pTj6HpLCPgfa4h42AZVcBjuLusOu16Jc7xxGLLGxqBQwhSRPvDUV27zKXxlxVd9cuwLZlsx6qhK7WhPwLHCiG4PeCPllwJEGDOQr5egFuVCWU3Ouj0IVTXMbIXARA1ZJ9TM54YAfleIyGh+MrQU1SnLxfD3is6Z+yUga5bdIZUYb9vXP1Z7u7Y4uqOgTbXMATYIvbiIoCP4HdipSvyW4o+juRi5L5w0KJB93ibgTULODhEYC37cvPGz60xwmx1EC5M7qgZ5GETGK3tPgs/XvkXT4T69AdmY2WubH3NFFhEcBLJHgG8e3519KUHu8tbX9ihc0sNY0y6/0CXkv0dteB63IumRYM0DpTZXkBj9jU39RHHlGS71F0u41L3iutnzjZon8m5enuN96b8WXvXh0/Rmt3nza5P7FULliIv3WrR3VM37YAZMMjOLxY1wI85tZd6GHQtol1B9g93Hfsm4lqXGSegHk59DyPv3/ddhbq9YCrLLlrZbbLTuwLMnYDoxIx1VdA6JzWjYZo2hrXRKhYR4dk8d30wlrvAKMzDf4VA851T5oQxta4gcQolUmaoKYIJNlv/oN7gRMZLlnq7oOk8PBULB7CkE/O0M9feqFXxM0n8zaNPVI00KY+p3aQ/GzhKSI/UyCWXvrCZ4E5eHZ/rioNK9H5ZvFuD8Aeg9Tdi876PnobtbS3xYSxN/zid9tfuDkfID+SaqaMbjF+UY75kiu+DfW8dzWIgkpBpZerplQxh9cGcG++nCi7VgLHQogl4LdNTAR1sp9u0/quWEmRi4SLf9oENB1le0EaZioQ0PTaXmNJ4CLtxjxW/OHqwepUkmH4gl8IBHcc09+8w4RAhhXhTf9Pqf+lw0iKrvdKdjrM80nXZB1cqFJX2UMeW8BQo67JKKsCtVBuamLPfRVQLKGFMPGLPfX6yRwK0RcFx3aW5Qiu/qa5cyb7TzQ6oW9WkGdPJfQrtG1kjpGS79e6s5n6tkf8EMuYJRQxgGpxIbGmsSJrrQr+Ootbf3FMRbeST9SEcSbch086e+GzaxyLrUq5U0cKaRYImBrKyi8Syqx7HkHBIdOQEhHatlreBLPF9Ovce5Tvy+mzSZeWYQSlmxw838wH+QsMqcWpJnBC7hdj4Rh+lxXqmkEsvCaVwEtjdThOhQ68KjCD+ahC1+s3o6cp0RVCNcR3H6nKOrvaWlXp2AcUuB1tCeHs=
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