rDMxn3Nz+uNZMDGMrnBvOyWMiD+rHJ/aEBtZiNAGSzXzEbX4fRSIVtibJFAdkix3pMHx2zu0Yyy5sRjgj1tOrfmM9Dd+XfacaZYNOg6buByjXOXQWQZD7t/xw9oJTTJhs3MojJVzrHs1owWuqho7AoZiwIqWcvFj8OSNKsVL/cQuYadTM1/jFl7rlIIVIHVot2BhQ/9bk2FKO4FHJKJnzPK7UPQm1Uo+dmg9XS9J5/2nKSdI4EaNl/5Z0D/BOHitbvI/zHAYMnas/EXobROYTEMuL/AIux8+2RAbflhjCC/k93jYWW5lfKx/09L05UaWSFKg+M4gglboJ9xpcOE0Sr9J42Gk8XBUT1LLqkaIrA3V6tMjwkZrT7cEmMtgLlzELguxt4ZAMnwyqmduxVylfR0OCWse5YfBq6Cn1LU8xWT/e73iiQiOjYZkbylwl+RTsKgbJddr1y8BvJBZKRsyu9zs3uri4GJN69WlpMAzvqgazPPDK3ghfZGEahu34SrRVduPHq1rL8NdrwNR8rxKyD4TpiRWYGouZVAD23rQKAXu3KgnRZIyMRYKdANZusVy+dOE90suYmmMGMCEF9sLjWo4TPeuujPgKBnanzI73WKNNC6QQnoWRUD5Y4bDOkSKMBRjsRH9sutQ8Kn0Dro6nmDl/yNT7G7aqSjkh54aKtSMj+NuWgjUrp8D3OedDYhSfkYCJ6wOQL5XS9GiraONmFuGjpgDSiBY8H8MlgbnpqslK8JEtWObkL+ktMMkTWBEWC1Hz74bkHQOQ9X12+F2+FYycNwdX3dVyBrBHZawdnYBzf+GmVr+o+++XPjRljhO5Tk+UdJKRfHl3GZPbq1E1JQvWMmWueoOmrb2wXeR7QHKjn08l6tzbggGMmG9S7yd3G/hIakiqN3nxxmQ/g2pEwkHzCs8ZfthcMRKdSZzkpJQ1EbuFo0BU1cFn7SE58rA03WqKipJt+B8ruBltkW6G3En1/Wn52shniU+Zom2+PTP22K+HIMnenjnRvcem+b6QVqD0az722+8aXnaHSN0/GfRnHpYRN7DOFv7nGKybhbXL1/Wg3QleotZF8JYx+hM5LPkos9HS1JBkAjSyJOrfXi/4YSd3pi5oxnQbGpMa5np04PA4Dd/K89bx/QA2k9099LxbY9StpeVh3as1cjIxne9RV5cLPuW7MkhtQXy3Y22a2Mccod/u9XqCPAwI/TKQ+Jbo3PjovgAqyyjuMsOdRArj01c3ZkHV6iPK41Chu03tejGArJzJvPYeygeh17MoLnlzAvinnpnBKaoc2yFdZIesXnKEAnZgYPZ6W7vp5MFJgWp04eKtm39lPruiJdo2nfX7TFqnOhwaoURHpp0yfXRd/L4jq2dSSML0bM=
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