F6y3AkyObvACEod+eouDva/nBAAByZaeTMO40RLyFCgLfLIn0Twq4cPJ4rswiMd47hlAy7Sr6lFFQzKk1laQjN5rWCzdoHv/gwlSmOcjoEteRFzIOmyy+S3wWVRJ2p5V6DKf61atWdzZopBu51zv479pTUNLDE17KoY2H2PBMKjDIcZYkI+rQTt5FNP/qSfHDkbSpQ/xjVZQtqYM9rGf1yELFM2TkcIy7JNIr9RDP9zVmhIZSHiiHfFx9FBSigV2ni9SUQlEOqDKJwKFtkAxP6rFMhlgdPhjBdOCEg9u9kGHMDlyvlmRK8y6c59fHH+YG4+Kr8bCPfXe9bRuZD9r6ljSuoccGpFVUeCGg5zdShrwH5MRApKFDvYLXyRT67K8oCcqbjFZZyUps8DGW5k91Tydl0+KcPqdAib/uNbsIhULLDMcsHn9ISTs7eocMN7VBCK6nGsDdOHjY16lmGFhA8QYAzkZ4baaIpDSUXCJwysXila05QSu64ky2QXO6XQu1GsTPcGpczQkXLACn3bUNOI91szdVhDTAP9xbmLpyT4oGBWl8zTo/as7ickma4RKL18xeTeIAmcG9LAFqBINm7T/jccyYQjQXS3IAaD/P6Di0E9oC7Jlqczk0nV5wBhqjUJSfTSRZ9D0sqGOFKSGdsvMZnzAQwbUgu5RYVHlGGbYHMV2oXsiEVIPuPt5o2Pci/YkXC1bXEvB+qUw3LxuRin+Y8JIEMyIAuojQ6ZBmD0ww8Rdb6dECZzE5NwY3lxhfco2/86hUDNPR0NfmFJEtciQLUrgyRfiZOCJwEpQH3h50Ix3jWNQz3h2gfCv94i3761T0a/2OPKFjk748EGibh9RAXiOjkI1gQRWBc0iU7doZTG29Dc3ttl+APsfIeX78W1bl7eQTkilswyVNSqYuYN9/c9vAw3T85mkDldNypIE4yfS1/9xiNanWcWa66x5BpDg6N3Qyc6k3gUgxgRP9eZyhbttYr7KhFpPTHtcQEmt8l7NycdRR6Vz5YI+Z4Cr0ZcXowWJIQBOPxu/wFXfG8Iz51t5qUeZWxu3LdSUCyEidYgo480xZrwk/ds571GkTcRqBLxNom9zZgLWOZqGW2qS9fqBVnIcIytfVe63zG99nqHUqGPtpUFDleGeIbxmTkFzSZWGrQUzelIiI/22/Xuk1rojOCFnvlrvPmb58tpA6+6bvnjgVcFPSGTltJsMW01Ajt6c/uY9m+HxnwMyV7gdPC0BB4QKa+eNs1gP6MdTWkZq7sicokOB56W9CL7AW/ZwKzsYCxTLqE4Gt9uqvTJDimGZktrERylG0OHKJjAa1fDpzKYE8TpHT+tP4HBCNAPrACtBchj+XxndqUFvMvqZ5lp/8hLDC6ylxaA=
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