3O5jV2vd8w7GAnuooMsRhD/Mn+KeHW9cTTUYssU7RiCB7jzpuuEqpbo4pn6EJMDGZGnWpBRtQjQC01wP0T/iiuBH5UbSQxG/SxIYwclVe4o4cQpkWwa4Le4s9CF5ggoKWKjN26orfrkEKZSpr4jI5sf3fDZMf210RLeXdwDjncCcm1Ix6WrLr1qsmjToU+dB90NgtGG451CsHh11/YGMDZeBhRrhTsyxWKBY6f0sD+ioxfrC8NX/l9GqWKNZnreyOYecL9uhmaq4ouSHx2SuaAxk5/U6BlQ1CQ9Bp8+wGVCqaBUmndPu0zNiWoea+naZHUZXnwOT1BcV9D+jo4cvwa5UIDCI1sGQUSB480nk5Y5BXTkLXAXKqZMJyoRbwZsud/Ur2MN25PybL5Bhc+E2AHTwM0y71NvB3jG/cwxj9VUTB/Ybm4sbfce/wiOy8cBN1B0v60AadJsnZfFiSm8orTZ2rRTZaPoAfo5FMlUHh83ojFBljcBPpmrbL/CpAnXtyjISnC/R9BpoEI+ZAbizWmLkOCgOobvRnfKsXL8eCBHD4Y62LaZtytM1C3CChLHwVvpXoxh9XHBrejz0bqRj2TU0vIH/3nCmtqdhdwrB7jvUA/EWd5QCrSJrHPG7l70uccXU2PGBT2XqEIhrGmxFw8vwdIapfyw/asV56yJecD4elF9MCzeQwViK2lGYkba1S6U8enxLcTAtC4VwxGLl8l7bv/8Q7qORknuvgf9hiIUpdXwHrweLG55leq+fyxxZLYu2Z/uGKul3EOtORED0RrwtEy6/uMMGKMKog/AMbOVAzQdnMHp/0Rpp0LvhuZaAdIzgogzD0tvAujtUWsJvwHgoxo+fxelXYRfotoh+3wcRUX1v0ll4F0I9ZlccIBtbNebzsMTuLiI3mdcUNe0QtzcIhS+/+CKkhgLlTLgh2RPZgHcLU9Bvn2li/F+ykQMlclGjKAuDd7nBe3Xe0htZlTlD0ntEQ7mUnprSo5kdEqIlxhysPSxFkvOVkyNfAUq+bRmaIOEOpZdWeRxe1JF048CmnfOrBwiZKJnnlaL967UggHNHw3Y8FSCBwjmEdgIvxilQ6Fe1dSyQBdXsmmyNRErtKyNQ4E7yUBaxKHoNIDH4RYEc2upkHRPyQecHiBiqDpsHA9b8U2RpmkXLi5p43KzrhnAMOx2YLNSjOuWbEQ+7P5hKYF8kiv6Gi+TyO9Nut3UY+K5O+0PUX0Wg8qQUdZpa8gzrU9yYGQNY6+KKPPkD4jeOt2gL+QKlWknRXuZtTqDpl9x3IaHrO90Uz4I17ZqLDgWPLLP2wwxLrGCdSZZ9Q+zY9ifWQSXVi+ZhY5GyPrlA9CJs476yQ7STWgkKNpUx2MA490HiJCnIl/Q=
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