EmcbXaoO25GskIsAYX+ousfYV1PGkFhghJeRVjVYlDEghRxfNub4dgjbMfDTT9cBi9I0taT+ar47ZNGR9A+xSJk4hBbN6knN3TM4pIjsOnVzid/pGTgM2MMKF7Zdr7SLEtDV0+rW9cnnNaqEo2au6t+tnfajo2jwr7GJ2TR6iVBB7seY/trOu5Dhhci6KWdgSlZJ/EeudCIx5On73Fg4UQ+HLRtXdzREK0+TqvAQLxPQj/AUtOeOOkzv0+Hn2Vs/FE3bP2F3JzUpN20Ox6t1Qo8tB1CFfvLg+e3OJspMAw8mTTCCUA4LvYZCSFoaJcsZHi/q9cg8B3rqTCF9vbG4Iz+vSdJC+Fgwhz3KunRpgskBe0bdurVbzzACmAx8zTOIbrbVBHLdHqOulbv02bSpIGLUdLI3UUP+M2VRCKX3r04cNjnfWMsyfxCgzqdSQrnzo77sWaP9U2Q3rz3Bh0/b7Ct3i56BcE1pGgfdLIIrNnrXDuQCK19MWGmMqGroEOCzjxh2KNmb8jFGjJrhcJ+LLWBe50VJbHyd08H5i0AiwuMGES+JMqv7plXfVE2fTogNRY81Ao4xKJBTfd70IfNJ16HYaNIAioHfbxYB+CR877qiHpJHnVJHyniqHAuEe2jOQo5VWjAnK4jBYLLN5nhlpWYsTcHcGxsKwy8ELriINcczufupWf+/344WhIWzLSUun6AE+IVCBcAMg/DOlwAcfIbE5SlZCmJr+RrMjvOxN6y4NyT0oy9HENeeWhBb1Uj+fdTHJkRd7xnWoBIQCy6QPld4zA7KihgoOFRnEWEpx9XLNfA6kifyCTfrAK/t8qx98sq1LLW+TsvbZr38I9rvwrQQjbvKhDgPmaKlSG/2FOubI4rs4dB+n5+yEqOq8QJlXPhO1fskk0lAqjOl+MqZ0Hy5CIrJG2QpazFCFxkIzmqXR1YJou3vPeoBguz+Q0xhT73JsNyDUjkdBSgG6CLJK5gb1uYnN8qjjvLAADYk4hWdcGRe3SP/KFfqTinvkx9w1Ub6+RZ4BM0oXi2Mb8xYSqBmmbShDj1Sv2JTsZDLwOOamqbDMp5j/fiP/k9qmaExljheo7VwPzbz11TjnFgizNpj1T9JIZuaFqfNlt4C+Tu1jNDfOKEDlP9UKJ5RuXlYeOqQxDXIBKmX9hkVCNdZPUJg55aJYD6k64E6Tj6EWpIlOculOIfKL0csHWNkioK04rTfuxp7r13Su3j4v8AfXYirv5Su5nqzI7X+WE/v6wQ8BC2Eau6AauPcMLHWQAVRqZ/e11F/7KUBDNSyTGMd/+y/uvEHLkckp/qmrJ5phsbsMqEe6K7qT2uxW7rY8KCdt40MWEtlXlux1vvDfCsT8GKm5IhDiwlC6+UHhRA=
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