we0CB1Rhy6UrJCzkBhc5VvfmUz/r0P1nxVCjuF85KHPKhp3dZJcYqUFqp95l78xr0w20+KoEOe2PZ1VUa86/eGgtZDgmbOKh3QBoyJc4UpoZS0MDUwHO4Avz37q8eVuLGwchRpM00954mN0HvrmayXXa6cInMx8wSietXHQgO0VJqICOAsNUwSIWusXROzJh8ovwzYM92Vj4gZJO64Y6SCeai1Hee9q1QWQC4713Vr9qkXOwUQnFqdIb1XsnCJzA1nIjlCAddKf7h+thF8PBAv71gziy8vXrFo/bNM5cCWkrZ6o3EDHqe1m15enwse8bBFPJwr3vbBz+p1tyiGziUw46nfS1cgqv2UF7alS+XQd0tHWE2zKVuzBZKPHt/M4CKU+PTOQFgukQ+cLQM0GDqdInKmw3+LRIbUeYuPSpoipQ28pqQ18iGJV6NsLtS2hpdxh942PnVHlD5YXXICe9RP9BH53L+gujEYGM55nmKCOERoZEPRXi+wCmjjB+xD+XhJusOSV2MQ1C63iV56srCRaxECx0XkEUesSfN0cKnKfM0u8hliImkX9OxuCTiSR6KbyQp6hpYAR90O617Q+nL4dFhlfogZ8nTlPOryh6dau1Mr7a2F19EO0eeuAYfcPwlHAi2Jt0n5bHsUrPZ/GzTD3p1ononwaDCbP1gojZBOKbB9Lfhnu715BIi63Ebuqxa2V2EpE5k/d2moCwtF6UF944pzGHpndn4cZ3Ul/j+Qd6w+sySWkA+3qVeS3ZeplGggp19vaW1qiq1Ky9lwGpCrtm1EIp5PZfsHKVSMCyroNiBe4QElrA1tkCMkNlvrzdiurkOMfnUZ68/Bb8l3yzZh3x1YJFDJ/XfhOnA5hO+DJxTjvXm4pqcaTtqONzNV31Wi2HmqqEWgwutLsLm26U28MrUmrQStgIq9XfDdubkKjcXUVXwOOG9DYrVptyn1u7CEbZnLsq3ibawoVkuSvNu1B1BgGn3n332PGrGorrSCemKxU+FxCTWTsynPfc/9Dr8YHJwk5+nC+ywjZFwVm+E8JpRFxEaSLqrM0tcvuqiZPjFv2i1G8sr6SqqgyuiXJGc2ktTYHwGgpMf8a2uoYgweW4QJfvqg8LKBGx6UAZOlyqzgeEH3yWeIloxnA3lTWMpBVniZLNlJwq/8Ptp9lbk5uUSNDIULtvOiLQXcaQSxc+A7t5HOQtCEySggzRqV36gHGofjkHGHTaYLs6q3wyTrpKqa1DmZWTr7sYYZE6gH3wigA7zs0vIjpVacLZKP9kRTOOTswPnRVmem6qdn1lLJMC6qVeMPKHBgqZ7ZwX/M6Pv4pwOdH80SBOTbbIPkYlE3l1D2tUT3/NXnSYAs1kYyn9wKtF2jcUd1ASPb4=
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