FPo7D3/pBcUOITanktlr0njft0P+ktThQrjwekgLs83M3NEqFxkKXGjpTMuqoJp0LZvd5pcd7I7ya1uMYLnPJoqV5cWcC0T0PsQfSbPjw8PvQCiqEo5XJRnhDOY8VXTxwyPWVES59t9ZVYPRf6o3tEK1hQKJTrWkq63lBMH8HpFT7f1C18mjbC9cY6KB4DwwY8VyZmeUJQFI0f2ar8N3lAaLg4nfgS5dr8p4i4TdlUbZk8Tn01KgrRBaykUYwsaovnRUBie11GdB/Aa6zCw89QobSU9oFPUlCkizamzznFgvT0NdS0gdbjr5rdX1eQTpZR8pA7h8dF/rO7g9/JnOLqiwgx+50bngjT4CHwNx3cAMkSYu0N83RQVAEj6Ru4C1uxJz2PxBAraOilmyxJOWVJYVGV8q84Xh9L0zpdNSnsp11JurUjB9X6evgIGeONduq0pGhDOIdx+VPg8H83yiSQrvrIAUkZBcz+OOrV1h0KRfG/KhcNlx1JP22Hrk+x5k4HjM6vpI8DTxNQ0fSq5qjoDAek6I75e2VAHKSvyM4avANmWq6512TtOGp0zQlxM9siopLXjxrFp6LmJU1no1pllzF30jKr1Jr9Fy/e7i2f6QVACWaLqL6A8af7kpFD6tEqYG6QEztcaKqaVYK5o1xxKbWvmWJlKQiHvC1rLBsiDfgp9xcioCpsuLISFjiVjL1BbX8JYHDRqulmtZXhtZa5U98j38J2Zlosr+E8xJ9KSgXNoI1z7wehvVPpLEgW8wRTcfrYqu+vUNLELa4pH+jlOh24pFmU25Yn7fwCBFwyIgVQ35WeYDRn0mlDAcTNOWLBgXVtRqvcleBnU1BXGVLiKJeeTUHjK7MIGHyVdltbkIaw1lnvzE+gS7fbqbkb1EC5ms5TAz0FqhZM/CWiX4nt+LYvNgLjupozRtkgsPpbaw64qAXSUykCTDalfIl85Zmw2AzTrxC0r9dqfItRSL9adtdgGODzvRbB+Wzpbl9neBZ26thGJBRbRWHBYZi6WHXoqlxbdISu+6suj21CkTTEFyeUasGbOQSgbdpOPEqkSnQMrmVR62wTs9CE1wtG6b5VRZHr8WGIAehCckNh6SfFMezJrMT7+Jyk7eRmXCrDNbLCuIhzOUSNH1geuOTqeGJaralidn0zTGKbnyRx827dpBevqEgLw35sXHxRkxVcy60Ds5oRyqJuARWqe4HLTKfwtCj4pKrGlBuydg+1+eY62LhB229HTu1DeuW9ZtUglrHrGPnGdJgso/5MjUp9wjz3jZnai5+bLwqZoYUlqTxQ5yf4dbJXLQJ6tYLUTf6O+C7LMPycLoRX2f2PzjjYDpXL7aNdbFGGfvOQ4Iw6lIRNwMn/a5nOrYGwgtQqluw1LEkkzykJZtIc0q+wlt6VGx3Q2wwMzt5YcB1fl78xfgILaO7OutnOESCMDJXces6qikw6Gkrj7wpkf0hsxbB9T27rbutYff8CqbjXXQqmJuD0BYrLq00itBKo/Lc/84tYn4KWkqwmQ+TPlzK+r1dNH3EC9na5P7oH0WDMmrgcbPOgXQnnq8GUFQdCGwd7pxAY1xWPomWSa6FmaLB6IuRgMnz1+m3KIcad4lY2nTDZqv4mkf0HQIKyGeMocKTpgLsWYPyXwtdzo9UtyUetNYSRqMKDHb4r6rEhBXBNeYdzMbXPX+OZhe4S/bL7eJNeX/TPLnO48CeRxjLsdEJF0=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100