v1J8FrW2pltzfWK4H9vVgWWShEctkz9HvayAl1CrjqdNISiK4jeaP2dB9VJN0tbj/gOUycBUgfQSHhJ7URj2g6WzNA75ViHujuaZW9u5O+Yy2ZfZryRkKaed3hwhlp0lzu593J+4uh4ErbU19yr0cKvz4wPMRe2HpH7h8b9bXYltrBu0118wpSSuKuflEgOiB6hFvO5dwe6RaHz5cYSFVGhZnnNgpsDezTeD+WPrznECWoWlAwhgOuGjHkmujTFRPH5Cbz5TY/daXPqvAhhDQSMn9AdMMK7LJyjl4x6MgQCCzFBQ9XJuYdHcdYPa6H/KVatJciqX01zs3QPphO6eFx86qDnQF8dqrKCBjEvghUqrBzKPrVRmAQ76Pa6N2U8/yV/6iYKUYTjF6WQT/QJtMvQ6Qr+5EX7h8r9fHxsqZhdTCifnAYEyWBBVwsMbXOlowmGU4nK9LRqkJAZtslKgBNlOl0ngJpTp3XA8zN1KUXzpy7IvPvHs8en1xY7Yt1mdsl4gi0c4aDklz7mhGEqzP8bX641eQAUV+MHGXY6Mqs1q+0aZ1WwY1uUh7PGvLDWv/YofKZyuElfSddp0HkgDmDPW01zF4m0NvtqKvCGbocRUdk7a46NQn+Etd0Gr0DEn7JgKW+4mk14vIzCavcdnl9McFlvlyy6nMec1ioT6i/hUmEWdUa+8y35U9xvn5iEnfSXERk8BP12bctVD3POhu7k7B4RWuG3tFLtfy0tkNE5QdXcQ4mPkzIZpYOJK8CpstxKwGsSYHIDM+61eiBjxIn0lfeKNVKi9xnPnP+/By3Yb4XWcvnDR/iG6jYaCe3RymulXwpeNGVuNMiKCbHj8I0K04SdCgu4ug+i1fFo/E4NCsd0tWR7SP+3nXfSfpKiEy02wxerPOC26idjzk9PSjLY4yjrLLsn/GN77KkPQh+SC1kZJe1n/6IuiEUEFhj8RGaTw2rfardYkH+zSo30tzMcKUDA5dafAEZDSFph93Lpn0PJoTd0RLxs1pY71j+FjWNLS5h7/zNFP55O/Gt2UC6IDwTDUBUX79Q9NK+8yyB4fq/aFPpfJ1IHxtTlFl2ygPNlyHVT6tGBEmc+3qkvU/E4l8B81ywS4aJ2sRMKZDrCgtp7veRYJvXF3LMeI/8M2hWOlbt8h+pmGY5ZsNGBxY61IYWt95wnfUSY4KTpg6wlmS4Kter7FtgNfBFQk9Dy/rjT2udbbrxujaTejlPBeGbAZd79H8M1aiE3lEJ/H8O25kB42Two4W5WnhndCiMvLKevn2IJ4rlwlMtPlWplpNfeBadRBnphWV2AX4qHSC8KpkDnV2lqqjHH2Lki6FjV/2+J+EwmR9nRv0er/3oXesLHLSLAfWhzwImnC8p4=
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