BRetxP8XXB2zXK8PJK8cujniImSUhjoOpiZB5CI+vOQLjvM8PPwKLuUPpqCKX5d5d0aj85n7BkbvLp6IVVuWCQb4jJc/sq0l9lpOqcQ7wYZ9cwERNn0cJJkE0oR6BveWr+cG/WVC1F7DY2ZkcyovfTICjDfVuejUO7DTqFyD/pkM7vpuYE+q2LCW/ZLwJJNuija/5gjIRfhJxhpHtgjrElFL69Q+pMo2PWC/uo3dY9Z1+6G591YnekoE1XzIRVjt/b6OIfV3oGBnJlVeyzBO1ftX4i5k36VxUneIVnOpiyROliIf0R8gdg7gHfmWhohplvqL9QKHpUtugdOZMTagifcTzwH2DUqjCpUYUtQiy31dhVa86fsx/eGXWN1g7hs8QPkdPOdjCuiYto/30P1YRf0Xam2PHZCCTttIjciHiPNcESAGhRcU9sak4sixpsZLQ68xK+xsPgMX9wQ9lnWuzlYnWbgIfiVsnXEDtuIZC4YIGUR4Fey4SfCY1TZzq8i/cQY3Ts301Tqw50lgwALIDylW/vfR7HzyDJKepSOFICYS8R9p/FD7+GlAAmbHs/ntWxWMVBOWGNMzN3nIeTOMnuDWYJ3/+QXC/d9/KXM6aVm2cz5C/219p0JtJ14YHsTQf4V0cpAezliVeaDmFC1U0Y8MCjOc8AXVF6GDDIHPiyDBJYPKAwELy85aAK3bKv3mdG75pB7kVngVc00oS3x3C6B/kvG7QMzqHxkkdDvUnJAkeCSzF3IYFaDX+ytQFgqgXdUaAK9mHRx+9WUHlumJRSpMXmRs8FPosMzvrslv2hMSz+ULbovHb792MCV5nDLs1+Vun4f50kKZAScNFmC8eRDHZbBPnDKEH4jofkzHVkI+cs+tn3Yv9gL1sEMzlyHiZBw6nF4YAZa9t8ndjYyweYRp0mHfD4Xa3PeYwnRwIU+oIOvHD4iPp/HXHmsdASLRT/MKP7vmGA4tTeLFKtvfrCjBTXDPNOXlSeRHpWrUAvnwe7XpIHIR9Ydk/U6NmGQ9+T9h4/4W32JqBVAr6IV0c3JW2odc0EAdU7COSnJu6Lws/DY9Unwe8/LwOiG1eOj85zRT9QB6AQ24dIcUL8fMUFJX6EZ6M1Sf7tOL11gECFkum1PTZkwjtPbymefkhMWKMBB97V51gqImfJ8H+UWYPA46Y3zL68PnVQaZDnpT+09kPx4C7+mZ34Cze/dQL09nAg29nMGljp+0hkVcAkvniAT3Hafao/GMzgEyaKGM3v7098CXja2sTt32XBh4bU6S0JVUffuwbJhx1KpsbHQkN9Yb4XyrDq+Eh7fMvhbhoBW+6oPaUx14MPTGdk7Gk3F5bsZoiP9J06P4RdtMtkas0Kx49mb/UgpWH6uAHE0=
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