przLsmhuUobe4bnKye30pgFiPi7Gz3wcqczEwwUWHZPzaS4wcqRGDGWSX5UeqLDHTAmkI2kIdr8EtJ23NynSC9oKtJ5lu9HX/lTXZ3WEYfRIi0L3RrK2ofZIEcEMAEDPXbo3HMZUGM1HiXkYZ0ouXm0BXU4nFd51johLRrAbimlglc1viEm+3gSuV+97mrupjRC1k35TGfZ4SDbKUu1AtrwOwxMLf7wiomU1sfGcwu7Z3oNp0P/AHt+tXKHSIZeWYFNTLQR6BW60PBSnEodhAC4PVlmBcmAe2MOT/ermJ6wsGWFUrZ/V7zbSJox6Ds39sL/vvDV1WSO2LTiJ6ZzrDFcgYv3u9lRAMAbLj3Obq9B6jSnsKFN8k8iP0ju5M2bgC5Dp+8Js+ooadHfRhSgokxMm8ZcLZMe+4b7ooV+LLYSQvzPtbjfblLfowcZGD323mHj05VQ0cyO3bJj+weY5bYlWzIql+nYb/QRQKpoUBcaLJJXZZ2Hsp+LzF7/qL+lnKOdifAeB0yOe0RbGt1OgZAXAgLo44ADNLOUp5nmwjivCJ+QaOp38oYSAmpEi6KuJnBmm1Twg90KVj2dnkiphpr9EcgKDvgzR0DIMFPo251BmHUaWFXVHOZSLTV/qUHlj67xLShZZFPAr6QFhh7ac59SXQorHzEjmcln8D0Uee6b0CyrlQvh6zI/cg0cz02xuj8KPSbWJAvc08+/hL44eVoWZ6ZFlCf1tPhn08DeIfUYc6oJXvgqBMOzUedZqJ28L/Ac6Vovrreaf6jBXvaA8PZfy/6Q1rEYeSTf1VtjRCTq8Wn0gKma+lL9Rbp4Ls4NSRvcr8j0ohCnK4LPlQPeDZdLIDeISAEhDvo63gvC2sC11vIebbxtv1vNkgi8XcFsj6Jc8X7k+TBco1/8lSdcNtTZpJKTTLKh8A9xKJvKXss+H2ZocCkpeM/SkprjfU2iL6S4B+x57BUi9vHi0fHYuG6LTMKVoUff+wBGlUagCCOkmznJj6RBxtTxA8opRfXObE5TAT0wYSD8YaVHNDbMG4Dhw9+9OJdmYNIUMcuVbPqM7/U2anoFR4KBTgY/+QAikWl6Nwxd5g6T5I9LfdpXrFiCLzBsQkTKtHgekjeq9TKSuoiHY3xdDT1CqHUqH3tkxY93/asIru7KDSkdAHi8XLx9RxOprW2nZZDuNyFjRckzk07G2VDnbaz6d1c9JAR2F3dwetbooc+EETANogQ8yiRVCG8zVfw5ls7MTxkrESHEVjGFktWXLvTa2t/TZ049QPeK8UoNxa4PokbXWuebXyWtOOdyd7mBdISykHLPqWBUZL4nc0Q5HqqosKORFn5fPo813GLFzXXPEhZaCANhxMrXROMIZOS/vVmHQ7oA=
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