+Wh7vCzrOo6FPfsNJzvYA/LFXlxCtR/TuQ/0opSbKDVhAUONZ7d9URfFReKAXrLUimg86eL0wDI5PpwPfv+I+qjxu4Wez6DV5FRTVRGY074LEkCLx+e1dzH/syxV7tRIS6G8mYeySQVC4ye8dT5AuRnHkWSq2Adt/6yHYBmzvTMCvvG/0snf2UaS7y0nPiDin+pBRA8dmPbe7c/gFKcSgLfapHeJJigh6axUltvY9OR3iCCS9icKULFSK8U4BAcXz6Q3cRPvl0wGI2/wtqyIejoyy4m8yxVrOCaqotxFlfAfVs4AN24jArTzKkTWzevPiqpWY2f6Zz9mT84EWgiyk63jLOxoovqlSz6ISiur59x1qIRI+p7IGJR02L3/YOOrmsChMTQlTEasVG6k1xkfcf6VDSJsZR+q7N/Xe2yG8kvsU3UpgkRwlzRn4G1rVYXoWwenMJMXhzbxUGvB8QghnFueN2OIcSqaSg33fGIm4MQDfHKPbR1vvJSOJC2qvgrtVIyaEHJ8OxxS13l1kUdAX5Euuv3544utEQCjEW0oHKJGFcABkyLehAPgbpoj4krr+iQQDu68n19QA4Ab7rjqiCqDvr+GJDBHw4PqQFWqK7OYju67fC+cegZ6z5G/AzX5vKOwgy0jYAUYKeiHy5+i7o8EY3BQxjjeSjMVd/53HdFrMK14m0ogTrlCalZdMmyGEXki6BdJw0jOeJwWuAWknDSAiIXmZ8W9prSdawjZ/83YTeEoK4YpDKEUBsKPERrXxRRrFisMjvyCM1lyVn12Svd918W789WLWCl9jikLT5SSXCJneLWRVOPmCbuicTU64lJCFreXAmYCIfaSKiW3IyAPNF/rQMRPej2gAlG+F+jO0FBn5ZWaoXMmIZtu8bhyL5lqQ1ToKirN3V6QdxsXzG32B9XhAE4NbHeRT/R9unxM/jHP6frj1ydjhtJgVVxnNMiWiy6vtjOWVoUhsLh2K67OC6uUSbcCD0tK1FwNBIwl19XoQN0JIkB0WDjWYYyxNO/6DRUYXMgjoisssmysmHcucX8o3faKIgVnHVnLn/sw03O+10AQppm8eJi0bP8L4YQIrB5tOF4pLdeJT//gH5EieQTfhR58h92cTn+P45GqjePGskjDG3weo7GX1raq+MgvZNJ/4KeOqT+HBRWtsEuw8nQ/YxtaVMbnfyELzBWIr9l8Us8cZcuWJnWReRJ0xjBS+SBqP2vt8jXLUp/JwWZ8kCONhbFP4dUGBFd2C3trcnTWSdKLXPN8eIvE4lQcyN2PYEo01X+CGAgmU+s1osoq0tR0+vS3x6SmLqzuvEP6gvqMkeXJM8QwRklqtk96ZUYdk5MXku795inmc7iDPBhM9yWuTMrN+FpDlaE=
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