eqO1y6WmHWjFJlc2L9GPjhrzvQaNa2QNKbaCIeAfQ1rmqYQdjigai/Q7DfQBXP12tnmxDbmPRn8ZQkIKwBBlz5jIVpjABfucfhSBEC8HPLt2uR+eWlFTam5gNenGKqKkbllyyhbBdWuDka+BQOj/9rlHWbjY6a50ODzYuVVqBXgGvGS0USjDUlPHsgPjBIu0nET93yrzmwaUpmo2bOIUvHA3aJk8imdY2zMPYlzI/v5jo9XvkfYiInWDwawLcmumjpYZnprOJnaWtJUHwc/qgDw79Psdl5nBfM8J3gZgumr39L5vYHB/A4kUoWAh58UJgy7Z5yovzOSogwHDsfSRZEkmOHdzfOusY58ifATQiii/TrHwcUquhjuxvbX8C/qzGK0LLLTdAZPyz54b+YSdSFVbvHtF36Da3Akh5YutHkFcm1hDOeaDTW7K7aga0QdvOYLJ8hb1dhnBeBs+SmYSU0kRnOYqVf7NFvwyCZ+8AQiKUFuHSRAYauRpu2nitMUbE1VeZagSIwh63siBQEEKS3PlHMh7bmUMvWs8yn+3QBvkFX9mwpY9CwbHD/Xc6vyODytcyhV0mp39bqjN+seSeR0PKo5Y3AErBKbtzERko/nGIm2hAqM4WMYsIvhALO0K7vQBm4XvUxX2K/dXcDkdj0e9Gl34QMFkvXGJkn7HpV70ncyGtQWEndUThU6538pqU2d58CzLopd9FEBI+z5InYhhISRKrHUQffGnx6sWbxlKzkqy8rnbD7kGHhb+3Tub3BMU+VITn8Q3rRJweGdiiniAG3SX2ywwgxRHdcSsaIjDSJYTxOoPiE0xj/gRuKDoMrABVENjwGqSoeeUmVqaqE757uPl9rWFn+tQp8WLK2G0r/70OdLAFFpkSDHF5TvAuf0einAUa6yPAjdfDjzoPpw4Eu5lzOjckhLSSUTBMOtjVgBTa1XUmHiFI48wXCVBFiNGvh9KyDodb8gT8lZRs4H8ZqooNK2ioGvjFaHM+erarbbg3NrTtbiOGweK+8+2JYYvtTRbEDWogw+gUd3J05c7IiDGv0wPlIyOOOYvq+pxWZIWDLZFe6YYXNKUMuI4fiB/73xqChawXtjGcgiALJWNbB99bUKh+1YVeXpmR7rla5L633nkFauMGBsOyrC2ppkp54fWG3GRnA8UonGjeea1uQQ+5g7AudlRVX+bHH60zkyNKkpz5k+c8lRVpXlMnO7buei0Yg+kXYQIggnC9TGkrS3ku9XhQ0Qp4RttH+eiXON20RMuTb1T5EPjUAzRfQiSNhTm7niUr6Dg5A83+SBlF8eW1vB3dfq1TTnpjQHWAUpnePo2YzeF4UnBmlYPm5DCReg5SJOxddiBlKCFZw+8bdEBT9JhYIEu0NE=
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