MevF0GaC6fPuFeVr0rCmm2vw6jcbJi4WS5YcDFGRSQQgoeixBfbBr7A0+VA9E1D+3Da2A7j54/gvFV4zloe/Py+PMzut/7L+4k3lFS9Mw/m5Hry2SCFoVoEBf7JtLl5f7hPXhKpOlqBCgrGTYzAoQykO0volkyJZKokzajrF6sJuUHeBamdb9F0B3b76sEYRZSFban9bIZfO/rwwGc95omUCEgCiEsK0v6tfPbQoI49wqTJULzP04nnGti8Q27lt+2T7NtYeSzKpNYwIMaUK6wiloerRFTpaDgoBjKPGlH5pS+f/r6aiBgfGcz+61ituyOscPAujlfS85WJb7Cz8hwjqcVKsM1yR6zLPjyiwsjVjUZ/3JtMesMMLRDcO8T9n+eEbmChpCVaRJiB2rpbcxhlfQv9g8Tb4QBpMQzLylx7BAl9IZAUqhLrpyNE0A646o54eNrLk81YNvqeH/d5bjzsMpE3m3lQsFa2cZbgTf6cBrhZtq8L84lVKW45vdlew1tVI/QyORS+zsN4v0KRMEv1rSVa51MNkH0mz5aUavlNzjioNJ4665PBTJWjTa9+cEpWX3B278HaGORp7yzv7BRUQ7v1gxfRx4U6+hZXod9x1s/f1xix3hqvYnB+2aTNbIYEfOPUgS/96Ck/VMTdoDcic2pKm4+UbSsnnivp6TtmFrbsnoLbBWHudHkXYECxwDwgqz6CJze9CLglNFd7wjV95uzNmby1THvcI934CRhsYbgJGoX/AgBrnhvBAwKeP4V38iqZf9laS6bAa+cHZU9qEqIdnWIjy9C8/7ZUc6IZoZ0TA7ds0T0xsw+dMaUMNpnffbL6oI8i694bNWiXY/q3ZmMstj+r4Yk5UUlFzvSvHvlvnZRs7Z3thjn9nZNt1LmtO+SjEoKkl18zVRSjHmvWd/arhdEYu/YF3fhnzlKJ1R0Ctjg8QLjgEP7LYtm0AffY3m942nJwTnPpKKTbve8o0wg0uSg4wYqxa+8HOn0ySCs+sGhrJr4xgcKrZwrkjhXG1HVBpBiWo4AoTGOprcMXDDCB7lJtnw2uXUs5G3NQGwVhTP8grCGk3F/GzKiC8VKdhM4RMQCG3ehATOryaI4xiP9MiGPAManjpZm2vtkaXGg7f0BApKKJkplJh3DKmOhFrXc+PwwH5X9YwnlffP3lHjDLqFE4GeZT59Z85qzXMG4n2TcguRdn+/iFNJOqh1Nex0NMizi76Mt4ysle0Hie2L3uvbOrSLlERlCcSRtuiZluM9oFZVoA10BQS/sZropJ0EnUXPQy8PQ3/YFPH2DHP7btXGuMzBSS0n1fF46n0heukSQx2X7vTZbRfmAoWlne6ybL0bCrAT9Q7MeWeB07XebzUNwSje8yGEUE=
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