EOA479MmjZrX+Vloj2zrGFx9+3QuM1YnocjA28HzD241w9sat0viNSRHJx9ahHfPAu27EkEMW4y2a0bDS9zVbMmsdC3JaVlYEg97vMANL+GcYFwnPP7OIp3+eYFAqhN7vmKXzgYDX9FPTtempKckwNCdhswQ+2MZ6aarW/RUjDBsVveephpkBKx6f9zfEtV8226hnJJHur5/a0os+lZ/k3VlRhK12vEdj0Vtp69ugpGBAnire+TS04+R+QwR3d0qsP6OgUVQqJPle+5/D45ViZkjVQRfqVa6dqTX7vQagXZ2lULO+lbSUTvPr3lBqqYQ6CPJasZCtjKOEopX04bsc2wywjlNOrzyKXRCze9pkJSsKOZ0YZ8y3Qojmj2HJXqkqIVP0aw/nyUMTb5tedYddlF2pOz4LgQgsQHN5jWJqICMR3n1lBAknBtJCD+rqZicd6bNVoOWXAQV1EuOT4ULoqucyEqQRCfkmv0/K7HSNR9GO8ha2RRjHIEqf5+Gc/FAI2v/bTTJpv4e2A9tDeYVB5Nz+Y4rjRS1FovMQh1HlzDRI8RY+T1kOGVn+l59g2oHKgyecb+d/CxfIPUDtBYD1QMs6wR53W6gKiUGI27tunYh486ZZCfUpckdcUspjuAlPKkhfDNwPz/EV7f2ZJF1kgoudveVx/ClWsEjcnco3hMdr0U8zWTheaS9bM7f8OfhmpUjU57cI5ikcktQg/dlBG+KG2lD5uuVPE0FZe7P2pCoY844jH2yq4/Furw9VUp3wAZGLk+bs47tNl2rHZwJA7XkVDynQr26tpP5GOPyKs6oZS8LbFspsTAHBYiO+Fit69ZwW9VX+/inTTbVGjjdjSjyGbcATgXqIOy8gjEmR1PApOGeN43+OsvRQePAUdv2oFtq1VCfcTypTxVjrug8g/i8rNVcEYUiRZHA66rCqfwWIKcbYvFE+NPkAAySxGrO19FUDWzfvqfL4YT30AbkUEVdvhoRtjKzseGq5o9u7hOqBQjIqByM039kxZeNpdQ20QinOw54783p0C+xIUeCq6skHIR1q9dt9u0ymrRiiHLlhxpFq+AJgnmZ9HGRxMw1pODmv7VZ8X7xfx/4Az9Y5uaRgV02ACVs9jmWR+Y0YATUG3u+tUxhZaq0jPwwZ503KH4sEYObJw/g0m0abZfj0MhIYLpFcKXbOTjHxxomxIu9/Rh2gbt4yymbUF5ElOEAVCdJaeVJ5x0U5yZnGyDGmDviipo2iFuiKBAwvJToLkr5Q9obU5OAleoIQy5pSrwcEDnwvYFFGcQJDQYHVc2laHNJwALMVM3N5sM+7nuDuqAkqyxDloFVZ80frs7n19waWPs19yWlhK2FIaYmW/+T17VUSRAWWovaAXVV2X4=
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