hM5FKKpSpaLpBN0dVTxCTZnSiOVY22zyDoqEVhR3poOiq52Qy/OSiVCjCOpv8aZ6jpko3/tHRarM7KDsipk66UH3Mb2y84IeYK7bGFUGVM77hupo10fzdUKNOJ2khmAbJs59VWt99hYjA+bnHic5XLCrTjcPRrEfUsRmUVStge4FEaxcg20TUlFs6GIIUQK6q4j/kGB9K5xxEkaBz+Y38SDWfsaYy/NKSz3gNqoJsZK960u11q1SzcHe/YJNu01tH/X9XEaWVyh2NfZu4DRX7HOQpaGkoSsewF5BUwVDZcPTicZlnyyYJ3fRT5c9lpqi/p9e7AyQqGklIBIRIicqNfe4utT0dqXbTvtLWVMvMWQMgeGZPnp5aJ+xoRSLLwsGvEMM8wUlKXtSOrqgC4huhfjRhDJvZ4JO+ouxj9zwGvOL0jgZyUQPdxI5rXH/4bZQljDZ9RTdh7jM1viOcUx7jNfotkuwRPFfocsvAUgessCZnasytV7de8Gnc9JxC8J3lDQA4gln+5LSDKXjNJj9P7v4zTqUOG33/w1T+hG02mbJbWgLkOnVQwwmi+eaZSONTfPIs3lwY90HfPKYHhy4qekXqDdv2KYOwxSpbjYsfa9+G5Q+v4W+qvkvROTUdb4Ki3YK8oN/PtUDvH00zg9Ou9HMyS4Z55gC2z5fH9BRDUWi1MI9GAxlg70BpgotTjLX4tNa+PkEo2BwE4yf522kQO3S4mmFpnhsCFUR9Tf/jEYVqjACz8F0Lkk/v76AC0lyU8WXBafJMs4e8mzZ/8jnbMgapEBiJ7B4QKRFDrR1x8prvKBuzAc5aYc0U0WM/TyrO6+OXfipjoJQCunHO5ViNc23dHSPYh+tCLKVqZuHe4uNc++uzTEwyE78vUl/xmDkco0hkp3rgemF1YrPNDahTrbJvYAz+zhAjrkgkfXgTNuncsYCv5nC/IoD4B+BKwzlTSDQJPiAVN13xSIi4bnSm0NK2Q96/aiD0LY2AKnVbNnYp/A9KpElatS2CMLkMwcCh9/LcIrVltpb9t2nS3+MSlq5qtkSptkn11lwXfN2ImDHfpiLhUX9I5a1Ru3En6e4hXrsjflnSCun3rhltoV6g7UIxIzOtU+wV35nMZi3tlzYIr2hyngabmlXKHO2ib6oW/rpLRfk0cy4w5ZYNmES3jqI4r2gYkPq1vfhQRrhm/EkdP+HJW5MZdd/rUOPE76AI1gAzqJr9juoabXXb5xy1Eam26KjbAk2/Afr7HM6Flx7IHq4tV7yjmxMR49gWnboH96x+3Q1n2oOcQ9ZbMa9PD8LzO+N7eJtHFcLDqm0IYklB96y0SgpxBarmndGrtMqIXDrR2VQ7WGlne/2r5jx8+rlkW/yDLvJJSdj2F8=
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