evRO3bqO9wXqsGV6DUNE8h8e/ab82DwG7ZuVUKqgj5blmLXbyRhtiUTF11wq9URcNVrx9eLtE80F9yGNGn059A6QsG6Vz5a2byGd+7FU+0LECVtQDt1Li+YA1UWfeNTfWpBJx4rp8cwy+gnbOJs109Fr00RUUm954TEZWOk40XMgBnkHvw7x9RgaC+7Cjf6XJjQIQMqOoeCk4HqJvMhQDyosCqQ6auGY8qw9dYDRbcAmOW4GBEYZ1Feao4MCYMv3BK5GJ4Hmj//QgN0FXFxU6Wx5kjoo6SJnqZYP6XWF95vxZla7kDWHoGchyfL4+8MubSo6fE/OQDu5sJp2zKfYnyD4gGqH3pWWqWFwKMLissK9GDjnKJD8b+Pakzhx2O9vl2hTr4dP0o7Ohj+DESjl/6+lKHrTraDkpwbToBdQR6ha+OPFgfGDyvuVad433p307GgVZvNx2oGfdyoWmHwAeBkyFUSHEht+07W9laoErgQdaTXOD3Fj/8LJfxmSfyX96CZMk9AXqP+QZDxZxYm/7sLNJ5fqALYoJa8/R54yztCcJwniu6zWvt08yvWdpIt7zSzxqBVge+VUl15j0/um2jCrgVGWnOA9VraX/a/NTRqm4IR7IDtpB788S9MSyk2T/8ThxbCo/kGqfDIGKYbUD1yk9BsseWsvt3vZhMHnc8gyP+uCFs2OGa/raQisohPTys2IuKlfM6WOGmX1k7wA54rYrxabsgUFWqRHYPKPrXRyYLGk2LMVf9g8zc4VDMh3JsxfQuVXUs8iCKzAd9QqYz4nJ1FGGkHvi6u8DYYwy9JUaKtaWF+bDmOqLIUCTbSZzXrdNfp9/qxxxX/ohAKsf982I849DEJL0a16UTYAFTsW0qdfcMv5TUmWLrcC4916jfjPoPGf3urPBq9z+tJ8ZxYq31psO04RbMNTrYF63xMVYvGL+Qo76z6UW9jw6XpWBq1K31eDZJwoTI9yiz9e87xCmQFqyYw2dJYMkWzACUZD8CHR0Mk8SU81uD6lHfQBglgrkmWtGk/O0ziGLl+uih4WlF4alxaYE/9Eed4GgtlmQsMxPCIjPChRN0rQkCOM/P32g+UxaB2gNA82b5wl4wfjfPY5FXFFZ+4vZ+1uME7IB6mkNN9SDpgMrHxoYeuz+naXRrN9kh1LICrvpY9Cv8iVbQFpC1h4VabDiNtOSFVAD7e7bBSJ86X6l7npLJiocHgvzdzvK4rLf/vBOmiVUb3K9Ch9Bwp0ACZgSoJV1/n4VSH5SfjKD+iNCEeaFhVGsTAl5HTjukvUv6rTQrYOuAiTHu50SUmqg5121oHsaWqo3aOjSO/7N1mMxeZjC6csiY3EZX1c/8mrazP/b1o4ZgyaUP/OcdbxA4VM0Rg=
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