4JQcWOYPVYFQ7G7C5CDg3Vb5bnRNUO95Jbernus73LOTN49idxUvokaw9O7Ffu8pBNp5rPSE1iWES6Ci9cDJ9vvmd1lDectcOBgPnzVe13PiUq925rPLiH4qCjxr7IohU6cKyCdgxPCsCNJHJ6ts3TMbHTsV0/lfB0+LsBPTlUZbB3LdB3ufVYOzfExK/JzvOBaKuT4bQQpNYqzJ1BYZHNjQjT2Aab5P6Qew7IMHC7I1/ValY/DxN0rLoXelvgdaexLpuD9jT+3wN4oqdhhIswE3zGWiP1IVYxaElVvp2Im1zTeCC7jj/hNax6D3CqwqyijshCYNYKFtDyFf0C0S+v0wb6oFjsvG9AvA9iXPEeW1oWSFjV2Sy9OMQY1vBjpRuNOiH+ihixTZQ2ZnhxbzsNET81UkGDZMMBx+IEkPLtzwKZIkvX7vDB/WJKaDXecehRfHRnFSYIvFwB8pxHVTDGuWQGushE/+f5AsJM2N+zwIPv6hi8ZENonmehDeQaGpqULXsU8GUVKB+YAEodJZWQAp/ei01uNG40qZAzBQQ+8IscKW73t+SifWo5PCuQXtdfye8Mu1PWyWvG1ccDOW01ROWXLFPSTrUisOVX4JOmvlKqkPTab6lZAqV4OXeMhXCIZfWy2vBYRHNLWIcpI+vL00JU4Dwe7VmauskM/JWrc0hz9VbCzXzbPARbO0Rj7zWhLRw4FakG5bdPAwpWAhEjhJjA+h3NF1JXw99/nouz97ey4oDpYkzMm3ckKghi1NsZDtJnYFkg8vkT2fzp2kEZV6FwzoluJhaIBewKAnusXVmQjPmN9JPl4I4NOGIaEbwn7BMdg2iAsyaWVqfh6q95hG/mbpA+y8mG9l/CYgz2S+Y0Xetm0jHR2rtsbneQQl3VJ0N6oWKvaB0sOKR8ObTTP4t5zZ1F0RZHsT03BReFgLOr+zXsNIQ4X5WirJeU2ftGen6CGsV4GLhEa+yjtA2Mr6vLAHT0PFmZENPNvLYYeTxiDJMdP5SKjoHn6OB/Ek+zaZ3tRqib/G21SNb2IYPCXwWAFlvcC1q0oomghpEgez/SBVogk3y9tJaiIbgnPnjhyN0Xxy/puH8HlrGyFTji83nD69i4rVW2eMFvHQyz9PJ8PSKeUtawW5icercHF3jcDxwaxgkcDR7E78mGXeM+Rg+9RVL9cZq3QxBUD0zvzf2t5b2pzqaWoIoi4wb6awQblwwmlZYZADT1qN5QEV77vYCpZ1b4G120My7G0ZjwzAbWSErDqQxYiQeLaQTfp5eJBggNove1MpTFPeF/D8Hj3ZlxkneQx3aShn9Ac/fXmzRcoAu8N0AdrNZ1PFped0/mhPQ0RFH7j3E5UP+gOQBOzNaN28sQaGTR/UOfg=
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