Lhgbj60x5FTKPQEoBDL6Xz1MYq3QJjDfjHBZPcSTO68T0EzCNTmn6ak1uZJirzfRALAuaE7pCQWtkLlEWt/L+drqCZ2hkkiyTqAwWr44lUvI8EyfSfljS2wIgH7r7pj929f2raImGwppzdPzDaZPosVMFcZFxrG5yZH0wqsDqdTJXsWEQDBskmNmomV+REItzFN9qmrh3l/2MxKDRo/ooda4v/m4WiPP6wPtcv9PohPeJS/j3Iep/udfFRtj39AsOGEqOxXrVvwwoB4qDdXvn7dj5RpaRgdwfoup5hLwu0iwc8SCN+obxIdqe01/Rykwc84JcLza5MjctH33bxwQNR8ZkO/8btf4isQLSctCbiM0igBioYlYfju5+kizQkH0yF/a1BQdaFmEM78L7niPmV33/7ZAb/fAaRLfNmVE4dANl63Mj2f7a0UfA0JUsQJs/FpKElPYDfWSAA+d/zmE4nCHC2PchnC1APrXukBkBt4ymohpr53kjF1+bbsjlngmF3rqZM/SxoykQ2TTVMY2nsrjGBUqhs8lBRxs3nnDh1a3RWZcxWlkTbxNBt13HLR1/PTvGGX8RXrmHz/AQ0q36VZc+exot7etFVyeXb03mWRFA5l/ZdaOywHCkTs+Ghtif6W5upaijyifZLlzHrG8vHX/RuvhSm25e9wp9n0jk4lX/euzN45YTtMD/JVRh3VyeTg7HSqAsZxQsxFzMWQogXOW1GnQI21Xt6ysC3pGcLFpjUvIDP7OwS17dKoVhQovC3spyp4MglbWbSdi/4grThkp+F5nf6SoMb71qo6nlhHJcVzUOOb1hKUr5jnkEFBrxB1EWRg/0m8Kp+Rqs6EJXUXVvaXTz+0vjrxMVYzy7q/lb3GzSYxsmuP6pznYjzwQ2+qY+JhU+xGqzOXEaHyeUByRzC2Qmzoco09YILPcJTUlMybdYZ03LQXfiKWxIZixWJpOcBHat/o19xhYNJXSd5IDCvizMoSWeTb8HeIU0g4XatQkgEiRSyxCU5z1oUOJuJy+T4jTb0MyY0FFs4kPq982NTOlcL34Z8IbSuQdyOBQvueiN4M+rTrytakyH2HqNzxaj2Ys6bRKcgM4Ro6eEshRNigoM+w5U7RlDiwgoNRv1vB3HmTl20M+SB0U+9/ZbSxHCUn/RICKncguE+kS8jUg1OMSubI6QwQ7NiyK4GBXQzmOyGuvFFvTdYGxGLKmh+pTwQtnpjLhG5rUxh5w5K+12ipJc8mlzXHlUrbDsshqBCjQZhJCuHsRqVwnG2D9P95xCa6dR6oeQCJaKHE0IRJy4uGwOhp7/yQVHAz5oOD67VsjjEJIWV2Au03ZRsrhpmAh6AtXJ/y6b1uS9t61VZcf6kXXa/E1uG7fYMg=
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