xzgxYZDJnhF6o5VvuvhS3017riX4NYcslG/LqLNzKl2PW8LIygFtCLnPRZo+qwubbyE+O8D3vCAu3qALigBIVoKrQ0b0D2/PG0SDYDeUi8qXShasVx7x3eMSw0RI6xbhkQUlTVlMxPIJkmnWabY4cvCeR5kQX0v/ZOH3ZR4OdaktyxZlWb/Sy08ycfJbBZmSAsC/i85Mcpf+majlTRWrH6suhUd5p2CNzIJYzsK5R2zd1Kef258OIn+peXXpyrkZrxiiz/0nXgsGF8rGa1xDdYkGTzbowFp6xJlbrkODII/nmjH7vrZvjg7HAMeeQUtUVbWT7/MnLlCSJaooLFctZFY9y/jmFVVyqy33RIaWAjqm/nxhhe1E2J5fA5PiTRwjGTyG1jywv9c4oiO80dj8yrfA+WWjfockwKyQIVLhzY1D1NlQF8mmLUPAC1ZCgh0/aOHLNF0v1M8YLNKGnS6iWKToDw1rCqh/g+DD8H5/a9MsnDdrZarFf4f94HqG37S3gG/XZowk9ST/xRWxUT2pgI+viURNwwFFzzsIRDFLZCdHApZi6hpP50ChXuSMAoTq7+6SrTHt4GQLxNle8MyerOkYUWRFw6ty3vnya8eAWLGv8j1jOfjOEO8tTfuwDP6m+zxYzoX9ViPRq4BMdrKnaHMfmuGwYnL8lN+O/8zhg0QROzFeM4dbVCPxbISPrQ9bqNXIsfijNCv0uTwGZM5LhZ01KKJqe9b6HQ9zHzBJ5FHMH7BYXJQCwpCJvVe4kEwYK6VUFYtY/ONGahadlfDqMx5rgeMDtVBqOdB9IRgxwNwJoojLKjfmrtsOzRJToAMTzBi9oYXP7BCXQA3kJtkHlSAvFeB/sVlChQJRSGfpDDQ3DW6MN65mEWE7nbRsCwo0jrOQm1HE7PYM46rjfIemuoGtzM35gJjjp334O0I6gwZoqvditw4y1d90kJc31DTTeD0JHmsXhNt8aNmDHvmtW8UbYexQn1/0eVdVXjIUp23hDlY+4NGiTGBad/e48sqkWsW3rUOnT8+u5o+bpj6VFU2FsiBTFMJzwyAuDQsN8vkNeaugzApFWllilqYCHVnv3O7JdP1RCL2ulCgUCH7AMArgUUP+BThHXkNFhMHTSb8YKyIIpdTMIVi2JqNNSCLPgyCX0s/8tY1Ej1EzP4JxZ/JussyQhSLgSdckLr0z3wmeifyS04vjeen2Q4ULHSZZOnjiZNInXA/uhhfdBJZ5ZjDnkIynII+tgYWUIUyaCltCl2L0BdycKR8r6ByH54mW75KyvRmzymIGFX3ywo3qKLetd11L8lgS+IYM6100GucCEcAacL5t7HMnO7sZaOub3XZtk9Ta98eC9wBYqn6JXFa5PsuuhjtXuapC3Fk=
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