Ep0YhKqoF+2DI5iRjp+pU2Hw38t+15J8/eQsQJrlHIEP+R6Fng5DE1IhAeOGiv1E96gC7bFCOk4/Mehzbqfpu83zoZskF8ZBArpz2iSZ2IFlD4YkdOA+/DY6FjKvtY7hYazGpvWSFMTLQjWXiJUOoDvbWFZJ6rw6pBPe73q2sD7trTUiDe0KS5NIhlZm+uQsyTkkRVlzbUlcjCA3O62GAuTVq6XClBI55YIvT0h44rAPZJd1wXR87KEcaHWSg6mjCQl47G/7rj9ucTq/Lca9sr1UKrjrMexdROlI4bUNda4QgAIQGqOftPSqJyB2iLJnctCs1kV5tNjg35wIpGMJYtPgzJvkymcYDgNeCXuwlgUQrn5yTymDhXSuXZY+by1onbe0jiLN/jtVUvu84QgYulnqEU+xMp+KAY1BVRLFWkOxzWp74+6Ydflcy9PbxHmKHh85HwOfzDknO9ExuwJ4MA7Zo8q5b1auURh3z627/F2vQ6+6zd9Yx4COAgurAEa+yDC9osCu7rdoZL/b1KwbXa8Thgad2kjDzj9hGF7+TeV/HTfKPm4K+A1oX66wQGx4EC4Wr9cL8yhIA7+3pD9pMg3zaAU3tUUsOGyOQkOrRk/BVG8qZhZQuElQzTJk0xV+oz9FR74Yz4VxFcY23ryLcgoqwXYQubbA9ozzvCe+fvILD2EMZp42JQnkcG4FZffleuoRFQbxl9oUCdC4F/mJUaF+LQ65YM3S/VJoYA81EeA00M8x9nrCNXkoMDeVJFaO4fYvpmw7OsAl+wVqH+WN31xfdrQqn0SXuVAoLQbZhYe5IFYN00zGgTSQgDHbCBnyh5NtTeZQ8A6GkM/2tqOjRMXfjcs2t/ZFg5azEjfDgyYBSuDGsnGzQgb5MpHbGkrZ8h7eAlpCq/5KDaO/wJse7xRzaLhmT47rpMZvRPCWbntAruQen/HQeBuDkmqnGe5hbpCvY7Y4sKnBABBPIVoOKVLB2XQMknkX2hAcczy6tPofgnrFh5DKbtg1J8b6LJCMQo5+7xIlyRlLpd3mphQnVXE+hXL9ZWvoZu1rFKSHLgvD0GuDoGF+4qC6ECe9CI5dBsqn1l25q4vUWb5gyuUQ16/eS+013Ot/6GlCsHuGdV4xUm5+TAfAIFVxgn0FJzh0nb/Yk5Ijuc63BfW9StjbnVR6zUmNz4V67oKO0EBZhzu67MF4bYrxSXqi7qYVKyoLi9Vh0Yio91Daarzu5XPzXjoA4Rg9VoPtJuzwxlPyZ4TIBLQEtJRTIa3cbol5NsuKJjbK/UyBl42hSD3kQadqlKGtTkNWYZMiJDMR3RoMA0/rDoZLDa2wqCkolvXcXLvDTsuCx6szuBNp1CdQyWp0s/uw8ODt658xh8OFtk4=
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