GqFyM+J3QxgCTqtdotzSm27Pq4qzkdBY1TBcQdXx/klE5mWWNLiRuOddgT8pnH2HDYMlQ0kWQBeHOPchcD91wR0bmS7p/pLq0ARfWEGhp7QGZ9nGg/ZmV3EPUwop1GtxK5QDXa8bI2OHu7dWkM0+6i5hcRmiYKyC+bT2oaqs6nedxcD8ur08+uqDucf634RPimcCixVVXqRsF7bg/jwEPVpZklvf/eYjbLA5dkOWF0QUCbpJOn6EI1YONSea2hwY9T3rqmLVCbSx+VDcGso0YNcPXMbL2xQRqYXJm1dJGuKujJFhBYj7cY0zAR4MxTla2QUnXxk+A5BVcT/evEnQaLb4pTCUbMZk2kxlYgMmtuBzQeXOVb5phzePL5B2R9hMPkgGWTgAqwgn4ddPlIaVIsFTNq1cfmQ9ld1OD1Jlg+9MnasNkYC0IACWS+pEP8Ajg1xeszZ6a0Nzlr+3bwc83eNuHO3A0meUL0UmobP/w2rs0IPnBQ/AqBGmqnVwotdNGeg7vBo6i8n80dyzFgYqP2Ddg3f6IrUHESwwuKy4eQKbKQ8ZoudwAS/Z3gXG2KuMYc/Oa+8GA3ILfP1OCUzhjFLBjnIdGv1PUKvqlbQVyCnA7upjYcv7jKB287GgDzVmnViBnAlmWyoPskT5UERBmOee1nxZ77l/ILlsu8pIXXZ/nUP5OcZCAcaDfuCGnBkwpWPWAkeGQbc7LQlYrHVRLxdqtsN2l1GZZYgQ/S+r15KMe8wTLT1GOlEDr7l3Zlj+nlY4qsqJb7FxoRWK/QykQT/zNhKtPbeR8rxvLa6sn5Y5U4VqL4+PiL/yBA8hb8f7O/5bGA5uYI2mzIcLDPS+PAVsKXGZyIkOer9QaZvPspjQvduRJcSqXSlqbzUz3BHTAeYfCLdTPSn4gHEsBUMjqo/h7Tz0wpxi4Idbw2yJZtT90r2rTEPQFyt570h3OsMb2z5/5Y8fIi/5fMAogUMh4WeEdCauEO3dYoDA+9XuZjTTTL6tm8SphhfrX9eSfbpjOEyPOuJ/aD+BfHLVUTv9I1ZOwuoIIg6g1MaIBiLS/derO4vv4DUHrweF1Hm9DJXbzaqUpD9W7tiGb2iowuw/vmM0DkideAwS3AzU8FZ8/96jUE9lYohnMzfV7m1ieycrxAB5KI8DoLkPiut4pZXNgqNOx2+MVxwl7gRijsUxMx0bn5ttqVz34Hetdp4xZn3VMrNxHGRknEYjhOSMFDK4Nv9iBGfc/NnM1WgPDi/NzaqQqjIVganWLf2ZI3ky6ND1APHNvTryEgvNE0dBzaPcvnqcNNJkdSClAS09BxOqzSuV6KmBaX/BX/O5RWeH/TlgIyACTMNPrEf+2tVIWV/RppITtCqTH9qujX8+PYM=
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