XFm+oYaFpER0gb6ZoMUWa63XZfVxZ0WqFKqAXV0Jjori384aO9SF2HUJvCTE6GZ2NHFyvVlyKn0yTivSSSX7EF0mDrLULw7VVL5kxBkVoarGzLmqM4fqCLXozMiOjdrXygAaY1mc+CWGaAvWnPMgen7KhVGO/Pat8wZ3lcK4H/jPNNDZ/GQLn7pSSgh03Fowpq37hlLmxpoC0/9z1+aRaBfw/anYpWgTtfh1D2pgv9PXfIyAnxp/5GD3zxSGxZRW+Waj6MncR0duD0SiXghKUx/mrFJYPvRWukmEFptbA9HS/mmM39mz3n8gQ9/gLPiA1LSZM6NaDf/L+DeF15N8pJ5RtpvsOGaXCPosXwVEFxhNABlK8nu+JCm2v+xOHC2CNA+TDwzs1VCO+1AiY5BmdUAfx+nm5a2/iITNJ/46OP+aFKwsVi5NZscC/YIgJOpzIvBRqI4qAfEwUywV2KnpE9PfU8v4/My12Kyzi2OY/2tjHvwmj+eeCzuBQrE5RmJgHj0PhBFNvWe0jRwerfKS9CydyvavrPSzqdx+lC6vJpckMo3uI9nE5INMURGQzMD9N6cp4XSrNpJMKHfn7NJ2vhRIdJIHbHuBpC50ZlC1qmAHstcZtH0vmPWYFUbGGbUSXS7ZgcjG/rM140mV96mWyjex/xGg9HG9Ljif20KULyi/PLSFuo6fUBXp01jARwEtRKvom3paVWceAANoeqxLZtrUcHgyXg5svH/OH6gDvJTTwil4jXnWJr4IOpKAb5sGDuP0THOE3ZmXffKWsZYymlidhyblBQ9XqwjeWF8TYkGYgaGf1/ByJwuX3NUxuwZmWZagBm8I8aCigJ7yXjiSSauAhupvEpINUKcT7Wpq71CiKiFIEv5NLGerOlAPoR4pJKGN6LPLIVS4iok/olxCEhQDCXEkfiBfiZXJazSjDWeH2AFY67uqiBeEzRTCcD+DisGhN1NXLFmB7eDfD+ji/tzJap7PxdteYQ8LOScmGF7WPu1zq37OIFUKQpQNRzh+DUNTDibdkPaC/Bj0AaYLNeG5Nj0uGhjLM06621VmI6Dd4K17VTd3u5sPeduJGorVy6BpNvOWT2gMIJchSRXlNZeuInIPvRjXn5YGiJ1ySvHJk4XyfXTlnA4NEzH3a1UhvbtI3qFeB9VQOx6XFcm1AN2ibwvCU3Gjs4ZDqes73H1/tX6OdHGKy7s/IPR6j3f9yS/mlOczLXywR4crKt/eNhlYARiWidLutw2NoQLVVSD/6oGDdTWLrk0Tpd4woojdmf5PyiSOlBOtWGWLcdMBKS39b04m3gd2r0sJxaYuIgwsEVZgZd3PPF8HjPMBjyZejp684NIbL8fCWldZiU1nkl+guskuSRUQHl+2Kb4=
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