/zop1N5bjMeyTvc+N36D7qDc9aixAW9PXLtrDAE1npSkeGZdCdyVrqDbsc/UVMzZhhtTWBRlpFW9TjvLF44ffnjugkxAKV1lm/8TdZ/YbEI60HDYIWWqHNVEPZDvAxesQZgXvYsn4zmbcXY8DU9NhCqrv31LlQTj9kl7y6kmDh7//FC9d7rAjWMAJmCxbxNpiEgC5ZfSyHYJBn8H64QnXt0fRs0Kr9N3bxNOMxN3vPziRYzejRn0BxH5GtgyXGTw6nTIhPpR5gVUinaKWcyP2/Xaec/RdHKURSWUVtH3CfvHIZqOdfNjz3bd0rtLldX0qrXMXgF2K7cVIYfd6oRkDXn77khx0ai1/XRZgh2dXlQO8oKljyP9y7a2o3oSntc7574CSoThV/kPFqsuNQaRvPmorY+tLcSb03+WElaD7UJ3/C9lrTA34DXgNJ7jMb/h3S3tb74p6YqUqyKPwb2qFPw74wWbCdkuyV1JN8p9olEjulP6gLEdxKcc/wWPrjZp7tOtpvcNAKdpH4ffaVONp7DXR6Mmvp1vmo3Y7zX0cy+MlnRwfE9b0V1R/ot65dsEbDBmWrzg8IpwY8p/mo6cw+sgKCXl/bNPPwaQ10bDFrYq+08YC5i6E/GZzbmKtaDybj/7Y6+xrsesMVK93qJK+Cf7/O4RwBCLsIljlxaMGW/apUQlS9Jg5raskfDmmBDNrCKFzyLt4Sb1QXcpSQP/mQCwq3WE64E289o2vCRA9adihGmV5jVGoGS271jPua6fNITwt+M9BugCO5kTn/SYADHlJik20V6P3ojB45JaYTBmdeFQHW7CHqI9ExEQWgjS8n0gEw4X7+8vSHormDnJ93reBYm7CQVqYCKPALRJvQI2LAZgbswPHEcuF0rdDlHquEiakODnVRkDokYVWMPiQsVsTFJ++2GLyo6rvRXFEQQO639ywTw/ZIn/t/ej+aV4x/2wetLoICvb/i0yAFGoolMGCaPeshONuXNbhhPRp5e1j/WL9VHSL1J46Ymho8F1MobRhAFve+q9F51GwVF25uDDZwAoyhWRn47p9NpQk8y5BSA3d/OUwq6SQ0nl7SisOq6fQ8lD/Q3koyJgocoDzZYsMVS3kqvVfXg8Oo/Qmx1nWJ1FSwJ++DHWDQvabCux8g7/GeMCPUCd94y6EyyiFFJI4usOgmJ/3AqSOUTb7UUep9UDStP2V11Yq0q6vNTf2+N2c8q0nNMQAqVb94tuvHFmlMyJcXVNCevEPzjNuaA7IR9jc89hMELQJkNLaslffsYGovKEyLTnosbYUQBLm4R6Gq+6gQB9U4jizTQ/r+MT24KNF3PnN3Gdbd+TGmMnD98xmzb8irpDAfe4AuNaWeRwJUNfYK0AM5fDZFE=
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