sGanY6zWc5IT7SwZiwsPRF/UUcTTnIPFfQRSx07eXqIxr6TG7/i4VXOBnpBn2lPVuX6EQDiXujiQUxMdlf9zQF/mn85JK7DF2Ftsx1xXN8ekHFy+bTEeHG03nV0dPnLKa0K/kGHcQ0Wy+6agVG2FKbOW9n3Aw80+kSLLGmQ8QavdzskBNafQVOCgZHj8Skz2gqNkFn39pZd2eeX95nwZHRcWD1Ff+6S2/BkiB4Lv8zKRPAagv0qFAvu/oig3VI1AA8kVOF2atnNaxj6O2vRmbFUrHppW1kjosuXee3f8GdY9zuK6Rt4Iqyh6KI6RBpEninI2LixXjLSMrAFJOOyiMfdKf2t8TIZDqq4FST9CSQx3ydvoYAXFE9wwJcmgdGZd1K9qLvjTjig2nf+67/OeQHlLikeTUZYUhT6HqbyZ/KLKNABZlKNm33NOZn2jNCSNSZ0VgclwwEhWXRHPvjJ3a8+0TetbQS3V+7V9vx85CdufuqaRnVqEmQ20y5veNuybUTdYEsoxrOQhd+GpVKka1QxgnjFZhmfx3+LPOwY+xl4nc87vHVgBEgQc9z2w6jVWyZu2zZe44K93kQgGlGHbLyCpG7n7BHZUmk2X1SqR/W9niSUv3DqYL9szK3j7otUkb/23VzDA5DJn1iCVV49lwo9E+vQwXwyGvw/ip6Pz3YeBBlJ/sm/tPWdIsswSGYpbZkGl0IHHe6+/XTqSkVwdj8lN/FZgtU0PRRvMvQmpGs0xKiBvwTR/0Z75k+VKQiMX3kdRF7b9N2IkX/NSrHPux0h3n4n7wUqdxZwr63ZyFyIGhNygH/XHxHtiRoEZrADds395A+EJeho/4W0hIyENULPGQdy0EaaVLmg3qJ4Ls/gJCZTLVWhTvFXzoEBW3OZu1HxfOIeUZr5+MYVTfEFSKz5b0ujyzwZDSQcnRifFZdqKiY3087+Ds0hOdkvo/8Q7IWNwrpCxipeOYO2Zi5fqLjygmLXdzc8EeZiypC/yw9GsliZyYG4HKcBEBQhXEHYrqy72Kd7/mqsDtyZA1F3NaVRydHjiGdlBpsFntniVbL6E2+Tt5XWUsx95r70Au+mQi10SEbmjDfzK+rJbBkCJGf3QdGTEe62BXZZuHiD1fShB5bC7ADHApPKk7HNuJMG/y/xSdQWbn6qDaiRgjv8JuT1gbrJRvLUfPU682k4UvAeswuOwFnevoZPLwjjhSF+wvQCmB6xF/WK9a70vxeMpl4hCuHA6wnnUlAXHIxk89N9/W0teTWV3wvIkQZhulc6rVwvEe3/AJbztodk7hT8wZ3jnAQqCv2dHiPxsU3THO3NF7Ez433A4ksft/yyLKsuJgH2VyruJxOy7uPFAcsVSsX+x7c4Q3qcBbR5FcIY=
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