Ds72CbKUHpiMO8Pho8GPMMx+kzKlMT1m2j1qUddlljV5k7++P8q3VNG8TWbjn5/Nz3IoYF6jevNVudauOlVZrokOf1q+W2Sd744oMLUqhOsVUyiBZ/fooM8ywyRgBs9kyOk/grYO0D1vLbmpgakF15OxGV8QZh0ngUeN3zcBEa7KQgMYzzUAOPhaAgE662mjpEpQLXQXBbfxmDun5FwzclDdJb3UAu9g/IwnwqSvS/n0ctQBk0YiktpQng00FyfVX7T0cLuucDX2AfKQzfdpEni9m8Uux4K4XVGYr+QPT99IPVPXi5+MqtSQIcfBP0TrLIsISkPRATPK9Sf4AM/L14OBwA7ofId/bDJqTeLYVaVkCM2W7GIdNvHL5ybFNE2HES70s4wPzt/YDl06kdDhAU3KOaY02DbP34fqjuShbFwa1q/Yypb4rKkEwuwrnL5Q4O3X3KoBv4897B9dzZccXIXjSBFI/JULH0YlTOURvAC8O2gPeFiYi7ejmkSq+9P3QwIDPbcaWhUd+Lxm69KsryFyTbm3iAr1kMrGkfsXYE9BSL5fpyuateJ/pWsdboTVAR+rnLHp7Br9klSpAVvKn81gk8RrPR32L6nqmfNpiY/5eMlgTsdN6EaFckEv69MUvHX83af4LrK9zZ1fsTKgmSLBDZg7NQUC5+vdnDD+EtocC/F/A+pOqdq1m5s3isy/er/A5Pl/UP3oe3ze0PoetvN9MHE7xkhXi13MYLEntJW1Q+64J4VoDBz+C/JLIlG4n4DjzYx13+FG04divgthdnoUKW8Pk3NgfitCsb44Xy0GYshjZRLwp3QyhpZKSl97yKXthVOg/xC9zr3zCZbnJwOsWSkiStety0Hma5XRC3HlR1DHupYTVewQRrzrtYfxXi32HhB/40PKnGLZ8MFDxyzBeG/fqvrZqYk+MlkC6pA2GpY2yCfIgsp2f2CCVt5IZxMrDQ9fhB80McuWAokSP1XAEJGXTBv/Z94XOuEyNkvAf2HxUhN9nqIla1kLUEyyEtApXc5T3U9PyH9tZJO76pbLaCh08cnz6r2QDB+wu+JEeELW+qd2+AT5ncJ4ZDO2WGaJI1oSmrQZP9G7reE4RaZTv0ihMex0bXMG/zVHApbL793jLnUzwmMQzUNwgtEhszDDX/Y7Y3BQJKTUnGAy1mN851qUNXgUUw50UQ7alK9c4OB1NoF05k7FKy+OrolWOd3k1+74XZFH1yyNF+DfZiC+57CapoOQnYtrEDpH9qffOMM5M9r1cX5udLJUNcLJkyNxQwvzfDPy+8Y3RoPhCAXoWrrZ6uTLGPciiy8aMLE7pJW6cMNc2U5cljwLqg3FN2Qq8RvPAxp2x7QUhCDd6uBLCb/PbFaI0KFK37E=
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