v7vqVajck5oDmq/okt/dBOYSvFU2USmu1tuFBCXdpnH+5vkWxWoksf0L1gpQ24alOiy5tmEtOKsh3AOSYh9Ff1Laxj+8FUTGi4CkE5sfysJygAMIQCu48Bv56fJPddIQQkza3E2UmYJeQz2fXZEGh/puegp3/nmjX+nOuCPOS6mRRwu8sg25jmIhYepJ6gDE2syf30+zOnraRhQspG/50keTEuObdee/o8nNzPa3BSUOaqeUJu1NcnOHosWLhBtvQXAtCtTFtFFlVT4uxbSloLJ1v4XEbWJK3DUJHNnUvdEobMepjzEd3j8uNz350XaQVtX4z1IRleYntnhVtSbm1S6GIaQLdz2yek/LLQzZfiDISlQLVaPcSAiC7Btg9Sn/4yqlJtFpL2bbFHP1AuLHxnPsxAda/c+U1v3VZM/gafwRQQie9E10HYMj1kjf21vzs82c9/itfaJkc0XPw2B9MDc0RfC8qDzJlAui1kh3gEqIkivcf5+eZhFT8b94kOmFiCuemYRoqLkxEgvqiVnSjKAWT50V1VzqtjC+IBMAC2iuhwYqmF7wwM7CjuFN/4+xHaIDBlB/whfI5qQnrTjfoS+PLvJjUjD/Xm4YsgW9EJ6S1Zu4TijKuP1+LPUBYEMePM6xI1jGq5IA51vDfNJOtJA3djuA6d6ZSXNTHKAwtJS2yE0rEDwSiGCH6lfQfsLMko0XTwaaCr4VISF2bKN1OFb7N2m2gxuYBB1IYHbCv9hyI4A4Ai3wd0mnt5CR+/ih70GSIB1yb5scb9gTy8mPGSENrQAll1YeWrQhGQzNtuVwUaVaXQsGkVFIWg5nLYN+1aZvmpeR/qeVFZDHSKk/GmulKwMRYP5ocZfJt03uijKaxTm4hZAHCIpe4brECTR1RQbnk8DJ1slGa96vwussKiwdFZpPfIh6dlqDjBef8WqAdAZKgv4rzP5CkugODVtHi06ikJ/yi1vv+vTHyD+MdwvVXwjIPAuGBArjj/M9kYTCA5Y7u3afpWjFFWxzHKU17/WagbEYYIRcoMFHfKEYrybZzN5bduF3MOvgkiT1x9MlIZY9Vwn/BA30BGj58azCN3GYX0MDxuLD3XeXFIidctHh/Zs3yOvIKl+t/mY7Xn8ZtNgtdECnd+Gkx0R0tbMk4wnL1AqZPg6YC1BxjT5w+xxyOCAebG9saiAZY+VPCWaiG+K4UP/XUb1YDALXyFtvD7gcm2h+PMYKDLeIeldi9+Li/knPak5PReVFTa7T01PQxSpLdAXh7VDDJ488FadAgK52zM7KktINqv9mUxm7VEJ+8YEKNo43uCOp7X+eT4gmWH4Zt3nqhLYgxviHTwsvC/SYWHEWDMulxN9yyayJzBYfuJFg9Spz+1oPkIfprccwr2BP1EunOMLupYD2XHpppMZiroonIsGXFYj1bsuetM01fFdV60GKDbar8PDBoOKax9q2gNgHhGD8sg580vJ66OJMY0/3IKkIXAHaNWQSsRgfNl0QBOojoihsC8bO+LIwapPbSIVhO5hz9PJmR247epkJm0E3MgPgj/soTwJRzTMm5vM2B3HrxrJVMzmR+U0Yxmxgni0MY97AitZrsUmJk2Snra2SpDvAfn5j/KaGEilf3hYBGFuclqvoLvlvTSCazI2tWiCdGe2sW9aq0Px7Gmvb5XM4F2QPcAD4/J61yPzzpJB8wid89s3k/o6nAiT4qL8Ud1fjcHercvM=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100