kRiV0KelG3mnC0zfgWT424fYzj+x4fUAVbCvm9i2SMC5Z5CKTZF6UxrAttv2InconGZlE1k0L/hOa2aBfmfnaWNJ8y+mWUVmwKW6ElvFxsGoQTf7ESsIUx2Cetmk385+ZSaLXBePS1aD3J43U98PGsnRGwDP545E+bNpDaVHMcz8K+ykJcymWU6srXjUME124ch555uTDJX9t0ps0HK2Nz7xlOFflicD/G/EguK2mA3dsQqkqAoqnYHLcDAXuoXRV+piOc3joZHTZEBG0pzYcG5sucgEkQHnGffJzlZ/1bh/C0x2FmP3lx0o+6RRBhnPIQHbyKiW4XdfWvs0DIIRjrRqCjAJG0irhNr+1kaj/1AYtMoq4vh5jNswQHj5A00+ZCBD2YG4dKcK7hlJgelyHa1R32uxbkwUf3c4Xkn9bI5Afn/Jmc7a3WqE3rlolF+fPVPxxtJCEZZnCU0HU44VMQPd0EwfMm9yVk6AKhPnE0aCZ6IygZj06iNbNxIK3/9ivSQQFfWcGzchE50TkSJfmUIFk91Wqr3/8dbMK50DW/qdl7fJICz6VA4CYCZkqUbvYRaKLZbGMRCfchwXN76zh+liFx0sW71+q4kyvgHcU5rVoYYZ3ukWXuQ5IfqVN/le9INC7+Kk1eBCWvuFDOVT+YMk8vhcrLclWMUuEAa/roUCyApAmawX9BAOxEsFMAIxoShIWNbJAIhD17b+DiakN8tB2bfQ5ABnhKAFX2Wy0JPLKoBPxP9uV3aTzHVOHJ9zFDD4fsF03bww4VJ4qECropSSC3tSePyGu2NinRSl1KegUGASvcMNtBjaUNk53slsd5I9Zcej+smgzhvqu3sE8VOtO4uaTBppjYiN/DFo6yFgJZTp4vApo0YAn29yNGcvck9yOuBDY2/1HXB4h8OIhbBC2ElBp//M6KREIrrPBk4GTwOn89bI4XBzeDxP3LPMHXvVrREaltexZv3BwFiTGMliVRPS6giS3tnrzorBhMeWIau752Uy0FQ02ZIgnYv7r8HYptumYQcY6MUiyFx4c08Q849TQ7YgvxaKEG80VCp/3K2I2wFVndS3I16Tj7jcoLgms6zIge4GyoSqgPafoFNz/9+uqYERegBkWIRZw3umh8cMJoMn6rcrdt/EIqGbcRGuy4bR1KaTFSggcvp3fF1DhxQnfchuheSbBcuaXJttc4xyL4yR2HuF8Jppbt+Zsq8hrLxclVbOrl6DmBbXdPkRsYwssDK+Mg4tujFaBhOActf2deDzVVUfHRD1HgEVzZrheBA1APEqZxScRzVlpyyxu9NsglgmVF6+SvdoghcJXJlVqNY4SvSqVpG4lGWEokrcgXNbXB11lLLVl6drnKmIL+jXK3g4ElGD8yg=
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