TBBOp+cinB8qhz+AKDXCC6JgHHPTyUreQstdULbidjrzlI3CCiHnXUTIR5u8QdaGt+Wip1M1kamV9by1Zad+rYiMBTl2uqv6Joosa8SJ5ulqKWDnSOJEtTco4FbWZGwVSat8a4Z83k+NhRTq4jYLbnX0vXGAjLk50wYXvMKzEU6NZEncqG7ylEVjqJq0ZYDtDmgxAVQrgNDfdwmXsr0aPjA6t5kdKAS9W5tNYYsi94V8v8tQN0l6XAxBnlZPewI6T6YBrUsYspYmNSPpBu2CbXZrhn+714Wl3ITx5Fd9Kdk2embpXB3lCNkTYsKQv95u+7QL+YvwWtkKZhILJAP4e4MlCJhbKr45rA0G8uMhmtTI1OOSASitToBXYXuqkYGd+RTdLnk3rvJmXkRUZfuTbVuara1xKjb6xbrx6VUMVCyFuH2Gpvh7o0Q56GeCnI+XKX+UB+PgrzVNPENghdvMvFCmxJNT+aJ0Cw1y7hHaz5Fs9yk8sreR5OzjBaJtmRWuDNoILdmv6E2M7QYuoJ1YdOlSGrfNMAXDmO711vLETCikodu2HTdRSMxCYb93duDNsbKZ8wncgcSYbHAS1QAiC3E1euzJgjOzKya6n3o4TD1i+4SENgH7PTcynxsaRG3RVDRgN94+ZVWwWfOhk4HjGLkmOMp1g6WhLV1hUb5q3CGt2NUbCh1MhG3fvSXSRYmvQf7AnPslavmHUt0OGB+e4zugm7hLbD6h8pZbzr7OBkzH6Pe7N8+yAgGWceKzakdYBCvg2rXloUqNVNeI+/IQjT8gEMdf9urwgSbe9/pSDGR6Ppejg6lR7dHuildGjnT3DTxO7ZzbjZl0voDB9EXxHNtO3W2CNgj0HnpJFmDT28T033Wxp1D5OwRQuYORSZVfWF5e1grgJ+Iez0m3B+U7mjpv5xvgunaQpXZvTGClI9gelc2YQQKsO2IXKP0dwdiGR742B9kT+3CnyLh59cUfUPavB2NNkJKCB+oSD+lhtJUch0mJK4Mm2n1HdCg4IYmdqctae89R6C89MlOXc6gGS9+NBw21er6aB5vIN0jDPOQLbzia+iEsUsO3VXmSpTLkHN0SFvMgrl0Y5Oe6mAX+EjS1YNnVB0iuNgm9Njj4jSWZ3OA1Mq+FiUPBd2WzrmFc2INI4x9m5qknl++XrW+ZbCI/cWyTdhsTJlTz+cAa09M1XKPc5bBfM8eeu2xYIM1MtJYVVwoDYAP9Bu8JBP2hhUyKCl+uRHLHMSm6v+pauSU0BMYvFzHcuST5CUNNiqgrBDeK0zXriRr16KJaGWVyY9ZT1lac6gcxx3e36xUcYmadwtuF1lb+wpKkBACSCqNueLNIGwXjZdzcb4lFn3NSbUckawkYVJ6HMK/xIZg=
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