M1TORLNmjCRcJ4mpjfCGKsRGbAvtHwhKs7sqy6bJXTnmwrWzt8aMRuSg1W5GDggdUjiYkEJOoPnugUJRLKEfgbWiRLF8nh1HG5iKa8DgKYPENwSLiL526r8OSEOjNtCVViOV4xIccnIKaa1O3rbn9XIGiQfUjwWMYqQcSMZN9dbFHeTn3H1YCtLgMTu88cGJ7M9JxwQbpQywDpFHwydzLlSu36UjJ9cZcOh3L0wJBRDUVFc2MizWUrBytRsYao6DEvsxcGaw556Jl253yyekJqEJaxsLCsHnI8H1SSK5odlAYHWHNA+zLLE57UaRQv4omjL9kysXzst8glyjssLh7gkN6f/mXInzVfLvmtJlEJPfhcXHzKR45XzGhdEeLDRLzRWJSzU4aAlskBfKw0kfac0jn+q+et2UC8GpyHkH089vyA6v6fxBSIfgRN36ghj4JIB252WtPtyYvt85d0fSOU4LcfX08jgVOLU0stI05gELNI7t4rPfkVTlRzvWBL0PdsK6+0jNrFrmXuGEJ6Y8FjiQ5yQoVFKCpVp/oqmpJ/6ZUB0Vx/IyRIwQ+jCsO5lRdfoACBjedgMCw/MRr3DibuCv2MDit1KciJbk3oWWPuSBRQIXAVFQ9EomSJ4BaTAO+yCqHQWhchqDznqOA8NLXj+oIknlvG5iq3H3IeqXjwognm7DHC9NPr2D27zBLzN0y39TiR7XKk14rnxZaQp3XJ2oFKZ8MSI5MYr0K/nsDFtX3FH4IaNLNg/13UYGWhN4TJYtDDWXXihwL/WizWx0gTy0tQQ7V7C6uxfq/dikcP68DqX052VbwOt+XbGV4hI3+OpjCF9q+uLe7wM9UFk1P4h2PgZOhNKmtRE19XnVfzLgDRKvZTkUVrv7fWtPfi5HYL1k5WU6Cpai/3RrObkvVn/HA8fglfjqLhQI7wFXuFS1D6u5SYmtusXVpqdFdp+kxXt+PeFTMoaxvWjndSKmDmmxDPQTTiXOZ2WcqZx2F+O71fPUOSEfJ/L7l5eB+aIB9aJKfOUgG4wGyWp76SkAeRnT1HPqBMMsDkK7M5+lcqljw8r5OQPnnamLqnsxeTRnoQR0FpsC+zyoI+PWX6wuCzBuVWpp5oz+n+hFxa0bN9gsbg4xmP/wlLJwnty7+UcpgP4w4RCvZYHcmFIoEOdeAfm9iLRDm4s+0ye4i1qx1RZG6WhbDYd18NegxmQUVtcyyUBCzg4xxZvdkL2F/aQFj4TVtoarnpQC7PTgTLVQvIb+pCUvcYvjynR9auH6OxkDUQ1JoHtkh9F7faUhUm8luNKvKLo+gslp2qg5QBu9Eq6BSJlFO12WcuwsrD+/gfQorlYhO24hYjBaNPD3Ju8RaA92V152JTbmK0ijOxs=
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