0S8yybthjdUil3gdR7rk736S9SD05o8XPCcJyXq5dwNAPL/OIfFPs8vgrfDu1+9h+Nx/FC0Ds1hUH2mvk22PlzdUdldxdixQcDh6uKE6FNEP8VqgfNIl0EZz8BxcP3h7ZAcoaRahMW6EALQCw213VFVdaRANHVbkfpQXhNULxdlLXWtD3G3an2lgfqo8aiPT6t7jhm931NNAgMfdcClkJderbs52AzSbqUc1ftRCbdJ78XBpyWDm6ix0gJ7ABk8FWfsxlQJ90x5jha8KPdjUeBCKa4jbnMuPbXFDsUqCpp18t+clT7YQLtSVms9nyjLG81M2Nvx31h9Rmrza/1n0JtJ/PAt2cZCY5Uj107YryfvO5z7AfZPF0JBSIXdV89ngNs+GrfOp/zRaJjSDEH0SO7ZkIGDKe0V5rPzh7IhDbftjTPhojfYioM9LqegF+73UdlJpGamqFX2Wq3DmbSpJud6CLSJDQqoFt6obduFBW+/lVnWz5n1WMMHqWkdE9V4dziJjELRc49AL5cpsLntgM5pvhvdp/niVttSKr/YysLskLo828fNb4mBReWOQnYjQpd4DhC/gyMDWfU11V6ZL7BrG5JJBGFLcYZVxH8r+laKVGAJE9EvkXYTPwYQCCLwch1v5ED0CWXzKSTer+jLHzSiVzI9vDIEb4fzriX8jf9vetg47QujCi3c6WBZwKleFvMKDqccsMgMUrddY7ymolwyHGlZH3uN5e5uulqjVZX1qzw/kOuLA0o6/AEOcZrHZ50oCyojbfHCFk4dN6vCisszljZ0sj39/hLUUYWGvcyP8tI7hXJUSuZSJEUBYIwYcEJrNIRzJ+Vd2AHvF+Jz8XLlZPeiigxpY7Diz6o/E/WljnjXvnqWckHAg4QBSytTZmXRYd6cMpOuz3ZXiCVRHN+RuoOHO10U+OapsbBj1mEApKnX4n83ZdvXahug956Txr6/sc+DTTvEOuP4EwE4HUvg87CzsypXr2SOezvBIj9lOtGe0MuTD93hVI3Mk55n6XFTIA1OkZR4AsuwL6YOyLXsg2/ToeLmYUpF/i266tJu56CiGaL+QX6BAhQy9CrnnUC4Q+5EyjnU10YWuc+Tv2+B7Cr+gLg/0L7OPfLM5BPqrIevtg2VRuzsdGU3f8T1ouqbQL8YqMntjPaTpyyullFd0nKQEsponsdvAbS4iSXnwZ441wZq4mFXg26Jsp1hxpSww2A14QWZ5WbLjZRhqBWp8tRGeTTNUOXDwAT0ruB39kkXtGrO/pojHMp7PN+x5Db/R7D+9v0gb3q89/JJwXH5EUz1J83HJT8txtAcvkt3SZml/2daATsQ6a7oh+is/n7juS0RaB1FSZq/wiz4hOv7tw5d250Qyw+ajzcw=
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