+D0kUqgEiTQOV5D/xccUOOHjnnSKAuW75n3VEc25EOY0baZLzTm5+vi0NM/j+4botNnOP4LE8GvTUqUjAyKi9x1ap4n7/DY5nBiW5ijHlh2lJ1v+Kb7e8YXiOoB1y/k0MUoucgdFkNk24QDyJqig3YriwDd32ZrBsEfxmYsaz1/ZIJikNXuAShoztjymGg7nj7p1W2jjl6lCGz7pmlwMI4rEAQFPAwN55Oqfv3pygr0Id11ASFPsr6D/ob4IGOA3dZQpgio6ECGuR1kdftYGBhQ3k4lRzuw4iF/TlZWdR3DGAVcrFStc6mxLfWZlyHO52ion3ZzAB9anLz/xPI4ytAUHt11J0x2Ng7Pr1jOj6oC5FBUCocnLn/GR4VYQL10k2vSeB1Y2PaBsnQxTAF89HhPCbr39qQGz7Z+yjpd3rJN2pHIQbisyWGasr9Z9bQQpZ7+KIsBjGA5UCpNYi9VNNCGrJwGULpa5xMPe4FaQfgW3mu2NKyw7HnfiocRAc/NXC83CkrjDzstSiiNuZc8KMEZdlhM+hgS8GWecyDI8WmKJsHCF7OlgpOOBK4rQxM20Y4mzbruYm7snWu6nMuZR1nM08pLjYq5I7ASprdrfK/mxTCKOjciiBthcoxLeybHvXwMnmU23uIEFLbFtLcnhLuAH1xAFaTtv7q+FsG+zsoA1beJlq+Fk9qhTE9BwMXVf/tL3Kxe+QnRNqWLHvoY3jOkSTpdKdLSnTej3yKb/SsmvU4h3MUENfsnonLHzniWYURyS9v2ESTHQqEtViKPKF2RCHBtIsgV6QRU02INBlxklkCf0YqwUITPdY/yD8oN1bK9zWuJYdVPV314P/CSlU9bHE0fSSGMOiviq3j5+EJmWVGwAtekj33MU0Uj6BeLPk9A7Uby/l7d7Fzw7+xXA7ua6d1U72eCHFer6/MtdeDUDUtq/URHJUv7DYBB4imjLXE9TTR6xxY0He6WrF2fLyhXsV8iF6relvo5OgIaFfXd/lJqafY3o01zk9VNkGrJYozGgTWcXacEmdZGGvQV0H9+EBAM33U1k3QHKkwogyfRojlTdxWKbRPlqBnQ5yPBtq84nkKpnl8Ma8vrs9/M1WpKxRGXhXQq5vhbfaRtYqdEsNI/faqTrQSv4fv5EPEXKm6R+pEO5RrDdjYC021m9w1MYMMpRfz2oO84nbvH5UTdnJbRkJuW1NE4Wb9RC+S7R0cEkjn30yonH+ds8LtQWCpjK8QYfOFKFv635GdmSMozdMFWMF6+FtdYxhncKeAmjmwbIffUzWERC2VaQgYharX4Y9fIxeQBNadIhYXDadg6aXLfU6etg7QWbZxi92x0Gy0dSInewOHktOTtt/Sb5XVwUlB7YdlpZ193cItM=
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