pytTIl3PCNvGVbZm8vE6MUpO6K++Zvm+GHaTaupQJrID5Bpzu6YnfMl09q1yaMxJ56cC/KA5tpVT0/DIM9ypvPiQ3EA4uGOn3Xxf2mB4z/Yn6hhY/Po7NfQZBDTToa+VRBKOTtySfoNjmtHDZFiBUc6fKNjiUZoeXqcBYotDnXFdnOyMR42iBt8IhcVbxX916L24VA3Sv/vn1Q3p2z2SKpoaOq+2+Mzxq5go9ekK7g3wGc4KqubejVI6Kmp3WGvDSURAjXyOePd9ACxP9caxrk/yHOr/+3f2uu5JXBzq1S+n7G7gWlvjRu/6ksbWsnMIpQVfoGivoidAQ12q3aVluZI477E4gIRDO+mljsKAI7SdLpxZhzkFazkRvkmKYX/HToSZaBnTIAZSZpJlvRmWwVbjVlG1CczRtuKFEtto8183I/47E7zvr0vl+sabFm6TXqelevxaR8t+GbtcPGpRnPNtzYC4h2UelNQlzFKBU2vpmWDzX04pHhsbKdZQ7cbM7LsV9lpJ61e/XDR4HHmd5D+LCbfajaF26dKfI2dbM+Alju8Nd2PgOfC9RXqVH4v/laXWX9CjmfgIFlLGYYDFcfwh9654jZ/2bfbudYbEQ5FtudbIZO4DkPqS0MsOKWZh8lzBdqofz3BUJZvjBXJa3hGovCRwu89sCicjWKppgcuP5cH4JxHfv4y147pk7Cgbm0WezldhQjjfQ/BdsGgPyF8V2Vltjzf5IXWAmvkJowcZ9E2gExl7/t+WrBqJZFX7HZCT8ryYW8HzJ3UENVZY8fkIuY3Q98hA5V0rcR1tjTgJ8SPIXIPwupUzBebmrYqe1CH5a65usxW4b9O2JwfJ2o6KDvCC96CtHsG4eTnIxHcnzU7CBSJrVrWtvqhqb89haAtNh5g5O8ROfAan8tvpZsJ1WCPd/tMgG01i4SYASQIUElRKx1pT5zIfx2Ot3zFOhnZKtd6cozXILrvFwxEVjWyOsQmHfER6HMLEnPD8G+Dtn+zj+a1P8ZF+Zq0OwPnAfrDP4cb5EoIa/HasD5mx5fK6IhajtsBvLlGWqFyVp4Ry00q2pnvBUcYSXaL7nORrdtb5NKYjG0bl3A/NjhB3Frv1Nq5VZGIqdIkVv718BnZYPbkg74YfVwGRpiZqr5Orr/0DPl4DLTvqxCXAsC2Sgx9EHpmJIKyAm6anIBJUFLHJGnZaySLUuxGfiEh3QBkGJlWppaqUNHQnPuUFYMWYsLaDtqTNlAX2E3zpUfHYJZlI7QF92vPs7VPHrW8BK0vDG4NaZhmeSMAYIKODx1ihVhKI7BxJXgZIymn7CCI1yQ3esvrulwe/J/Ytbgje11Rl+/COj203Vh4Wt7B5gCimW+kq4ABwYFpJWaWZD78=
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