xlO10908kZugj50zBo0MU96ZZu6wBiNC3LmpUGJCCQDZ8siYNAcxw6LkcU1NL4mZ0eCsiAIaB+jg0LPJWoe5WsxSf7IYmY2eXZySz9XIaSYxCgMtswR4pUSiLTaI2QGR/Mve/2N5dIrMJtIeg2MS1WQFJNZtTwkDP8tzUY5cali5wvoX4WuZXCMYth3OJ2gUGYFT1QQ0mtuLkg3GiwXia85QLGPr/+aqpP9HWk2rVHpDwAX6MOuf/2fQwnb9BlkggYL8VwLeaOxCxhkGXxQJGbGWYisCR8tiqVZxCShQDHndBwgTqDjGRwziLtIS8rZG/eCGAkD88wHLZClcokxAZ0hlLL6VawnGZ1X52mZ13fuI1tvYhCWPdPwClHYIb/chb7YQXi0Cy/QIM/qG2bPFt6Z0OSDTvGIF2g7Pm4n/cWEk+vy8swsxiKnz+jVOg7pN+6msOeXXuwFi7YPwntB9AdgPbKAPwzumQo3o+vJorTGKwjTRrny7VcwUOTIe6R3i/JVFVTqEko6ZtMTHv9qf90zAAL2+dZhpnm5D4pJUgsebd1ovwlqQLYd34zl8JTiff/bF3SyKYRLUJYmbhLFO/+xo6d8ha/P29528YCgisky/GwsrJM75Ttev+q0uI4Jh5AARuigzsFKJjOA+EHsrLOGpsABwU7BPiihPSys+nb/tNFZz/JO5FdQoJ6acm7/zuccKjB0Z/7+Oplhwp4lGqd2L3KKmeZk2gzKW0iQH0mnywzmYePKMaCmQvVOP75pfdu4kN04YOI2QOD0YqixivJPL31oyaPs3qRtv6zDDGpwJo3ctoY9RTj6Ruup0cRQvhGrqCkPI2fFvQpabExfvi4hx2VSgHFXPW94LZ2eBpH6RXjmXNQWKuGO32lH+vAc4ucQPqzKdOQuHXHUFE57lUvMitVEg5J0USifjCHZwymH8YpdFbY4Tls8OSfTKW6i6Qc3QF+G/odOLE9IXVmZHTCJ3gwJe6z8yCFW1qj95gd4Xg6q0TWJEewkfIlsEmQtA3mbH3Q4PWV3x1w62D/lpBoeG2BVbpm6uEAWEZk9+jYxRLCQ3hrZXrbz1fhXyRBaZvcKGnhaub/2XZJahl5SA/8WMFg3fm3j7f/xy0VTOWIOqnia03HJ27Af/NR7J7j5tKe97/Tdts99dgaZX4IpPLh5Hvj9vNUsWv0C5E1d7alEYNenU2HkdG4voGPl3WI/imiWfSHQTtegrHhp33mVYplZWLpBARZxD6WYUZj0HgT8z1/h+3bOlRfJkBfzmLjvXZ2PKZ+UlRBP2jKxK36qVFkzPNrKnqQBtxgUwYQfFkokrn6+E/cOvqUxCJ/koh2aOu04ipb6e6Z8kuQUtzou8T5GkEY363zHWV1sa7+LpGG7FjwhlL3Jv5VrWFPTkKtVxLEK4MAy4je77tw17Gjm7vn4s7BFMX2a7q5RKUGXEjUI8hKxk8OLgcm1F+cg9pfPETFgY6YMwXUs8uSEqtU5gwcW+qy1GmdGCXP5bjh4ZUVCqrfiUSh4rO+FAdPn8JU6gIiXNk/bsH7klMz5gVbtHbUMWyZazKTT+c4ahK3mytiT1AnDOODBA8omrQ0RcSZAW63g4L79GxlcxPZ9tX88z6MMUUHA0I6KvTEc3d3kT12x24BkLvAc+aiTUs/e56BaEb2ely9qB2iMqkd7cKVMDX7HfMRhshTyHnVoF4t10ZWY2t6Gfw+noSbPQoCo=
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