VGzNc4uV4uLP/4Qk8v3AP/Ily5jsNZf7XKqMuhoW+zafbz0Ds0TMeU52KLzJz9/cQUp2QNcT189s+swfFlOcekuISxLlZtiT4Xx/XqxlyM2g1TtSTKb62S7aT4SR9odNxvlHGb2xYXPeCtv5MtI8wTLv7FKUSNN+Doi3fSr/1i4MWhZTvmjDXiPIvVsBF24emcR3hgOa8RgzljCaBanVRjlAzn3o4x/SqeF4E5YHqB2Q3I88UGLMlH4PJen7tmvyhew6Uy9Mcdx/8fC3Ovad8afv1rvF8g/x5jfmt/hv0ZX9WzBReSjKhhBRdiQsAfWc78lcwDGBbz7x8gUv6y5myG0d+JNuKLBxH/SlBtcoZKyQa82Z9SD9TnvA0vG9Mxk07EEsdVv1crWUK4LIRjZAyjxezYRJD+eeQG/AsfEMlx5tuH+NNfDJ7LbRar3SVvtRIx3S2A3Rq0MfIHlV5h26rJTzVm4YuS2jOV+wqTXAfJ9+go3pKczb/pya+yFfPaGUyKny7QHg/1OYV+5x7g8zO2t1ADIMPIor/OcEDEdmPqer7HO6kIW3CzEMnKMyfrHk2TGqc/o1AG5j9mOiwxr4qlD6knOrwW3Az6FYlW3UMuHj7M/yA9D7TmoPa2zxR1sey9HemvDkjqnbVGZlHf2zJjLYxup2i4io8yUk/ywXJzl7d4+UGnCRdnN6bHzP3ODXt8e2hvNBWVUrj1Yw/+roYOA2WnepgLbr1srDBosy+XzrsNrEd1IXwhPokWuq6Ziv51OsyTOEgd3XpbCYE5/Y42CctjMOSOb9DjHJgnNfFzVhFbtOvKV0/o93ztDDAii5KaOirJbd0a0Two9JoquztWjK51TteT5J5LEC59O6OanubR4Lv15a8uqVr1fy7ZpYGkl+NppQVzG05eltL54kN/BWqCdQFcFuns93Dl8tNH1RDQGPJnESEWf8CacCARqogh+6WnOsrt71v3aCrReB5/dgSHT38DQ9x6dj6uVK0kerQdh1P1TB/9XED5ByVOWEW6MqDt+F9wT1KZOHDpHywS+JARxVhXnD9nPYA+s67+I2t74cAm5ULlVYuUkB516qCubbnIAS7PmPBvWgCmMbNEScNMioYMqAnaM3VxwdlfX+EDraLmGaooEu4ZMHJVbfDM/HNDSXE35FwbPw9kxU7BrIxsM4hiPyR5OK0QAebC7NfwuY5Tw3BoJeaPFiUNL537oyZWn6tUa5wYV3oaJQcyRb7FvrjAJMF44mKg1Jy9eMLKSCnfutz2FovHXKadyBX1oSr8J0X3gFTK8SAjL1fJoVuAJz1ZHXlQsV6ZDYAdEAaC2Dwj4XMYkbCHoanyqAfDarjWMcbX65cbDzzH1ld+WkFP5ZM8VL0otaqYA=
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