POmH8NCl1rilyKMEk4M7lf+ylDbFd2XWWx5m5uoSRKC5m+k5pO7D6RFPUx3oaJ4HxvUUne1AaoXvph1Mn8YzpswiM19/ykmwXiVESJHihJvv6c9DoqjfVp0EduQv/AH7QexN3Al8G9gHpDCN0pDdsSA0xJe9F6RVuTq/GeaZiszPY0JuGqjcFqXK61w60lrWfMzU61qwVWPajOL+0sfSHJONZET32yjtUADHkFnpUEHMnJUhxahaxAEz/34LFfc8us5o6jSzmE4+Ieei2jdoReX/h5AoX6YtZo03ZXKXw/YuzNOS4P5H7lX6Xmx4xiVeS3jzE60J0YkjZOrwqlmNEjkhOJxNsgMfFyIY+14zuYfKjaI+IxonUvYQV1geS28feAVLfVT6cfNQezYOhOcJqa4qIdKburHHGfNK+j98Lw9CorFQoTIIlNYXfkO6bBCXr7MuoYkUarcunmEtaxHIEy87l0zJhbt1KiLRbaUEiApHDe7IG1Ji6Qr9rHwQ3IH2APFTo24BJIxMhpZ6TtargfUOf0sDl02g68QKIUU0XrrvatF+el4ue236FBy3LZTA12INVnlQR7zg6boR/O4zEK75PdxTOmb8GG/sDi+If6lzCFBAGAtp86cmaHy1O5IiRPIQ0f5P+HFr/HeZQzS62/cTIK2Ikpx844uoXKk4INrGTXVXrekwa34yC7V6OvswdaVuoA9JlwD4euZqBHVrF+tXLJwdeo1mZX1/HOlsPdCeT04et3i/GqRqz+X50LMoR0pmcB1yFE5Ymp23LG5bbYGZI/qWMkMlglAOoMUEHIMOJZxCpHEuQdzeOr/r4nrnyG46xBz3cSolPngMkfwTsuDqdkZNPUbCg5PMrvmzVj4B57PW+7UQgfGUNmARg9T47gw7mcZoX9YNp9lY+cL0Ojz2PaAamAQ4ymzSwqVOs/vaXU6+4UnxcIsJaninq0yo1ym+/l75b+g9dQQVKSz80XbCpKmCi9HS2+aNxVDNBvu7g6SOQhPIRGNI0EcrmcqF5uHlAuYsL4WnENBcso5t5/g+CN3Ud6lMe4A/XatwuR9X+tttT3nCHkC9soNjhWFE3sNyTI8yWPeFh1/XftiK9ghj2CQclPjM6y+NMh4OWnn4vPwwMqFp7SLIQ1A8fo9wcLYUmue3yXdm5Wr/9LuzLKPoyr+5mQONA4EZfTrR1tAn2Qcp7Ot9G0fSCvEGkMHMkoBbIuf1IwmKqJSsNv/6IcuVLyqbFYlNJVGdqLRevjQMpNOcH8GA7azMD6C4oQnPUj6ODfp5duTfOvrDBZOXtvPsyMhrn5fnrSX52aere375OnYfBRXnNHzEUhB5Lx5dMN6c8Uaw+B/oJGbVqHcx+SbFN23NdeD5s6lV78g=
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