zbOjThMHI71muTjtd6BnKBFWCP0NikVhfPstAElR+3ThouPFAJAkAi2GMYgNvYLOvtD8u+JJDN6LTJ1wTOLDy34Zj9g749UlChcWuLn55lxe7adbQueLr0gkh25N/uS64Z++9H1dnCs7DNQR8Bp9k3Kt9ZIgt16nj5F6eR7wIpdwEUYaywYNbHTJURCTaFoLD6gxtH2zR19EB4+JzGYhWqolueDPwFsyiJP7lG67PqlQhETxkpqt9WG14ok3Caj6mJ/XwqW2kxE/r99xzU6sAmbR0ScltidaZKutGbukD0k8m57xm5PkX1QCZWdJ70AUvULn9Jrqmuk8KKlCy7lL5pRPtzlAph03a5+TJSJFR+GejAUtvmB+G7FOaOMJcKn040FcUXqRq0ANd7FKSh6p8z/FH27L5ONs3lWkG+TkSTqw+0H3i+zV5s7q4PnzSJiNjoe10y+rAu6y/u4IRxq68PV0LSuZKkBpy4Lvr+1Bsp28KtlxZO6xReELN17hlD6h2dSWH7sgtzn2QwvKm4c2kR0QCwkV0jRSzaaiApQ2YQNBWaEiXa629gbsAtgk5UmsfYqiXilH6J8RsiH9VNJ6OMncilYkomPnREPMibNjIYTWYVKdWvEr/ouxJAVVN/X7/OrfqeM8Uhyp86Dxi+vdtrDuI/TDigOrmiTjWDOiIZvbb0gBHYIyhfurPAMIJnjJfHB1VPJrB/P9ph4LY3YjIurpRN3FZXOk9K+JF3QIDVi//R8kck9TNqDxhaWVAi2pe2/BPUyBId6ulzRlEEwbZtOFKCa4Ph3KUYefoO65wpi8nl7/O6pHhFgqL2/B7qaBGd01e7JfXyOHZFgj1Xn4bdbcVIb6DfCpVdzYUjsyshBFEsRztVYRNz00AdzM9O0YBoH2hGHHxdd6D0sXPa0+ISUMv/AKXLMVBsuHCYlJwabqLC7N0aXRLSslv5AH57RLolATCxf+Cl7Fb628NcTHIhOL3HN0tMr03mqMKKEsfxtH9Rwte8TC0Lr650A/v7F1SIVHCg+A61wKGjEqSppyNc6PKoerKHO/0e8UPlwUHyTOtwI4o0a8fb8K99quR5VxPMgx1VqiChuCw8x7BAu52/XoO+qLFC/BPamU3KdRwbfVJKEq3BzC1qq+iBD+z5olnzRW+vsRhJCDHYpEiSf4jQCa7tV0n1a31UQhHRcyvM5vCKy8j0z/i05tm/EPCiduBgUwXxcdSLpYVnP7PGGyw9VoUeL5bXsQKa4Thueg6EOvV1ErPAjsNsJ2v6YDxhoI4TRmBDK5jd8ZpksVwyGYSvANXuSvVhXcbaTNah9i48CczLUYxHt3vVMuyBxBp7w2eTB03ZwkwgVbKVMYVIei3bUWGkLJI0ANt5ghjfU=
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