e7pk9IlE3gBfvmexSGEXpAV+naoZbwMg9IayGcCprx/GWkYNhxk9rNJRfIVJ+iQt2Q/IYsonfvxqSyu8is9gH84WEhcSoQHw6H6QLYMjkpLZPPdhWRMDKDCroYsZg5DQviPgBr5B5zqVM1WYs6bF0G5Ddq24+3tRYz2wbThv9kR4+yvhHFYCPUbNreCMaOa+7kKnA4POI3Rkk8pHaoguph5PxXGQsHZh1faj7nz2HlMe29GfQmOsRbMHqfHI9/4H7ZGs3Kzf9JEVWw/yWeVjkLc9I/fMPTtoP+4IDJ2tuPppzBuEZhHmuwFjwh+eRaPB4Gm+HyJtZkKUr7th6VgLZTbJTeyACR3GoqPeQ1ax5NjrnFBdmNLBwiN6HZoi48QzU4KEDMiE2S2QYcmsJkpY2QKI/eWHAAZFelXclB+qkj5cxm2l954UuNS82RVSfq2HpFFi6EQSd3XtORFTOOq5kHrVO7/XrSFazjtNXxvTxMH6SyqRRlIEVdMGta3t9ti5bLSAj9PgWv0HvrN4jKPfwwSZ5HO65SUUhB1+ymTBphoYcgOLaC5QwpTG61/vpJ3rtm6HeSIeekeDxutEsknE7t44UYInZ3ZK/hM8d/R15JgXWAc7TNPjffOyeof1ldfAOSSBASf3OteSdDj3xjYUVzW0R18VEgEQJUleo3S+2caHEohQYpfhPLV1nmVWNxmjvcNTFzuGh6k3vNuI8npWhIt/cAdiSTQTbulFHBtgcCJvSena8ullvLCIGImXnyxCumit1stiPV/rHcEDMKPasz42mlr+UmsB0XBO4kmw9hwfyT9ZwI4rm7abXCYTRLrsD0b0TemtbYrsfdPbclli0ngxUsYRk8FZLIdQKzdjhq22GUCPsn3GtfB1AdDs2645ERN+ZxBCkAEyITv1kKSYpsRjNLI+/bCIKSbTO6RdmZ1muEbDpWTeDe5vpgfyxMXfB1TJ4oyW18JTOmvWRaWZwu4GI/67Oyt2id+WyF2VCMHvBxECjrZoGF0qYQ9UM2U2x2quXeyWFTXN2BWJWJ9zw8u3H7TU9p4Tbiz+DdWokCaM0bpccC+X4Kyo889HXQj6E3oYCdsB1xXvmZwVUQOWF/mX/38m3GS4rbPh9wTYYTRWYE1WoGxZkfBKp2ic0olQvZmdgUwMIi4lqD5XycPyNmExbzhhPOtx96lXM5BMX5Sb28nsujka5sLt139Gh9ETzLNliSSJMj6AE3Yqyx9TIWgPreWvwM0Z7rSc3+42Fo+tTRHpDdiJVISQqlQbFBDIj63NkrCekt4nuf5LMfW1mAZTTbkDtMO9DFxsZ5SeoRQ5OplHUbQ1q/sbLlchn9ovZQIpYaFwDkugHjALatNJY8xZSThE05YlAPnuHvI=
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