NZU6i8USChieO/ES5gYltvlPZumsH7i8MJIn1dm9k+z/Ehnqjx3yO/r2PsgsITFGOQMBCMlCJf9Qi9q4ys4PIuYtOrWP2wsfjv4J9PvFoVh4BI68JEXD/ntL8GRKuZYCm8lveOYBuzPcu34Q6qYLfY35HdI9Zwyh5zNC6k3aMiFyVnBPqsrVYv/CgZxPYzr4fERQqdWbw2EQdWKicflybSM9pv1aN8Zir4+2eKPDPldeJFR7Ddip51iplyA02aGdf1iAlXzLK0mI2CCV8lXUmwFJ7omJKfHs68uu22UL8c+uM0zMB32jzdXbMVbbTHbOVGBEbC80eP6S1s4T+5el0Pm6SAlJPCxzinyWMkBIZoN/6dv08T2r9lL1jAuqtvG8ZBQXX1QPxghAdMu6J2tHbcNSMSaDayzBF5qPgN2+kUinmuU+Vqx9h1DYqIHhqV0m94oXFjmvJ9A5SCIyO7iNCFw9OCbKoQNSHfyFjQq0I9c9pgK81O/L6iEh8hr47/quJ0DmsY26et0EFX3aUhuX2cP1eQVAPgD5ds8sT+RKALXuHtIdNdZmqKUtH+rXDh9ywsCYhKqyhB660sZLFezCHyAdDQY1Dgk1e88fZKcKwUsBKpcBC+Oq63Rt6LA56/OkbMwwFOYY01gdklBCQ/AR+osWr8LTorZUqQaepWkC0ylMztTTP71ONyHwvwhPuDtBJnFZJNWhROvS/33woKE2TD8SDO4BP+I6hm3jBZb4X/gG1zzWYkEz2R07eTwWmgUqzRYcIw2ga2xM5X4qZY3S2W2N1WSwfTY1vVQOp6I+KbevpX85hO/B1c9MDTk3okY2lpaMkQiKrrgvEW4DgDOyZa53N+PZEqgnd5gzSb8y1vcLKGkZwtbv0QwO5f6yfZ2lU0V8jC7byPrI4+vHIyAuBs+x3mXc9Ec3F4bobSyJIgvsFth75b9xxeEfwGMU6F4d4JBZkktGytmuUb10CMZlM+EfkbtjFdWhnCu6gLxgZctAmjPIEUSekrp6zlrgBdy+mBZKTFUozqmMdbt7jLhFLKS8aI3gHgHBETW3U6oAPxRRkVT40WiIuxwyJI2Fa8ZQRLKCsl971DStJY/qAYZKcTQ6iRRgWhddhCZVRmm4pr6CteaxU/sltuV7mAUQV/BYfLD2DynvzuKSZYb3bEjQ7NFN3qfEzX/QlMlyq3l77dLUjBHCv+pPhKH2FVW5FLXxXAdDGFlKk2MyFZFE95jprwbN15W9DNO4R9LCBnwtgIA7ZapL2QVUN2jWhLdEtqlW9Y78xKo4A1sAYJtJbMWjwPWd77nXiIMf6z1txJJaNCQD5sYkge4bhyAyVKMBljBzOW6zbmZm6Cs77nlquXgipWLR8Z1dkH7Obqj6ehI=
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