juP6eBLXmSGawsDDn5qLqWAkhhkLNH8acZuKgcY3zaM/IY1gJKXGfVeybeQBa3G8KJjVJWSGLEWzmzX9PQ0cJO/Fzwu78vkGdNPLuYsevHP8V7+igOoA2zEUd70nKEdUSyytA9JhDYN6hSsUcYoaMb69iiX2BzKEP02GeSjwLFlCsMhiZ9SAMigNyFmEyDyQwBxfiQhKDBSEfss0E2Si5z6cAKKmki3J4LwmCKYImsRDmoLkJA/3WMRQDB7YFaZZdmzufwfhTJ1d6BlKcpGQUnk+vNSbh9YuyWde5ngBv9kWKudYD5FvhhcdTu1OoCZYid6RS9lSWoeQQ1MPBqj9yq3VHwB4P2MY6W6D7wSfToU6mvDic2X2qkGSfi8TZgdRIDSdYf9BVdp3WyF2O975+6+8k6OPdwBLifUCwxtDmooI0KSHkQX97dzJx1+XcbyRFf6Ij2Cm+/rogQim71rJAFIgSGpLPh+im93ZB/mAr4esVS48lAQgsUOU6phk3vPxLuHA0uU3Me4tyfwl+H5YpWPCyb5X8gLM43lUFaH1ztvX4in2ZnFluBFz59EyF+1qUtIfAWsjntiqdl5RgjLbWCgRMD6H9mmb0CNuFtS6sY66Do8eL6v6fnaE2DRDkXrMwHZjkFA1Nnrba6sk8JW7MBV8SkzDAqdix+5l9umaFdPCXYqsWBGh57YtD4hGq48RmmeQBs5tACccYmnV3HrHkp8KZ7eD/PzHq13w5KgfsFed3BBVt53uQXY5Dz66iPDm32cj70sYVP4/xEtADeSgC03uQ7uUaTWG3r4rmKn67c+CIR7NTx/lOyiKAzPYdVA8ddYFAPedZSP61F5W34ARm2hEaLDkbLfgS4msOcFbauWgNcqGFIwVspm51/lnB5sAv+t3uY4Qkn650GnQ3PwsiDhiZT2C2psIY/w0FcMwQak3k/BvTogjB37Tj3tkanrBxKry6IWhs8cNBnEw/RN0ytP44Fxw/DMDocnDKzbHoKEt76gmn7nakw8uSXeG4a/Qu/DINxUKDXS7BAzOJ8c0EuSeblhbeEIofyFMCYEWkLf1cNbxWw4FINJzvcSvbcrUKLyMTR0Bj/WmlUWC9Nj0nCKoSRtI2sRyzrYsZELWE/isv+PSKNj5TdqO51F8P+mQ8bgZnIju4fs9zuflkGTYux5utgo30+mnwLKZL0YM7hBELYl32lJby9KcejZNtsJh8VPHfRjVbFN5nYqR3lsMkBQY+rq7asfo6x1+Piuk1+uMGYkbY9/wboBRi8Q2DWfhVSxJ/RTRhcLHM3OApQ8f+SDBecJ6VtP9urZ0BykLtc26l8gLkP7BposFagpWQtGNdN2Mdi82WuoxPmPAfT1d6BokT9L4uvix7BqK67o=
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