HDr4lu/zo5FVjZGJ4fF5FXP1CtGliq+hGNsU6LlqfitLzDmvy0mfwBZaHlgatTJDFUR8D9zOYtIHPXyvRnhpCTobtJbeuXTdaKifGbVAM+wfETlDM42upL0j5egYsxzdPjPqwW0VXswc0N89JVGjfwXCjDKEMJwAzzFr37DpJIU7DBplXJXnff+7Tv4OZLeSpNU8LT7Mb75Wu/q/3uW1Df8YwQMXplV+sKtY41ia+0K/ytCMY+xpiOWFn5XcxP38Ao9/QJFQd0XYiFCn37ebCvefLYpPLQ0NfoINLA/A/5GJdBsU/XP0lns2uErG/wJQuQwVGYLb375kJDZqq90zK4L8VNHT8wXyQgZ8uPaZJf7jXm+T/h4BhuqI3C7VKyEkBr4lk7aNHDg1E5+Z3lxHookGID+gj5QpgzwqPp4F/wazT33ksVRY4ts5h5wsnWLc/G2JVuc5qDS/Cj++BdfNJbnDNEo5slBdAmylSky7g1ucGwh3xdUflaGO9wcFyrs7PsykjHJTlP7PRTq4aK7uWB2ZpM0pOQgbR4TWeHZaHe53OJeoWpUjGWU+xspeAwpBrtsLriuP11W46Z/tZ9MzFKChD63K6Kc7HWef26B0KHgrl8pTr6x0ahgkx8y5ERqC8WW+7FJIk2YhW7WK609KOGpITkH0laHuy4AORvep+xDk9VTDTErsMq+4YPYLo0ZBfoOteu6mC4UXCb9BYEZee0FwkZ8GM8d9RMpUQNDVou/nHwPwi6FUC8UrHTIbN5ma/obRLYNnKTJROIlXcvW+jJReoSuqxyOodm/wXbAuqHiYhqguq0nCH0IkFCzEC3bLwezokSFswYGWfb5KVSKo/zEHdS48KOLr1Ye6xwOubPeKfmYQWnWUqQf7Lt3iJC7fc3+gANmWT42u1zRABZv5dS+24lz4N3/dhXcdq3ms1hUvuRVa4v8BdUrlI2rgO9GJcr/Y+q2SJqGMfkBQUMv+xTimWpL6Tcn7NBD0Grw4X6SGdJbgyXRP+1txYYVyIeLMeKpoj6TfY1cMB0JksPSbkWlpvieGyozXuZ2qCOU260aAdKH5zaYAMo1sBfc6p9tOzl1gEb2Efon8e5nFAajroSOgVDOXC+uSR6H99DZy0hXJCbCqAul+QX8qZ3ivDyN1070U/vApwGFlU1VTV1SW9hpS+0y8+FkhKykGlmgvWHbrlOy72Q5/VtCBk4DfaMsCNgZGRtrdy0DSWEC8gi9q2HcrbhRYOZtxfcx97QFg89EfIJijoFYMndaxs0mCae5HfQV2WJJHkQwy/hAzFQK8LAnwf6yvcFh6v03x8PomIZGmbpdLZquTovKIaeJVLwtfYWvkJRijbjU3cwn2ndJqeEu/WElvfVD441TCi9k=
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