zaS+w5m/AbAPqkuZDTpUq3CI7s1Q64zs2Zx5x4JL9u+DQ10uPNCYTJk4Ka/8hxL6Yk0pCVRja/pRkHBbp9Zf7ixqQrPDIlVYmDpvl1Ns/uWFc9aHgtpiUI3NzR4gT0CCreBZiHuYbqRVHgv7SdnVV0BiqAEC9WjTwOKgKosUFHUIOQ8KoWxaJbWdDE804Ar8+ALs5LSOeDLJPjxhCvyUqBGyA1TycvCxbC04Rcb8QuvMJqYxI07Lz1ly2EWs0RZTT/UL63Q1m6OebpYsg1xjkjjqRfjTWebqYqug3cYr/yUN2cFufxfYkIqM5KSQjh+qLiAqwNZzEoyeFVJvyLxAUocxuMrIRXbHcQXuK2mTry2E6UaSO1ASZzG06w3G8kfF5sfMtfxn1HT/rH7GpVda4osm4jV99mLC+EEhgl9WPnsTMsz1JJpcwgLBdd6+rfyuYXNAiOXo0+ZTU2ACD8QX+UlKaw4t0AH7vvf5zXcAXF4WZuUL3rdUDKxqK+gFOyzlRSYXwo7jROo/flJfa/YyjNXTgJVsNAwaQu1xVy65DzLQsuwxd137lMSSN/CZ3pO2vAiBNON5lwRMx6H+qiuooYkzM821Mk3HHteeW2+IH11k+LpXGf6rkTIEqFdTal/rx4eV4rBKQZj/JcrorJTpGomONbDqqs9jVEEjfeqZmtmjvzOQlPReu0bLL+XFzL3PTHkrQ3f+9i/MJkaspzQu7a9ixUsaVayVR8DEzoqqzeF5qLZiPMOgzQnS6mWHW8K8rKraL0ZAb0MhjAAb9F8N3o4FtfzIRSCaJYzaS8C/iavERdI+dU5k6wRnaGv/4v6wkqFX0lAcktqzSR95dx2bHo3pjWgDjyAi90y/oXZNBtW7o24vRNN8ClfCYGPUzZOzO9t+tITft4OE11KQelb0mnpRMCiGKHWXB7siwDs8x54vNcXMDwsrkfpSFgXg5n0l2USi3VKISiX+22UX8T41pMCXzUR3alkFePnT//jBVgyfXUbz9QG2/FKeiqmXtsw1/BL6FBZcv21PuX7rPB7JDxiXZ88vqxSP0AABAHwJK0hoo/HpcDeKLIJAig1iNwoxSF4zkxeN/OS0UqELT5dMD0IkvXIUIQ+Fsx2+bPJGLBVJ+F/ySiO3u1PpQFee4D/kx7HpZuSkad/Z+Zhj379QyRGYakjElYYj/8kp1pw8B44DHXFlErnmemfEPr1nKQCEPN/iukQHFEo278TzxmvApnaAlpnrt004qg6ZGg4ejK9QbmEPG2iSZcxKNs56FagdJHgdiyK860qCATp45YqVZMhsJaYIvdhkb1f3rTbKMltTDLGIh1xGS0S90TIVmeVXg99WZ5ti4EhtcEASAtbuvfU2yGjMXxHb5brKRc4=
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